web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate put multiple answers i...

Power Automate

Answered

put multiple answers into specific columns in Excel

(0) Share

Report

Report

Posted on by Skybluekid

262

Hi

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

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

Join the conversation