Answered

put multiple answers into specific columns in Excel

(0) Share

Report

Posted on by Skybluekid

262

I have a Forms with multiple choices answers in one question. I have a flow that takes the responces and put them in a Excel table. What I would like is to have on the multiple choice question, is that if the submission is option 1, then the flow would put an 'X' in Option 1 column in the excel table. I would like the same for option 2 and option 3. The form allows multiple options to be selected so if option 1 and 2 are selected then an 'X' is placed in these two columns.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Skybluekid ,

Refer to below process:

Here are expressions I used:

slice(outputs('Get_response_details')?['body/changetoyourID'],1,-1) split(outputs('Compose'),',') Slice(item(),1,-1)

Add more case in switch for more options.

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Skybluekid 262 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-wenjuan-msft

Was this reply helpful? Yes No