How can I pull an MS Forms Question text with an expression? I can pull the Answer text from the Get Response body with an expression (Filter null values from a Forms Array ).
When I run a Flow test, the OUTPUTS of Get Response details has this info, but I don't know how to get at it. I am trying to do Select on the outputs on
Are the questions your form the same all the time?
Using the model you linked to, if Q1 and Q2 were to output like the following:
Q1: Is this a form? A1: Yes Q2: How cool is this form? A2: 7
Would that be what you are after? Just in plain text, and not dynamically accessing the actual questions?
The questions in my form may change sometimes (it is a shared form).
I am not completely sure, but I think I am looking to "dynamically access the actual questions".
I want to at least avoid having to type in the question text in my expressions. Of secondary importance is to be able to update the Questions in Forms without having to then modify the Flow experessions.
I would also be grateful for any partial solution to this... plain text or otherwise
Hi @brock ,
I am tring to work on a way to get the dynamic data as Flow displays it but in the "Get response details" action on a successful run. I haven't quite cracked that yet and it may not be possible but I am persevering.
In the mean time, consider the expression below from the other post:
if(equals(not(empty(body('Get_response_details')?['r4b6e28cb8fa748dea068dc564271226e'])), true), concat('Q1: ', body('Get_response_details')?['r4b6e28cb8fa748dea068dc564271226e']), null)
This could become:
if(equals(not(empty(body('Get_response_details')?['r4b6e28cb8fa748dea068dc564271226e'])), true), concat('Date of Birth?: ', body('Get_response_details')?['r4b6e28cb8fa748dea068dc564271226e']), null)
So basically changing "Q1: " to "Date of Birth?: "
This should get the job done and if I can find a way to get at the actual questions from the Form, I will post back.
If you have found my post helpful, please mark thumbs up.
Any other questions, just ask.
YYYYYYYY YYYYYYYY EEEEEEEEEEEEEEEEEE SSSSSSSSSSS YYYYYYYY YYYYYYYY EEEEEEEEEEEEEEEEEE SSSSSSSSSSSSS YYYYYYYY YYYYYYYY EEEEEEEEEEEEEEEEEE SSSSSSSSSSSSSSS YYYYYYYY YYYYYYYY EEEEEEEEEEEEEEEEEE SSSSSSSS SSS YYYYYYYY YYYYYYYY EEEEEEEE SSSSSSSS YYYYYYYY YYYYYYYY EEEEEEEE SSSSSSSS YYYYYYYY YYYYYYYY EEEEEEEEEEEEE SSSSSSSS YYYYYYYYYYYYYYYY EEEEEEEEEEEEE SSSSSSSSSS YYYYYYYYYYYYYY EEEEEEEEEEEEE SSSSSSSSSS YYYYYYYYYYYY EEEEEEEEEEEEE SSSSSSSSS YYYYYYYYYY EEEEEEEE SSSSSSSS YYYYYYYY EEEEEEEE SSSSSSSS YYYYYYYY EEEEEEEEEEEEEEEEE SSS SSSSSSSS YYYYYYYY EEEEEEEEEEEEEEEEE SSSSSSSSSSSSSSS YYYYYYYY EEEEEEEEEEEEEEEEE SSSSSSSSSSSSS YYYYYYYY EEEEEEEEEEEEEEEEE SSSSSSSSSSS
Hi @AlanPs1 ,
Do you have an update on this? I also need the questions, coming from the Form. It's a bit frustration, because I know the info is in there, but I can't access it.
I have browsed a lot and could not find a solution for this. Have you managed to resolve this?
I would be very grateful if you shared your workaround - it would help me a lot.
I will have multiple questionnaires/forms with multiple sections (some filled, some not) - Each single response (which is filled) will make one record (in a database) with an attribute from the question name.
But instead of GUID response form, I need the actual question name (to map it with the proper attribute) - as the questions will be changing over time.
Thanks a lot!
I never found a way to what you want. I ended up putting each question response into a Compose and then building a question/answer table by explicitly stating the question text in my expression. It's problematic when the question text changes or I make a mistake.
Join us for the first ever Power Platform Online Conference!
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!