web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Not able to get 'assig...

Power Automate

Answered

Not able to get 'assigned to' email in flow

(0) Share

Report

Report

Posted on by shwetank

45

Hi

I am trying to send email to people who have been assigned the task, but its inserting a loop and not sending email.

Also the assigned to field has multiple values in sharepoint.

I have tried expressions like:

items('Apply_to_each')?['Assignedto']['Email']

items('Apply_to_each')?['Assignedto']?['Email']

Nothing Worked

Thanks

Categories:

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (3)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @SharepointAMS,

Modify your expression as below:

items('Apply_to_each')?['Assignedto/Email']

Was this reply helpful? Yes No
shwetank 45 on at

Like (0)

Report
Copy link

Link copied!

Hi
It didn't work, i think because the 'assigned to' also has multiple values.. it is multiple value column in sharepoint...

for the image there is only one value but there could be multiple,

Thanks

Was this reply helpful? Yes No
Verified answer

_Ken 120 on at

Like (1)

Report
Copy link

Link copied!

Correct, the "AssignedTo" is also an array of objects.
A couple of ways to tackle this:

1) If all the AssignedTo email addresses needs the same email you could convert the 1 or more email addresses into a string with the email addresses separated by a semicolon ; like so:
use outputs('Compose_string_of_emails') in the TO or BCC of Send Email action

Was this reply helpful? Yes No
Verified answer

_Ken 120 on at

Like (1)

Report
Copy link

Link copied!

2) If each assignee should receive a separate email, create another Apply to each loop within the Apply to each item loop, like so:

Was this reply helpful? Yes No
Verified answer

shwetank 45 on at

Like (1)

Report
Copy link

Link copied!

Wonderful!! Thanks 😊

Was this reply helpful? Yes No

Join the conversation