Convert "People or Group" column from a "SharePoint" List to a String expression in Power Automate

(0) Share

Report

Posted on by JohnGorena

ALL,

Maybe this has been answered but I cannot find a clear list of instructions....

Need some detailed instruction here:

In a SharePoint List, I have an input field called "InviteeList" which is a "People or Group" column which allows one or more people to be added from Active Directory. The data in this field is an array of data for each person with headers of Name, email, picture, etc... I just want the email addresses pulled and made into a string to use where I want.

In Power Automate, I want the email addresses from this field of one or more people to be a STRING that I can use in my Power Automate flow. If I use "InviteeList" from the Dynamic link when the item is created, it does the loop for EACH person listed in that field. I want the email or emails of those people in the field to be in a single string so I can use it where I want to send a group email. One email.

If the "InviteeList" has one person or many, then I want the output to be "example1@company.com; example2@company.com;" and so forth.

Is there a straight forward step by step instruction to create this variable string?

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (4)

Report

In my demo list Assigned to is a Person field. The displayed record has three people assigned to a task:
To get all their email addresses in to a single string, initialize a string variable:
Then add an Append to string variable action, add the dynamic content looking for the People field's email property, next (add a space if you want better readability of the string) add a semi-colon character to then end of string. In the demo below I added the Assigned To Email dynamic content, a space character and a semi-colon character:
Then, as if by magic, Power Automate surrounds the Append to string variable action inside an Apply to each loop:

In the Send an email action switch to advanced mode:
Select the variable var EmailAddress as the recipient:
Hope this helps.
Ellis

Was this reply helpful? Yes No
JohnGorena 79 on at

Like (2)

Report

Ellis,

It is magic. You are a Magician! THANK YOU!

However, for clarity for anyone reading this, in the APPLY TO EACH step, be sure to put a semicolon and a space... You will also notice there is an "Add an action" link that nests an action there. I only test by click the "+" as a separate step.

Was this reply helpful? Yes No