using sub() to subtract one table cell from another in the same row

[tpitman]

Hi,

I am trying to use sub() to subtract the value of one cell in an excel table from another cell in the same row, but I don't know the correct syntax for referencing the column name "Remaining" & "Days Requested"

e.g. sub([Days_Requested],[Remaining])

Any help greatly appreciated

Thank You

[abm]

Hi @tpitman 

Could you post a screenshot of your flow? 

Thanks

[tpitman]

[tpitman]

[abm]

Hi @tpitman 

Place the cursor against the field you want to set the sub() expression. Then on the right hand side see the expression and type sub(). Place the cursor inside the brackets and then click Dynamic content.  Then select the values.

[tpitman]

Many Thanks!

Problem is when just using Dynamic Content, All cells from the Excel table are shown (Including Days Requested)

When I then do as you suggest, I then only see 'Body' and 'Value' from the table?

[abm · Accepted solution]

Hi @tpitman 

You can do this in two ways. Add two compose actions inside the loop then map the Days_Requested & Remaining values. Next step use the sub() expression and select the compose outputs.

Second method is reference the apply to each loop reference with variables directly under the sub() expression. For this I need to see your flow in detail.

Thanks

[abm]

If it is under an Apply to each then use the below

sub(items('Apply_to_each')?['Days_Requested '], items('Apply_to_each')?['Remaining'])

Thanks

[tpitman]

I really appreciate your help with this abm 🙂

I have tried your "Compose" option, but it seems to think this is now a string value? I have tried 'float()', but then I lose the option to chose values from the table again?

[abm]

You could copy the mapping value and try it under the expression by copying it back.

[tpitman]

Hi,

I set up 2 x 'Compose' for each. one to capture the cell value, then used the 'compose' to convert it to 'float()' 🙂

I'm having a few issues with it changing the value from the specific row, but still working on that one....

Many thanks again!!

[tpitman]

So here is my flow...

Can you see any problems with this as the correct row us changing, but multiple times?

I have only tried the 1st row in the table, I haven't tried subsequent rows

[abm]

Hi @tpitman 

Check your email please?

Thanks

[tpitman]

Nothing come through yet? Only the notification for your last response?

[tpitman]

Thank you to Super User @abm  for finding a solution to my problem 🙂

[tpitman]

Thank you @abm for helping with a solution to my problem  

[abm]

Hi @tpitman 

You original post doesn't reflect the solution. This is about how to get the bucket id for creating a task?

You can do without the iteration this. Please see below.

The expression I used is as follows:

For the filter array expression:

item()?['name']

Finally under the compose expression is:

body('Filter_array')[0]?['id']