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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Export SharePoint List...
Power Automate - Building Flows
Unanswered

Export SharePoint List to CSV with Multi People picker fields

(0) ShareShare
ReportReport
Posted on by indras111 22

Hi I am building a flow to export sharepoint list to CSV.  the sharepoint list has multiple people picker field, single person picker field, choices fields, text and date fields etc.

 

As you know if i simply take Get Items action and then use "Create CSV Table" it will create table with mess for those people picker fields. I wanted to write multiple lines for each person in the multiple people field. I am able to get what i need as array. but not able to append the output into one final table.

See below screenshot of flow. I am not able to append the data to one final table. Any help?

2023-09-11_00-54-07.jpg

Categories:
Business Process Flows
I have the same question (0)
  • creativeopinion Profile Picture
    creativeopinion 10,480 Super User 2025 Season 2 on at
    Re: Export SharePoint List to CSV with Multi People picker fields

    @indras111 
    You will need to use a Select and Join action in your case.

    Select Action

    Insert a select action into the Apply to each action. In the From field, select the dynamic content with the name of the column that is storing your multi-choice people values.

     

    In the Map field, select the icon to the right of the field to change mode from map mode to key value mode. Select the dynamic content property of the column. In my case I selected the Display Name. 

     creativeopinion_0-1694380314492.png

    Important: Once you select a dynamic content property, your Select action will automatically nest itself inside an Apply to Each action. Drag the Select action OUTSIDE of the apply to each action (the one that was just added) and delete it. 

    creativeopinion_1-1694380471455.png

    It should still be nested within your original Apply to Each action.

    creativeopinion_2-1694380507212.png

    Convert the Array to a String

    Add a Join action to your flow to convert the array (Select action output) to a String. In the From field, insert the outputs from the Select action.

     

    In the Join with field, insert the separator you'd like between each item. In my case I put a comma and a space.

    creativeopinion_3-1694380568913.png

     

    You can now insert the outputs from the Join action into the Create CSV Table action.

     

    Hope this helps!


    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉Watch my tutorials on YouTube
    👉Tips and Tricks on TikTok

     

     

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 797 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
developerAJ Profile Picture

developerAJ 319

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans