Answered

Multi-select choice column from SP List to Excel file (add row)

(0) Share

Report

Posted on by Sharinah1

101

I currently have this flow which works well in normal values. But for SP list column with multi-select choices, the cell only shows one selection.

Excel:

In SP List:

I'm trying out the video from @abm (https://www.youtube.com/watch?v=OXEcLqDvCrc) but I'm stuck after Compose.

not sure which of the dynamic to choose from -

I tried this, then I don't know what to do anymore.

@grantjenkins thanks for noticing my comment

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sharinah1

Could you please tell me:

What do you want to achieve?

Best Regards,

Levi

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Just wanted to confirm what you're trying to achieve with your flow.
When an item is created, use the output to create a new row in your Excel Table
When an item is modified, check if the item exists in the Excel Table.
If it does exist, update the row with the updated values
If it doesn't exist, create a new row with the values
And ensure that multiple select fields are getting all the values saved in your Excel Table

Is that fairly accurate, or were you trying to do something else?

Also, is there a column in your Excel Table that uniquely identifies what List item it refers to?

Was this reply helpful? Yes No
Sharinah1 101 on at

Like (0)

Report
Copy link

Link copied!

Yes, this is exactly correct.

The unique item would be 'ID'. It's my key column (from excel) and key value from SP List.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!

Ok - I'll try to build a solution for you later - might be a few hours 🙂

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Sharinah1

You can use Select to get the values in the multi-choice column.
The values in the multi-choice column are in the form of an array, and you can use Join to convert the array into a comma-separated string.

join(body('Select'),',')

Best Regards,

Levi

Was this reply helpful? Yes No
Sharinah1 101 on at

Like (0)

Report
Copy link

Link copied!

This works!!! Thank you so much for the effort and help.

Was this reply helpful? Yes No