Export a Sharepoint List with Multiple Choice/Person columns into a readable CSV table

(1) Share

Report

Posted on by mmassi

Hi Team,

I have a flow in which:

I get all the items of the list
Have an apply to each loop where I parse all my multiple choice or person columns into a more readable result using the Select + Join actions (e.g., Multiple Choice Owner --> owner 1 email, owner 2 email, owner 3 email)

How can I create a CSV table that combines all the columns that I am parsing in the apply to each loop (all the Join actions) appending all the item by item outputs of the for loop?

My ultimate goal is to extract a ShP list into a CSV where all the complex columns are readable.

Thank you.

Massimiliano

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

sandeepstw 312 Moderator on at

Like (0)

Report

HI @mmassi ,

This is what you can use -

Get items from the SharePoint list.
Initialize variable CSVData.
Apply to each item:
---Select action to format complex columns.
---Join action to concatenate values.
---Append parsed values to CSVData.
Create CSV table from CSVData.
Create file to save the CSV.

Mark as solution if it helps.

Thanks,

Sandeep Mishra

Was this reply helpful? Yes No
Verified answer

mmassi 9 on at

Like (0)

Report

Hi @sandeepstw , thanks for your reply.
I couldn't make it work with the select+join, maybe because I have complex columns (e.g., multiple choice person) and it needs some nested for each loops.

However, I could make it work with a simple Create CSV table following the Get Items, with custom columns option and this formula where I need to extract a value from each multiple choice column:

xpath(xml(json(concat('{"root":{"choices":',item()?['MultipleChoiceColumn'],'}}'))),'/root/choices/Value/text()')
xpath(xml(json(concat('{"root":{"choices":',item()?['MultipleChoicePersonColumn'],'}}'))),'/root/choices/Email/text()')

Thank you.

Was this reply helpful? Yes No