Answered

Variables to multi-choice column in sharepoint list

(1) Share

Report

Posted on by LC-09011551-0

I am have 8 variables containing text strings (coming from a MS Form) and I want to populate one single multi-choice column in SharePoint with each of the variable contents. I'm struggling with the logic of this.

This is an example of one of the variables:

This is how it should appear in the list:

The list field is already multi-choice and the ms form has 8 questions which must always be answered to be able to submit

I know I need to do something with json and arrays but I'm struggling with getting that to work

Can anyone help?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @LC-09011551-0,

You can use a createarray function to turn the variable values into an array. Use that function in a Select action so you can also add the value key in the array. This way it should be formatted correctly for your multi-choice field.

Below is an example

1. Select From uses the below in the From field

createArray(variables('VarA'),variables('VarB'))

2. Map field uses the value key and

item()

3. The multi-choice field (TestChoice) is switched to entire array input with the button on the right side and uses the output of the Select action.

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
trice602 16,298 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Very nice @Expiscornovus

Was this reply helpful? Yes No
LC-09011551-0 10 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Expiscornovus

thanks for giving me something to work with. I also tried this which worked in the end:

once I figured out that the variables were already "strings" and didn't need any conversion from an array. I think I over-complicated it!

Was this reply helpful? Yes No