Skip to main content

Notifications

Power Automate - General Discussion
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

  • Verified answer
    shwetank Profile Picture
    shwetank 45 on at
    Re: Not able to get 'assigned to' email in flow

    Wonderful!! Thanks 😊

  • Verified answer
    _Ken Profile Picture
    _Ken 120 on at
    Re: Not able to get 'assigned to' email in flow

    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
    _Ken Profile Picture
    _Ken 120 on at
    Re: Not able to get 'assigned to' email in flow

    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

  • shwetank Profile Picture
    shwetank 45 on at
    Re: Not able to get 'assigned to' email in flow

    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

  • Re: Not able to get 'assigned to' email in flow

    Hi @SharepointAMS,

    Modify your expression as below:

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

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard