You’re offline. This is a read only version of the page.
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.
Perfect, Alice! Flow is working for me now. Thanks!!
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.
Hi @Anonymous ,
Please refer to screenshot below to create the flow:
And the expression should as below:
Share
Report
All responses (
Answers (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 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.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
