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:

Building flows

I have the same question (0)

All responses (23)

Answers (3)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@janiceXcruz Hi,

The code looks ok, might some tiny problem caused it.

When you ran it successfully, did the second condition get true ? Need to know which steps it passed.

do you mind providing a screenshot regarding test ? like the one as below.

Was this reply helpful? Yes No
janiceXcruz 74 on at

Like (1)

Report

Hi Sir @stampcoin

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report
@janiceXcruz Hi,

Could you please add one compose before condition2 ?

use the formula as below:

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

test it , and then check what value you get from the output, once you get the value , compare it will what you have in stock.

Was this reply helpful? Yes No
janiceXcruz 74 on at

Like (1)

Report

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@janiceXcruz Hi,

Please add Compose, not another condition. input is the formula what I provided.

then test it, check the output value.

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi @janiceXcruz,

Can you share the output of the Get Items action for further checking your issue, you can hide sensitive information

Thanks,

Srini

Was this reply helpful? Yes No
janiceXcruz 74 on at

Like (1)

Report

Hi @stampcoin, sorry I got confuse.

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@janiceXcruz Hi,

Thanks for the feedback.

seems the output from your Get Items doesn't match the formula.

Can you confirm that your filter has correct name ?

Your sceenshot shows Oracle ID of your list, did you rename the column of Oracle ID is different column ?

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi @janiceXcruz

The compose action is failing, which might be due to a value not being converted to an integer, this can happen if the value is null. If possible, could you expand the outputs of the "Get Items" action?

Thank you!

Srini

Was this reply helpful? Yes No
janiceXcruz 74 on at

Like (1)

Report

Hi Sir @stampcoin. I just rename the Title in the Masterlist as Oracle id, please see ss.

Was this reply helpful? Yes No