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?

Categories:

Building flows

@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.

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.

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

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.