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
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.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (3,077)