Cancel multiple records using Flow Designer.

[Insider]

Hello All.

I have created a Flow with few approvals where after all the approvals a Deal Status will be changed to = "Approved".
Requirement:

When a new Deal gets into Approved state this must change the old Deal state to = "cancel", Deal comment ="canceled by <New Deal Number>".

I am thinking to lookup the deal record but not sure how to cancel previous records and add Deal comment.

Please Suggest!

[DanielCordick]

look up the old deal record and then use the update record action to update the state and the comments?  Use the record from the look up action inside your update record action 

[Insider]

Hello DC,

How can i look up the old records?

I can look up the deal table is what i know, but how to skip the latest and loopup all other previous records?