Answered

put multiple answers into specific columns in Excel

(0) Share

Report

Posted on by Skybluekid

252

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.

All responses (2)

Answers (1)

Skybluekid 252 on at

Like (0)

Report

Re: put multiple answers into specific columns in Excel

Thank you @v-wenjuan-msft
Verified answer

v-wenjuan-msft on at

Like (1)

Report
Re: put multiple answers into specific columns in Excel

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.