cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

8 REPLIES 8
Highlighted
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Community Support
Community Support

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.

Annotation 2020-06-04 141047.jpg

 

Then we should initialize an array variable to store all fix options and initialize a string variable to store the other option:
Annotation 2020-06-04 141100.jpg

 

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:

Annotation 2020-06-04 141858.jpg

 

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.

Highlighted
Helper II
Helper II

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!

Highlighted
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Helper II
Helper II

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:

IS Other - 1.jpgIS Other - 2.jpgIS Other - 3.jpgIS Other - 4.jpgIS Other - 5.jpg

 

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

Highlighted
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

View solution in original post

Highlighted
Helper II
Helper II

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

Highlighted
Regular Visitor

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

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (4,223)