Pulling data from 'other' multiple choice response in Forms to excel

(0) Share

Report

Posted on by CU12122042-0

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 that is working well, but for the last condition of 'Other' where users can enter their own selection, I can't get the data to feed to excel. Here are some screenshots of what I have so far.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

rzaneti 4,476 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

The problem is happening because the output of any Form choice question with "Other" is the text entered by the submitter. For example, if I click in the "Other" option and type "test" in the input, Power Automate will read the answer as it follows:

Since you cannot predict what will be the user's input, my recommendation is to handle those cases in the Default branch of your Switch:

If you are already using the Default branch for handling cases where the question is not answered, you can add a Condition that captures the empty() value of the answer and branches it again to handle the "Other" scenario (If yes below) and the "not answered" scenario (If no below):

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
CU12122042-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you @rzaneti Your solution was perfect and worked! I was overcomplicating it.

Was this reply helpful? Yes No