Forms response from multiple choice "Other" blank field, copy all text entered to Excel spreadsheet

[Tif]

Good afternoon, 

I am having trouble with collecting a text string from a multiple choice field in Forms labeled as "Other" in which a person enters text. I have a switch for the other multiple choice items, but for the last switch of Default, I would like to capture the text that is entered in the "Other" multiple choice option.  I do not know the correct expression I should be using to capture ALL of the text that is entered in the "Other" field.  It is not going to be a set length of characters, and it will not consistently be the same answer.  

Any assistance is greatly appreciated!

Thank you!

Tif

[abm]

Hi @Tif 

You could initialise a string variable and store the value of the other field. Use the Switch value store under another new variable. Add an IF condition to check the switch value is null then use the other field.

Thanks

[v-litu-msft]

Hi @Tif,

The other option always at the first member of the collection of the multiple-choice answer, so we could use json() function convert the answer of the multiple-choice answer into an array, then use index 0 to get the first member.

Then we should initialize an array variable to store all fix options and initialize a string variable to store the other option:

Then put the output of step 1, the first member of the multiple-choice answer, into the condition to determine it whether exists in the all fixed options, if not, means the First member is get from other option, then put it into the Other variable:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tif]

Hi @abm ,

Thank you for your response.  Can you please tell me how I store the value of the "Other" field?  How do I reference that?  

I am currently using a Switch for the multiple choices and in the last case I will add the IF condition you suggested. 

Thanks again!

[abm]

Hi @Tif 

From the response details you have other option isn't? So declare a variable and map the response other value under this variable.

Thanks

[Tif]

@abm , Here are pics of what I have so far:

I'm stuck at this point not knowing what I need to place in the If Yes box to have the text from the Other field import into the spreadsheet. 

Thank you, 

Tif

[abm · Accepted solution]

Hi @Tif 

Thanks for the discussion. Following are the steps:

1. Add an IF condition to check the length of the variable?

2. IF it's zero then replace the variable value with Other 

3. Finally map the variable in Excel

Thanks

[Tif]

@abm Thank you so very, very much!  I appreciate all the help and explanation of the steps involved.  Enjoyed the conversation and learning experience!

Thanks again for all your tremendous help!

Tif

[Ivan_W]

Dear Lin Tu @v-litu-msft , 

Thank you so much for the detailed steps. And this is extremely helpful.

Would appreciate if you could help to explain the rest from what to do for the "Yes" and "No" and how to map to the excel please.  

Many thanks

Ivan