cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
brock
Level: Powered On

Pull MS Forms Question

 

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 

8 REPLIES 8
Super User
Super User

Re: Pull MS Forms Question

Hi @brock 

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?

 

Thanks, Alan


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

Proud to be a Flownaut!


brock
Level: Powered On

Re: Pull MS Forms Question

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     Robot Happy

Super User
Super User

Re: Pull MS Forms Question

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.Capture-413.png

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.

Thanks, Alan


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

Proud to be a Flownaut!


brock
Level: Powered On

Re: Pull MS Forms Question

@AlanPs1 

 

Yes, that is what I am doing now (putting the question text into the concat().

 

thanks for looking at this, I hope there is a way.

Super User
Super User

Re: Pull MS Forms Question

Hi Brock.
So, there is a way, it is an advanced hack though that involves editing the JSON on the connector and exposing internal properties. I have it working partly in my environment. Stick with what you have for now and I plan on posting a blog about the advanced method once I have it polished. I’ll let you know once I have the method complete and the post out there.

Thanks, Alan.

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

Proud to be a Flownaut!


brock
Level: Powered On

Re: Pull MS Forms Question

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
_TJ
Level: Power Up

Re: Pull MS Forms Question

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.

Kind regards,

Thye

Duri
Level: Powered On

Re: Pull MS Forms Question

Hi @AlanPs1 

 

 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!

 

 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 95 members 4,154 guests
Please welcome our newest community members: