Send an email if field does not change

[julleus21]

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.

[Expiscornovus · Accepted solution]

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.

[julleus21]

Hi @Expiscornovus

Thank you kindly, I have tried and it worked!