cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MindfulMike
Helper II
Helper II

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

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.

 

MindfulMike_0-1649366807593.png

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.

 

MindfulMike_1-1649367063718.png

 

Thanks in advanced! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @MindfulMike 

 

Please have a look at my video tutorial

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

5 REPLIES 5
abm
Super User
Super User

Hi @MindfulMike 

 

Please have a look at my video tutorial

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
MindfulMike
Helper II
Helper II

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"

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? 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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!  

 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,204)