web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Body value expression

Power Automate

Answered

Body value expression

(0) Share

Report

Report

Posted on by egornua1

364

Hi All,

Can someone advise on the correct way to extract value (Customer) from body

Many thanks

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

Pstork1 69,024 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
In my experience the Power BI Values passed as part of a trigger are always in an array, even if there is only one value. If you want the first Customer then if would be

triggerBody()?['entity']?['Power BI values'][0]?['Customer']

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report
Copy link

Link copied!

Super thank you.

Was this reply helpful? Yes No
mathieuturcotte 2 on at

Like (0)

Report
Copy link

Link copied!

If I have more than a 1 000 difference combinaison in my filter. It list all of them and when im taking the output in a select statement with the formula : if(equals(item()?['PLANT_NUMBER'], null), '""', concat('"', replace(item()?['PLANT_NUMBER'], ', ', '", "'), '"'))
It will return all of them until a 1 000. Limiting my plant_number possibility.

I need a way to have the district plant_number directly when im calling the : @{triggerBody()?['entity']?['Power BI values']}
Is there a way ?

Was this reply helpful? Yes No
Pstork1 69,024 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later.

Was this reply helpful? Yes No

Join the conversation