Answered

Issue extracting multi choice column from Sharepoint list into a csv file

(0) Share

Report

Posted on by nephar

I have a sharepoint list having ID, Task Name and Task Owner as columns where Task Owner is a multi Selection column that chooses from All Users (windows). I want to extract the content of this into a CSV file in my local folder using Power Automate. But unable to get values from multi selection column (Task Owner, internal name field_3). ( its values are based on firstname, lastname, eg. abc,bcd (FN,LN), cde,asd (FN,LN), Pq, dsa etc.). Can I get a best way to read this list into a csv file please !

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

Sort by

nephar 13 on at

Like
a
(0)

Report
Copy link

Link copied!
I tried using
join(xpath(xml(json(concat('{"root":',json(concat('{"Value":',item()?['field_3'], '}')), '}'))),
'/root/Value/Value/text()'),',') -- But the column is coming Blank

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,995 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @nephar,

Did you use this in your Create CSV table action? Normally you would have one xpath expression in the Form and one in the Value field. I see you combined the two in one full expression.

I would have expected in the From

xpath(outputs('XML'), '//root/value')

and the below in the value field

join(xpath(item(), '//Field_3/Value/text()'), ', ')

My suggestion would be to have a look at this example:

https://powerusers.microsoft.com/t5/Building-Flows/Expression-to-Get-DisplayName-from-SharePoint-People-Picker/m-p/1913160/highlight/true#M210643

Was this reply helpful? Yes No
nephar 13 on at

Like
a
(0)

Report
Copy link

Link copied!
I am trying to use Trigger action, Get items, create csv table and create csv file actions in sequence. When I try to include
xpath(outputs('XML'), '//root/value')
in FROM field of create csv table action, it gives error - The input parameter(s) of action 'Create_CSV_table' contain an invalid reference to 'XML'. Correct to include a valid reference to 'XML' for the input parameter(s) of action 'Create_CSV_table'

Was this reply helpful? Yes No
nephar 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Even when I use a Compose action and then Create CSV then also getting the same error

Was this reply helpful? Yes No
nephar 13 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you very much for the help. I followed the steps in the link and it worked perfectly.

Was this reply helpful? Yes No