Answered

Update Quantity in Inventory List after "Approval" of Withdrawal

(0) Share

Report

Posted on 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

All responses (23)

Answers (3)

stampcoin 3,286 Super User 2025 Season 2 on at

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.
janiceXcruz 34 on at

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.
Verified answer

stampcoin 3,286 Super User 2025 Season 2 on at

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.
janiceXcruz 34 on at

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

Hi Sir @stampcoin
Verified answer

stampcoin 3,286 Super User 2025 Season 2 on at

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.
janiceXcruz 34 on at

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

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

stampcoin 3,286 Super User 2025 Season 2 on at

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
janiceXcruz 34 on at

Like (0)

Report

Update Quantity in Inventory List after "Approval" of Withdrawal

Hi Sir @stampcoin,
stampcoin 3,286 Super User 2025 Season 2 on at

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.
janiceXcruz 34 on at

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.