web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get all the people in ...
Power Automate
Answered

Get all the people in a SharePoint Column

(0) ShareShare
ReportReport
Posted on by 377

Hi

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

P

 

pmwhelan_1-1698860684446.png

 

 

 

 

pmwhelan_0-1698860612878.png

 

Categories:
I have the same question (0)
  • cchannon Profile Picture
    4,702 Moderator on at

    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.

     

     

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @pmwhelan,

    Here is a simple demo for your reference:

     

    vqiaqimsft_0-1698893051384.png

    vqiaqimsft_1-1698893170449.pngvqiaqimsft_2-1698893192285.png

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

     

  • Chriddle Profile Picture
    8,513 Super User 2025 Season 2 on at

    There is no need to nest loops:

    Chriddle_2-1698911950819.png

     

    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']

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 375 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 269 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 127 Most Valuable Professional

Last 30 days Overall leaderboard