Answered

Flow unable to handle null response from Forms into Power BI

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

RobElliott 10,420 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No