Answered

MS Forms Export to Excel multiple answers

(1) Share

Report

Posted on by Shamiqbal

Hi,

I have a question in my Microsoft form where there's an option to select multiple answers. When I export to excel my responses all the answers are in one field.

How can i automate this whereby each answer is in a seperate column when exporting to excel?

Any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @Shamiqbal what you need to do is split your responses an then capture one by one like this.

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Shamiqbal ,

If the question is a multiple-choice, you may refer to the following configuration to achieve your needs.

I assume that this question has three options. First, use the json() function to format the response to an array.

Considering that the user will not select all options, so we need to check the length of the array and get the element by the existing index. Hope that makes sense.

Image reference:

Expression reference:

if(greaterOrEquals(length(outputs('Options')),1),outputs('Options')[0],null)
if(greaterOrEquals(length(outputs('Options')),2),outputs('Options')[1],null)
if(greaterOrEquals(length(outputs('Options')),3),outputs('Options')[2],null)

Please take a try and feel free to let us know if you have any questions.

Best Regards,

Was this reply helpful? Yes No
Shamiqbal 4 on at

Like (0)

Report
Copy link

Link copied!

Hi I'm afraid I am struggling to get this done.

I have one question in my MS form that when 2-3 options are selected. I then export to excel and all the answers are in one field.

Can anyone help in this?

Thanks

Shamas

Was this reply helpful? Yes No