web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Power Automate - Getti...

Power Apps

Answered

Power Automate - Getting Email address from Claims in Apply To Each Loop

(0) Share

Report

Report

Posted on by johnnykalsi

143

Have a Sharepoint List of work items with assigned person and status column. I need to send weekly emails for open items

The Flow works and send email if I directly put in my name in the TO box, but I want the email to go the assigned person

Getmailadd is where I'm getting the email address and the output looks like this

The same email is repeated over for the # of items...then it does the same for the 2nd person and so on

I need to send an email to the tempemail person but not being able to get that. I used the following syntax in the Send Email TO

outputs('getmailadd')['body/tempemail']

But it doesn't work.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @johnnykalsi,

It looks like you are currently already looping through the unique array of PA Emails - created from your Select statement.

In this case you can use the following as TO parameter:

item()?['PAEmail']

Should PAHolder be a person field, use:

item()?['PAEmail']?['Email']

If you want to send an email to all people in that tempemail array. Adjust your getemailadd array to create an array without a column name. This can be done by using a Select statement and selecting the icon on the right:

Instead of providing a column name and a value, select the icon and put the value in the single column text bar.

Your TO parameter will be:

//Change Select to the correct Select action name e.g. Select_3 or getmailadd... join(body('Select'),', ')

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
johnnykalsi 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome...thank you

Join the conversation