Answered

Use multiple multi-choice fields LABELS to Send in a mail as dynamic content

(3) Share

Report

Posted on by EТ-11091301-0

I have read many community questions, and talked to ai bots, but with little luck.

I have 2 tables. For each new row in Table2, I list the rows in Table1. Then, if email from Table2 equals email from Table1, and if phone number from Table2 equals phone number from Table1, the Send an Email.

In the email I need to send content from multiple columns from Table1. About 37 of the dynamic content fields, are in fact multiple choice columns. I am getting the values but I NEED the LABELS. It is absurd that a company like Microsoft would have a fault like this - I would be ashamed.

Either way, here is a screenshot of my flow to help.

I tried inserting an expression like this:
outputs('List_rows')?['body/et_attendedsemosprograms@OData.Community.Display.V1.FormattedValue'] and it didn't work - i got no value
then i tried
triggerOutputs()?['body/et_attendedsemosprograms@OData.Community.Display.V1.FormattedValue']

and again no value.

As I need to use 37 multi choice dynamic contents, i would love a practical solution.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Suggested answer

David_MA 14,614 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Your expression is not going to work where it is located because the apply to each action can only use the data from one of your two Dataverse actions, which would explain why you got no value. Instead, you want to use the value from the trigger in the apply to each. Then move the list items action into the apply to each and use a filter query to only return the rows with the values you have in the condition. Then I am not really sure what you need to do, but then you may need to add another apply to each within the apply to each to then process each row returned from the list rows action.

Was this reply helpful? Yes No
Verified answer

EТ-11091301-0 13 on at

Like (0)

Report
Copy link

Link copied!

I solved it!

I went through the code again, and saw that in the send email step, the way it uses all the dynamic fields is

@{items('Apply_to_each')?['logicalname']}

so I tried putting an expression

items('Apply_to_each')?['logicalname@OData.Community.Display.V1.FormattedValue']

and it works!!

I still believe that a company like Microsoft should not let their users face a problem like this one.

Thanks to the community, I only solved it because of reading all the similar forums!

Was this reply helpful? Yes No