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 II
Super User II

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.

View solution in original post

2 REPLIES 2
Expiscornovus
Super User II
Super User II

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.

View solution in original post

Hi @Expiscornovus

 

Thank you kindly, I have tried and it worked!

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (58,631)