Convert dynamic value in expression

(0) Share

Report

Posted on by cltmto

This is my scenario

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

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

For this I use the following flow

Compose = body('Get_a_row)?['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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

VJR 7,635 on at

Like (0)

Report

Hi @cltmto

For your description it looks to be possible, but could you please share some screenshots and what exactly are you looking.

Yes the link to the other post is not opening. It says "The message you are trying to access is not available."

Was this reply helpful? Yes No
cltmto 16 on at

Like (0)

Report

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('Get_a_row')?['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

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Hello @cltmto
Since this thread is already marked as an answer, other members will not be looking into it to answer your question.
Can you please open a new post with the latest details of your issue, so that you can get help on the community.

Was this reply helpful? Yes No
cltmto 16 on at

Like (0)

Report

Hello @VJR
Follow the new topic

https://powerusers.microsoft.com/t5/Building-Flows/Convert-dynamic-value-in-expression/m-p/1322535

Was this reply helpful? Yes No