Passing SharePoint Choice Column Data to Email Body

(0) Share

Report

Posted on by DS-30110410-0

I have been mud wrestling with copilot all day trying to solve this issue, with no success.

I have created an Approval flow.

Everything works except the data that needs to be displayed in the email body that represents 'Expense Account'.

Expense Account is a choice column in the SP List.

My 'Start and Wait...' action looks like the following. I have the following in the Details,
but the data is blank in the email.

I have a Class field, also choice, that data comes through just fine. When I try to reference
triggerOutputs()?['body/Expense_Account/Value'], which is how the Class field (also choice)
is written, nothing comes through for Expense Account.

I have tried
item()?['Expense_Account']
item()?['body/Expense_Account/Value']

What am I missing?

SP List column

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

DS-30110410-0 2 on at

Like (0)

Report

Passing SharePoint Choice Column Data to Email Body

I figured it out.

I needed to add a Select and a Compose to translate the multi-choice column through the flow.

Was this reply helpful? Yes No