Update Quantity in Inventory List after "Approval" of Withdrawal

Like (0) Share

Report

Posted on 22 Jul 2025 08:44:40 by janiceXcruz

Hi Team,

This is taking a toll on me — I’m very new to Power Automate and currently building a flow. I believe I’m almost there, but now I’m stuck and feeling confused.

The request falls under "NS Request", which requires management approval. Initially, the status is Pending, and once approved, I need the Quantity in the Request SharePoint list to be deducted from the Masterlist SharePoint list.

Please see my flow. Sometimes it runs successfully, but the Quantity in the Masterlist remains unchanged.

Can someone please help clarify this for me? If it’s not too much to ask, I’d really appreciate a step-by-step guide. The unique identifier I'm using is Oracle ID.

Thank you so much for your help — it’s highly appreciated!

Categories:

Business Process Flows

I have the same question (0)

All responses (23)

Answers (3)

stampcoin 4,355 Super User 2025 Season 2 on 23 Jul 2025 at 09:04:23

Like (2)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

@janiceXcruz Hi,

Glad to hear that. Please choose the answer mark it as answered.😊

Feel free to post a new one when you need help.

Was this reply helpful? Yes No
janiceXcruz 54 on 23 Jul 2025 at 09:01:11

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

Genius @stampcoin. My heart is so happy! At last, it works! The quantity in the request form subtracts from the Masterlist. The final value in Masterlist updates. This is great. Thank you so much for the patience. I really appreciate it.

Was this reply helpful? Yes No
Verified answer

stampcoin 4,355 Super User 2025 Season 2 on 23 Jul 2025 at 07:33:59

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

@janiceXcruz Hi,

Good thing is the formula of condition2 get true,😊.

1. Please update the formula in Update Items as well.

Make sure the formula doesn't use body/field_2 but field_2.

2. Please remove the Compose, that was for debug before, you don't need it now.

Was this reply helpful? Yes No
janiceXcruz 54 on 23 Jul 2025 at 07:14:23

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

Hi Sir @stampcoin

Was this reply helpful? Yes No
Verified answer

stampcoin 4,355 Super User 2025 Season 2 on 23 Jul 2025 at 06:41:14

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

@janiceXcruz Hi,

Your get items output is correct.

I doubt that empty function might be the killer.

Do you mind changing your Condition2 formula to below one ? ( you can copy your current one and save it somewhere).

Left inputbox type formula:

int(first(body('Get_items')?['value'])?['field_2'])

Right inputbox type formula:

int(triggerBody()?['field_4'])

similar like below screen shot, once you update the formula, test it.

Was this reply helpful? Yes No
janiceXcruz 54 on 23 Jul 2025 at 06:24:45

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

Hi Sir @stampcoin. Thank you for not giving up on the newbie.

Was this reply helpful? Yes No
Verified answer

stampcoin 4,355 Super User 2025 Season 2 on 23 Jul 2025 at 05:46:38

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

@janiceXcruz Hi,

That's not the output of Get Items, your screenshot is input of Get items.

Another thing I noticed that your condition2 formula.

could you please try to change from body/field_2 to field_2 ?

update the formula, save and run

Was this reply helpful? Yes No
janiceXcruz 54 on 23 Jul 2025 at 05:37:48

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

Hi Sir @stampcoin,

Was this reply helpful? Yes No
stampcoin 4,355 Super User 2025 Season 2 on 23 Jul 2025 at 05:28:37

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

@janiceXcruz Hi,

The reason is your condition2 get false , so it won't go to the update items.

Something wrong with the condition2 formula or Get items

If you switch to output of Get Items, can you see some result from output ?

Similar like my screenshot.

Was this reply helpful? Yes No
janiceXcruz 54 on 23 Jul 2025 at 02:32:47

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

Hi Sir @stampcoin and Team, just got back. Please see below after latest instruction you gave. I myself couldnt pinpoint the missing link in my flow. It is success but the output in the Masterlist is not changing.

Was this reply helpful? Yes No