Unanswered

Getting the item DisplayName for email body

(0) Share

Report

Posted on by Power_Automater

351

I cannot work out the correct syntax for using the display name of an item in a person column. I am sending emails following an Apply to Each and the following works in the To field: items('Apply_to_each')?['AssignedToEmail']

However in the body of the email I cannot get the display name of the recipient (eg. Hi John,) to show and have tried all of these different combinations:

items('Apply_to_each')?['AssignedTo/DisplayName']

items('Apply_to_each')?['AssignedToDisplayName']

items('Apply_to_each')?['AssignedTo/Name']

items('Apply_to_each')?['AssignedToName']

items('Apply_to_each')?['AssignedToAuthor']

What is the correct way to do this?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

v-LilyW-msft on at

Like (0)

Report

Hi @Power_Automater

Has your problem been solved?

I tested on my side. Can directly select the DisplayName from the dynamic content.

Does the person column allow single selection or multiple selection in your list?

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Power_Automater 351 on at

Like (0)

Report

Hi @v-LilyW-msft ,

I cannot unfortunately use the display name from Get Items since I have a few other actions after this before sending the email. After Get Items I use an Apply to Each which sends the email, I have included this below. The issue I have is trying to get the display name from the Select action, or perhaps from the Filter Array would be enough?

The following works in the email To field but I cannot work out the correct syntax for that person's display name: items('Apply_to_each')?['AssignedToEmail']

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft on at

Like (1)

Report

Hi @Power_Automater

Please take a try with the expression:

body('Filter_array_2')?[0]?['AssignedTo/DisplayName']

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No