This might be a too long and complex issue, I'm sorry 😅
I'm building an Inventory app, I have 2 lists:
- List A that contains the materials info & Quantity
- List B which acts as transaction log to register the withdraw action for each material
How I've built list B?
Column 1 is a lookup column that will display also column 2
I've created the flow below to copy the value in column 2 to column 3 so I can subtract the withdrawn Qty. (column4) from the original Qty. available and save it in column 5.
Then I've created this flow to update the material's Qty.
used the condition to prevent causing a loop
So where is the problem??!!
when material Qty. gets updated in list A, it is directly reflected in list B 😂
I need a way to prevent the older fields from getting updated, something like locking them from getting updated so any older transaction is stored and can't be modified

Report
All responses (
Answers (