cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
julleus21
Frequent Visitor

Send an email if field does not change

Hello,

 

I would like to seek help in sending a follow up email if the "Status" field in my SP List remains "Need more info" in 7 days.

 

Pardon me as I am having trouble in attaching a screenshot here, but my flow is set up like this

 

When an item is created or modified -> Get Item -> Switch on: Status -> Equals: "Need more info" -> Send an email -> Delay: 7 days -> Condition: If Status = "Need more info" -> Send an email, If no, do nothing.

 

Unfortunately, it still sends an email even the status changed on the given timeframe. Can somebody advise if I did wrong. 

 

Thanks for your kind help in advance.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @julleus21,

 

I think in the context of the flow it's still looking at your old value.

 

I would suggest to recheck the value of that status field right after your delay action of 7 days. So add a second get item action and use that output for condition to check if the status fields still equals need more info.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @julleus21,

 

I think in the context of the flow it's still looking at your old value.

 

I would suggest to recheck the value of that status field right after your delay action of 7 days. So add a second get item action and use that output for condition to check if the status fields still equals need more info.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Hi @Expiscornovus

 

Thank you kindly, I have tried and it worked!

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,666)