Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi all,
Recently I have tried to create a flow where I can pass two variables (in the example 'ID' and 'Location') to an Azure Function through an HTTP-trigger by using the POST-method. I came to know that to pass these variables to the Azure Function, I had to compose the following text: triggerbody()?[entity]?['Power BI values'] as visible in the picture below.
However, I still get an error message when I try to execute the workflow as seen in the image below.
What would be a logical solution?
Kind regards,
Adi
Hi Adi,
Happy New Year.
I had a similar scenario. Can you please let me know how it was done. Screenshot of your automate flow or any article how to do it.
TIA
Regards,
Prabha
Hi, thanks for the answer! Have been able to solve it by simply adding the variables in the HTTP-action and afterwards use a parse JSON-action.
You may want to go with the standard Power BI variables instead.
Note that Power Automate must insert an "Apply to each" container. If you modify that (like you seem to have done) then the flow will fail.
Power BI sends a table to the Power Automate flow (an array), not a record.