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

Like (0) Share

Report

Posted on 3 Jun 2020 22:53:15 by 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

I have the same question (0)

All responses (8)

Answers (1)

abm abm 32,585 Most Valuable Professional on 03 Jun 2020 at 23:19:50

Like (0)

Report

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

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

Was this reply helpful? Yes No
v-litu-msft on 04 Jun 2020 at 06:21:27

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Tif 87 on 04 Jun 2020 at 16:20:11

Like (0)

Report

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

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!

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on 04 Jun 2020 at 16:24:20

Like (0)

Report

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

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

Was this reply helpful? Yes No
Tif 87 on 04 Jun 2020 at 18:13:41

Like (1)

Report

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

@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

Was this reply helpful? Yes No
Verified answer

abm abm 32,585 Most Valuable Professional on 04 Jun 2020 at 19:15:27

Like (1)

Report

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

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

Was this reply helpful? Yes No
Tif 87 on 04 Jun 2020 at 19:32:02

Like (1)

Report

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

@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

Was this reply helpful? Yes No
Ivan_W 4 on 07 Sep 2020 at 15:34:27

Like (0)

Report

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

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

Was this reply helpful? Yes No