Flow unable to handle null response from Forms into Power BI

[Anonymous]

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.

[RobElliott]

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

 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.

[v-alzhan-msft · Accepted solution]

Hi @Anonymous ,

Please refer to screenshot below to create the flow:

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.

[Anonymous]

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.

[Anonymous]

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