You’re offline. This is a read only version of the page.
Announcements
16
Hello everyone
This is my scenario
Each area of my organization sent, at each period, the desired quantity for an item to be purchased
https://1drv.ms/u/s!Aiw6wypOvD8Ahsl03ZQS_MShCQh4mw?e=YnCRXh
request.xlsx
For each row the flow looks for the corresponding row in another excel table and get the quantity already requested for each item
https://1drv.ms/u/s!Aiw6wypOvD8Ahsl1n-NFUwZ4GWglGA?e=3Qi0ry
sum request.xlsx
For this I use the following flow
https://1drv.ms/u/s!Aiw6wypOvD8Ahsl2VUuudtDCY1KLZg?e=OHuewP
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
Hello we’re you ever able to find a solution for what you are trying to accomplish? Thanks.
Share
Report
All responses (
Answers (
