Answered

Two multiple selection choice questions from MS Forms to One multi choice column in SharePoint

(0) Share

Report

Posted on by Jon8930

Hello,

I have a challenge to try and solve with trying to get two multiple selection choice questions from an MS form to combine and go into one multi choice SharePoint column, Ideally I need to them to output into the choice pills that have been setup for the answers. I have tried using select actions and trying to append to a variable but this doesnt help as one of the questions will always be null, I thought about doing a condition for each question if not equal null then use a select action, but how do i then use the dynamic content into the one field in the create item action. Any help would be appreciated.

Categories:

Building flows

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Jon8930,

The below article covers up How to Save Microsoft Forms Multi-Select Choices to a SharePoint Multi-Select Choice Column.

Compose 1

Compose 2

Compose 3 : Using union compose of 1 and 2

union(

if(empty(outputs('Compose1')), json('[]'), json(outputs('Compose1'))),

if(empty(outputs('Compose2')), json('[]'), json(outputs('Compose2')))

)

Note: replace the variables accordingly to your power automate.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Jon8930

You can try something like this:

1. Trigger

2. Initialize a variable to save the choices

3. Get the response details

4. Two for each:

json(outputs('Get_response_details')?['body/r525cf376db114930b27b3eaa3aee68f1'])

5.

{
"Value": "@{items('Apply_to_each_Q1')}"
}

6. Create Item in SharePoint List

Let me know if it worked!

Was this reply helpful? Yes No