Getting data from Microsoft Forms into Flows

[kbeaudette]

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.

[v-micsh-msft · Accepted solution]

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:

Regards,

Michael

[Anonymous]

Hi

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

Thanks 🙂

[JGarces]

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]

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.

[Leo_Chui]

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]

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]

.Bump...

[Anonymous]

---

@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!

[Anonymous]

Also getting similar error:

[baschmidty]

I am also getting the same error.

[Raphael1]

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]

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

[RodrigoUsi]

CORRECTION!!!

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

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

[Sadz92]

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

[lolaobisanya]

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.

.

Lola

[IvnaTeixeira]

Hy guys,Guys, dynamic content does not appear, do you know how to solve it?

[IvnaTeixeira]

Hi, The error appears:
Could not process model language expressions in action 'Get_response_details' entries in row '0' and column '0': 'The model language function 'first' expects its parameter to be an array or a string of characters. The value provided is of type 'Null'. Check usage details at https://aka.ms/logicexpressions#first.'.

And Dynamic content does not appear