cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cltmto
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.

 

Thanks,

Rodrigo

0 REPLIES 0

Helpful resources

Announcements
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)