Unanswered

Using Power Automate to deduct from a list.

Like (0) Share

Report

Posted on 21 Apr 2023 19:05:56 by Sevinipher

Hello, I'm trying to develop an inventory app for my Organization using Powerapps & Power Automate. The general idea is that there will be devices that get "Installed" and through the app those installed devices are sent to a list, containing serial number and other important information. I'm trying to use Power automate to detect that the "Installed" list has changed, and have it deduct that device from another "Inventory" list.

For example.

1.) The user will input the device and information about it, as previously stated

2.) That items appears on the "installed" list, and power automate detects the change.

Now I'm trying to figure out how to make power automate deduct that device (7950) from another inventory list, how do you get it to understand that it's looking for a specific row/column named "7950" and deduct one or more from the "quantity" column? Is this even possible? Or am I digging down the wrong hole?

I have the same question (0)

All responses (4)

Answers (0)

Sevinipher 11 on 26 Apr 2023 at 17:13:21

Like (0)

Report

Re: Using Power Automate to deduct from a list.

Hey Manish, thank you for following up.
I don't think this is due to blank fields, all of the items in the list are completely filled, the "count" in the list is also set to Number, so I'm not understanding why it doesn't consider that column an integer. When I use your Formula, the flow succeeds, but it will always set the deducted row's "count" to 0, because it always sees the value as null, I'm assuming. even if all of the "count" row has values, the flow will always fail to use the "sub" function because it always thinks the parameters are invalid.

Was this reply helpful? Yes No
ManishSolanki 15,085 Super User 2025 Season 2 on 25 Apr 2023 at 01:36:55

Like (1)

Report

Re: Using Power Automate to deduct from a list.

Hi @Sevinipher

I think there are some blank values in Count field which can't be converted to integer type so the flow got failed. I would suggest you to use the below expression to check the blank values:
if(equals(item()?['Count'],null),'0',sub(int(item()?['Count']),1))

Pls let me know if you face any problem & remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Sevinipher 11 on 24 Apr 2023 at 18:03:13

Like (0)

Report

Re: Using Power Automate to deduct from a list.

Thank you for the response, the flow makes sense to me, in general, but the math you have in "count" doesn't really make sense to me, and it's throwing an error whenever we try to trigger the flow.

Was this reply helpful? Yes No
ManishSolanki 15,085 Super User 2025 Season 2 on 22 Apr 2023 at 12:55:16

Like (1)

Report

Re: Using Power Automate to deduct from a list.

Hi @Sevinipher

Yes, it is possible to filter out row from another list based on filter query. I tried to create a flow for you,
pls refer the same from the below screenshots:

here, in 'update item' action an expression has been used for deducting count from Inventory List

The flow will deduct the count for any change in the Installed list as we haven't added any condition when the count has been deducted. In that case, you need to put some conditions as per your requirements.

Please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No