Dears,
I have designed an offspec process via the power automate, the process logic is like this, I created 4 lists (1,2,3,4 in the screenshot) to represent every step, and list 5 to show all the ltems with status. Every time when I submit an offspec request, the offspec ID will be generated and a new item should be created in list 5.
One scenario is that we may need to step back a request from step 2 to step 1, and resubmit with updated request. I met a problem that a new item will be created in list 5 with the same offspec ID, that is not what I want.
Here is my solution to fix this issue. I added a checkpoint in list 1 to see if it is initial or updated request, and add a column named Submit Offspec Request ID in list 5, every time the item in list 1 updated, the flow will get items in list 5 and check if there is a item with the Submit Offspec Request ID, if yes, then get this item. unfortunately, I failed in this step many times, I am not sure if my condition is not correct in my flow, I just can't find the related item in list 5.