Get all the people in a SharePoint Column

(0) Share

Report

Posted on by pmwhelan

377

I have a SharePoint Online list with a column which is "Person or Group". Its set to Person.

I allow multiple people.

I have created a flow and for every item that is added to the list I wish to send someone an email with a list of all the people who are in this column.

I try this but I get an error.

Thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

What that's saying is that each item in "value" is a JSON object, but not directly an array. This is a common issue in Power Automate where you cannot easily see datatypes. Luckily Power Automate is usually pretty good at automating this problem away!

Instead of trying to create the foreach loops yourself, just try writing the append to string operation on its own and in your dynamic properties list, select the Display name, just as you have here. It doesn't work every single time, but almost every time power automate will understand what you're trying to do and create the loop for you.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Copy link

Link copied!
Hi @pmwhelan,

Here is a simple demo for your reference:

join(variables('users'),';')

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
There is no need to nest loops:

Here "Crew" is the column name in the Sharepoint's that contains people.

Within an "Apply to each" over the list items, create a HTML table from the "Crew" array.

The expressions in "Create HTML table":

Name:

item()?['DisplayName']

Email:

item()?['Email']

Was this reply helpful? Yes No