cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kbeaudette
Level: Power Up

Getting data from Microsoft Forms into Flows

I am trying to get data from a Form to create an action in Flows.  Specifically, I am trying to get the response to a question to email the person responding.    My flow is set up as follows.

 

When a new response is created => Get response details (I may have the Response Id wrong, right now it is just a "1") =>  Apply to each - List of response notifications (what should the select an output from previous step be?) - Condition "Who are you?" is equal to "Person Responding" => If yes, send email, If no, do nothing.

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Getting data from Microsoft Forms into Flows

Hi @kbeaudette,

 

See my posts in the following thread:

How to embed a response body/link into approval email

 

For the response ID field, take use of the following Expression, instead of select the Response ID from the Dynamics content:

first(triggerBody()?['value'])?['resourceData']?['responseId']

See image as a reference:

4.PNG

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

13 REPLIES 13
Community Support Team
Community Support Team

Re: Getting data from Microsoft Forms into Flows

Hi @kbeaudette,

 

See my posts in the following thread:

How to embed a response body/link into approval email

 

For the response ID field, take use of the following Expression, instead of select the Response ID from the Dynamics content:

first(triggerBody()?['value'])?['resourceData']?['responseId']

See image as a reference:

4.PNG

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

dines
Level: Powered On

Re: Getting data from Microsoft Forms into Flows

Hi

 

Could you (or someone else) explain me why this works or which means each part of this expression?

 

Thanks 🙂

JGarces
Level: Power Up

Getting data from Microsoft Forms into Flows

I want tu post in teams with flow the result of a Form Quiz but I can't i hope someone help me.

Im Onle one the result of a Quiz for example Jhon obtains 30 points 


 

Thanks in advance

chico
Level: Powered On

Re: Getting data from Microsoft Forms into Flows

WOW!!!!

 

This just saved my butt in a big way!!!

Was severly stuck on how to get out of lopping in to an Apply to each - just to get data from a new Form response.

Huge thanks to @v-micsh-msft for sharing that simple expression with the power to change reality.

Highlighted
Leo_Chui
Level: Powered On

Re: Getting data from Microsoft Forms into Flows

Hi, I have been trying to find a solution for this and I see the same advice everywhere however, despite following the instructions accordingly, the expression is spitting out this error:

 

Unable to process template language expressions in action 'Get_response_details' inputs at line '1' and column '2746': 'The template language function 'triggerBody' must not have any parameters.'.

 

All I want is whenever a user fills out a form, the responses are e-mailed to a group of people in our organisation.  Any help would be greatly appreciated.  Thank you.

zoidberg
Level: Powered On

Re: Getting data from Microsoft Forms into Flows

dines
Hi
Could you (or someone else) explain me why this works or which means each part of this expression?
Thanks

 

Someone please answer this man.

rareed
Level: Powered On

Re: Getting data from Microsoft Forms into Flows

.Bump...

YvesNET
Level: Power Up

Re: Getting data from Microsoft Forms into Flows


@zoidberg wrote:
dines
Hi
Could you (or someone else) explain me why this works or which means each part of this expression?
Thanks

 

Someone please answer this man.


It takes the first item in the collection of responses the flow expects back, since there can only be one answer for the trigger this is fine and will never result in errors. You can recreate this expression by just choosing the 'first' statement in the dynamic content expression window, and then choosing response ID from dynamic content.

 

Cheers!

maura
Level: Powered On

Re: Getting data from Microsoft Forms into Flows

Also getting similar error:image.png

 
baschmidty
Level: Powered On

Re: Getting data from Microsoft Forms into Flows

I am also getting the same error.

Raphael1
Level: Power Up

Re: Getting data from Microsoft Forms into Flows

I have the Problem that I cant do the same for the Formular-ID, is there a way to also use the Name of the survay as Dynamic Content?

RodrigoUsi
Level: Power Up

Re: Getting data from Microsoft Forms into Flows

Hi, I have the same problem. Could you find a solution?

RodrigoUsi
Level: Power Up

Re: Getting data from Microsoft Forms into Flows

CORRECTION!!!

 

Guys, I was able to solve the problem without using the expression first, the video below may help.

 

Correção.png

 

 

 

https://www.youtube.com/watch?v=-qei9MS_8Ic

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,574)