Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

Passing variables in Power Automate to an Azure Function App through an HTTP 'POST' trigger

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.

 

picture 1.png

However, I still get an error message when I try to execute the workflow as seen in the image below. 

picture 2.png

 

What would be a logical solution?

 

Kind regards,

 

Adi

3 REPLIES 3
Prabha45
Helper III
Helper III

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

Anonymous
Not applicable

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. 

lbendlin
Super User
Super User

You may want to go with the standard Power BI variables instead.

lbendlin_0-1647568156210.png

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.

 

lbendlin_0-1647569085358.png

 

 

Power BI sends a table to the Power Automate flow (an array), not a record.

 

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors