How can I update status choice column in SP when new proposals are created?

[MindfulMike]

Hi All! 

I need to create a flow so if a new C deal comes in and a new item is created for it, the "old" C deal Status automatically gets changed to "N/A" and the newest C deal says proposed.

I've tried multiple ways so far, below is the most recent thing I tried but Apply to each is being skipped and I don't know why.

My get items is filtering -  Title eq 'Title' and Status eq 'Proposed'. After it gets all the C's with "Proposed" it's skipping the next step and the flow ends.

Thanks in advanced! 

[abm · Accepted solution]

Hi @MindfulMike 

Please have a look at my video tutorial

https://www.youtube.com/watch?v=eKsVF0om0mk&t=214s

Thanks

[MindfulMike]

Thank you for the link @abm , I actually had you video up before I made my post 😃 

Although I am using your video, I am having trouble with the following:

If a new C deal comes in how can I trigger the old C deal to update it's status to "N/A" and have the new one get marked as "Proposed"

[abm]

Hi @MindfulMike 

Thanks for watching the video. So whats the relation between new deal and the old deal? Is that two separate records? What's the identifier between old and new? 

[MindfulMike]

Hi! So after using your video and a lot of troubleshooting with different conditions between when an item is created and get items, I was able to achieve my goal! 

Appreciate the video btw!  

[abm]

Hi @MindfulMike 

Thanks for the update. If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thanks