Answered

Send Email to persons of another list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear Community,

I have an issue that I just cannot figure out how to do that.

I have two Sharepoint Lists (Change Request = List 1 and Locations = List 2). Whenever a new element gets created in the Change Request list, which will be done via a form in the PowerApp, an e-mail should be send to the respective persons that are responsible for that change based on the location.

So change request includes the column "affected locations", which is a lookup column in the Locations list and equals the entries "Title" in Locations. In the Locations list, there is also a column "BO-Admin" which is a person /group column that allows multiple entries.

However, it is not possible to get these entries shown in the first SHP List (Change Request) > does not work via Lookup. Within the PowerApp, I have not quite figured out to show the multiple entries for the BO-Admins in the form for a new change request (lookup only shows the first entry and I did not get the "Filter" function to work to show all names).

Therefore I am trying to get the names directly in Power Automate: When a new entry is created > get items (Filter, where Title eq 'affected locations' > send e-mail. Until now I cannot figure out what dynamic content should be put into the *To: field, that should be the persons that are in the column BO-Admin.

I have been looking through all communities but I couldn't figure out the right solution yet. Also get items does not show the persons at all, when I am choosing the content, to whom I want to send the mail. I assume this is because it is a mulitple value field?

Please find below two screenshots of the two lists:

affected locations is the lookup column that lets me choose the "Title" out of the list Locations

But I would neet to send an email to all persons in the column BO-Admin

Thank you very much in advance for your help!

Regards

Phil

Categories:

General topics

All responses (3)

Answers (1)

Sort by

eric-cheng 5,171 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

So you are trying to email everyone in the BO-Admin field?

If you parse the people field value from your Get Items action, you will be able to loop through the email value as shown in the screenshot. You can then use an Append to String action with a semicolon in between e.g. email@email.com;email2@email.com

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eric-cheng ,

exactly. Thank you for your reply. Could you further extend your explanation by adding screenshots? Based on what schema do you parse? Could you provide the code and more detailed infos of the flow?

Thank you in advance!
Verified answer

eric-cheng 5,171 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please refer to the below.

1) Initialize a string variable

2) I have a SP List with a multi select people / group field.

3) Get the properties of the item and then add an Append to string variable action. Select Dynamic content and select the Email field as shown in the screenshot and add a semi colon at the end of the dynamic content field. Flow will add it within a loop

4) Add the string variable to the To field of your Send email action

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn