Answered

Getting data from Microsoft Forms into Flows

(1) Share

Report

Posted on by 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.

All responses (17)

Answers (1)

IvnaTeixeira 4 on at

Like (0)

Report

Re: Getting data from Microsoft Forms into Flows

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
IvnaTeixeira 4 on at

Like (0)

Report

Re: Getting data from Microsoft Forms into Flows

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

Like (0)

Report

Re: Getting data from Microsoft Forms into Flows

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
Sadz92 on at

Like (0)

Report

Re: Getting data from Microsoft Forms into Flows

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
CU17071946-0 on at

Like (0)

Report

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.

https://www.youtube.com/watch?v=-qei9MS_8Ic
CU17071946-0 on at

Like (0)

Report

Re: Getting data from Microsoft Forms into Flows

Hi, I have the same problem. Could you find a solution?
Raphael1 3 on at

Like (0)

Report

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?
baschmidty 3 on at

Like (0)

Report

Re: Getting data from Microsoft Forms into Flows

I am also getting the same error.
Community Power Pla... on at

Like (0)

Report

Re: Getting data from Microsoft Forms into Flows

Also getting similar error:
Community Power Pla... on at

Like (0)

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