Unanswered

Flow waiting until drop down in column called Current Status changes

(0) Share

Report

Posted on by caseyflynnva

I am fairly new to Power Automate and am working on what should be a simple flow. When the initial item is entered into SharePoint the column title Current Status has a default setting of Review in Progress. I want the flow to start when an Item is created and send an email to two individuals that will be working this list (those two steps are done and work fine) I then want the flow to wait until one of them goes back in and changes the status in the Current Status column to Review Completed...there is where I am stuck how do I get Automate to wait till the column is changed to that specific status before moving on and sending an email to fiscal department that the review has been completed? Thank!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

I think you should split your flow into two flows.

1) Should run when a new item is created.
2) Should run when an item is modified.

The first one can run and send the email to two approves

The second one should run when the approves change a column value

Its also possible to do it in a single flow that basically will use a do until condition and you can keep checking the status of the column every few hours. until the column value has been updated example below as i am checking a user choice column to see if the value is true.

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

Was this reply helpful? Yes No
caseyflynnva 6 on at

Like (0)

Report
Copy link

Link copied!

I'm trying to go with your second recommendation of doing it in one flow. I built it as 1) when an item is created it starts the flow and 2) it sends a notification to the two reviewers. I then added a 3) Get item pointing a the list and list ID 4) Do until with the dynamic content looking at the Current Status Value looking back at the Get Item in 3. I then added the Get Item 2 again looking at the list and list ID. My Limits are Count 60 and Time out PT1H. However the flow just runs straight through...what part did I screw up 🙂

Was this reply helpful? Yes No
caseyflynnva 6 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
caseyflynnva 6 on at

Like (0)

Report
Copy link

Link copied!

Any additional help still trying to get the Do Until working correctly...Thanks!

Was this reply helpful? Yes No