cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Flow unable to handle null response from Forms into Power BI

I have been using Flow to populate data from Forms into Power BI.  It works great for my standard Form templates, but I have a new Form template that uses branching.  This branching has caused Flow to fail because it registers a null response from Forms.

 

I'm using the following Flow expression to get the response details from Forms: 

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

 

I have no idea what this expression means as I copied it from a tutorial I watched to get Flow working.  The error message I'm getting says the following:

Unable to process template language expressions in action 'Get_response_details' inputs at line '1' and column '2005': 'The template language function 'first' expects its parameter be an array or a string. The provided value is of type 'Null'.

 

Any help would be appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @Anonymous ,

 

Please refer to screenshot below to create the flow:

1.png

 

And the expression should as below:

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

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

4 REPLIES 4
Highlighted
Super User III
Super User III

@Anonymous why don't you just use the Get response details action instead? That should always be the first action after the When a new response is submitted trigger.

getResponseDetails2.png

 Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Highlighted
Community Support
Community Support

Hi @Anonymous ,

 

Please refer to screenshot below to create the flow:

1.png

 

And the expression should as below:

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

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

Highlighted
Anonymous
Not applicable

Thanks for the advice, but I am using the Get response details action.  The issue is that the expression I'm using in this action can't manage instances of null response that is attributed to branching in Forms.

Highlighted
Anonymous
Not applicable

Perfect, Alice!  Flow is working for me now.  Thanks!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (10,582)