
This might be a too long and complex issue, I'm sorry 😅
I'm building an Inventory app, I have 2 lists:
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
Hi @amralomari ,
Sorry for the function that you mentioned to lock field is not supported in Microsoft flow currently and I'm afraid that there is no any workaround for this requirement.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.