Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

 

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

Need Help
Tutorial Requests

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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. 

  • Prabha45's avatar
    Prabha45
    Icon for Helper III rankHelper III
    3 years ago

    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