Forum Discussion
Some Form questions are getting brackets [ ] around answers, \n at the end, and/or <br> at the end.
src2021 My apologies for the delay, I got horribly tied up last week with testing & delivering a Power Apps app before our company closed for Christmas.
In this example our form is as follows and allows the user to register for 1 or more events:
As normal in the flow, start with the Forms "when a new response is submitted" trigger and the "get response details" action.
Save it at this point and run it. You will need to get the id of the question where you were asking the multi-choice question in the form. Copy that ID.
Next, add a Compose action and in the expression tab enter the expression below, changing my question ID to your one that you've just copied. The expression will strip out the brackets and quotes and replace them with nothing:
replace(replace(replace(body('Get_response_details')?['r840e31f73133432692afb19370c0ffea'],']',''),'[',''),'"','')
Then you can just create the item in your list, using the outputs of the compose above:
And this is the result.
Come back with any questions about this.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
src2021 that's how the flow in Power Automate deals with multi-choice answers from the form. I'll post up the way to deal with that asap.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliottare you still planning on following up with another post? 🙂
src2021 My apologies for the delay, I got horribly tied up last week with testing & delivering a Power Apps app before our company closed for Christmas.
In this example our form is as follows and allows the user to register for 1 or more events:
As normal in the flow, start with the Forms "when a new response is submitted" trigger and the "get response details" action.
Save it at this point and run it. You will need to get the id of the question where you were asking the multi-choice question in the form. Copy that ID.
Next, add a Compose action and in the expression tab enter the expression below, changing my question ID to your one that you've just copied. The expression will strip out the brackets and quotes and replace them with nothing:
replace(replace(replace(body('Get_response_details')?['r840e31f73133432692afb19370c0ffea'],']',''),'[',''),'"','')
Then you can just create the item in your list, using the outputs of the compose above:
And this is the result.
Come back with any questions about this.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserSuper helpful, thank you so much! One little question for ease of reading--is there a way to separate the multiple responses either with a Ctrl-J return within the Excel cell, or a semi-colon & space, so instead of
Tuesdays 1-2:00pm,Sundays 3-4:00pm
It would look like
Tuesdays 1-2:00pm
Sundays 3-4:00pmor
Tuesdays 1-2:00pm; Sundays 3-4:00pm
I know this is late to the party, but I don't know where to find the question ID. Could you please tell me where that is?
So if you have "Add a row to a table," click the 3-dot menu in the right corner and then click "Peek code" which shows each question as item/Column Name (like Email, Phone, Name) and the question ID is there, after body/:
(Click "Done" to exit code view)
- works for me - many thanks 🙂
