cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kbeaudette
New Member

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
v-micsh-msft
Community Support
Community Support

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

15 REPLIES 15
v-micsh-msft
Community Support
Community Support

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

Anonymous
Not applicable

Hi

 

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

 

Thanks 🙂

JGarces
New Member

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

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.

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.

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
Frequent Visitor

.Bump...

Anonymous
Not applicable


@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
Regular Visitor

Also getting similar error:image.png

 

I am also getting the same error.

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?

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

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

Sadz92
Frequent Visitor

Hi,

I've copy pasted the Form ID from the url as the form was shared with me.

 

When I add in "Get response details" it only shows "Response ID" under dynamic content and not "List of Response Id" 

 

Can someone assist me? 

 

Thanks

 

Hi @Sadz92 .

 

I had the same issue but got it resolved.

Use only Response Id in the "Get response details".

Don't use "apply to each" just "add rows to the dataset" Power BI connector directly.

Follow the steps as shown below.

 

Forms to Power BI- Automate.jpg.

Lola

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,658)