Flow to send an email reminder if a field has been on the same name for 48 hours

[Anonymous]

I have a list in SharePoint Online where there is a field called Assigned To. This field uses a people-picker and there is a workflow in place that sends the assigned to person an email when the field is set to their name.

In the event that the Assigned To field is sat with a single person for more than 48 hours, I need to be able to send a reminder email. However, I'm not sure how best to go about this. 

Basically, something along these lines:

If 'Assigned To' is equal to 'Assigned To' 48 hours ago, then send email

Repeat

Has anyone done anything like this before?

[jonathanmweaver · Accepted solution]

I don't believe there's a trigger for "Field hasn't changed", but my initial thought is you could include an Assigned Date/Time to compare against. Then you could run a Scheduled Flow using the Recurrence trigger to check daily/hourly, depending on how precisely you want to measure the 48 hours.

Flow 1: On Change - Filter Assigned To changed, set Assigned Date to utc(Now)

Flow 2: Scheduled - Recurrence every day at 12:00am and 12:00pm, If Assigned Date lt utcNow - 48 hour, send email.

---------------------------------------------------------------------------------------------------------------------------------

If this post answers your question, please mark as Solved so others may find the answer more quickly.

If you like this reply, please click the Thumbs Up button.