web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Not able to get 'assig...
Power Automate
Answered

Not able to get 'assigned to' email in flow

(0) ShareShare
ReportReport
Posted on by 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.

 

SharepointAMS_0-1672816656890.png

 

SharepointAMS_1-1672816686003.png

 

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)
  • v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @SharepointAMS,

    Modify your expression as below:

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

     

     

  • shwetank Profile Picture
    45 on at

    Hi

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

     

    SharepointAMS_0-1672892266267.png

     

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

     

    Thanks

  • Verified answer
    _Ken Profile Picture
    120 on at

    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:

    _Ken_0-1672895905676.png

    use outputs('Compose_string_of_emails') in the TO or BCC of Send Email action

  • Verified answer
    _Ken Profile Picture
    120 on at

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

    _Ken_1-1672896302294.png

     

  • Verified answer
    shwetank Profile Picture
    45 on at

    Wonderful!! Thanks 😊

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 550

#2
Valantis Profile Picture

Valantis 390

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard