Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Convert dynamic value in expression

Hello everyone

This is my scenario

Each area of ​​my organization sent, at each period, the desired quantity for an item to be purchased


WhatsApp Image 2021-10-22 at 07.28.02.jpeg


For each row the flow looks for the corresponding row in another excel table and get the quantity already requested for each item


WhatsApp Image 2021-10-22 at 07.48.28.jpeg


For this I use the following flow


WhatsApp Image 2021-10-22 at 08.23.39.jpeg


Compose = body('Obter_uma_linha')?['OPERATIONS'], in this case 'OPERATIONS' is a fixed value entered by me, however the desired content is List Rows in Table - Area

Would it be possible, with the dynamic value of the 'request' spreadsheet, to create an expression that works?

The objective is to take the quantity sent, add it to the quantity already present in the table and update the values ​​in the table.





Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,266)