Update item when date has passed 3 days

[sudosaurus]

Hello,

I have a list where I have a date field named "Resolution Date" (Internal name is ResolutionDate).

I want to update the status of items in the list from Resolved to Closed if it's passed 3 days since the Resolution Date.

I've tried doing this in the below flow but can't seem to get past the Get Items step.

[zmansuri]

your trigger is not right. It wil run your flow every 3 day. What you want is to compare date with Resolve date. If it's been 3 days. Change status.

Let's say Your resolve date is 1st June. Today is 4th June.

Use "get past time". Provide interval of 3 days.

Output of get pas time will be 3 days before today's date.

Compare it with your resolve date using condition.

Here is pic of one my flows. if entry in my SharePoint site is 3 months old. It will be archive. every day at 4 with flow will run. Check if any entry is 3 month old. If there is. Remove it from main list and moves it to archive list.

[sudosaurus]

@zmansuri I think I've sorted it using this expression if that makes sense?

[zmansuri]

I can't see what you have write in that expression. But if it is working. Go for it.

[sudosaurus]

@zmansuri I have posted in this new post as wanted to include a check out of office condition - any thoughts?

https://powerusers.microsoft.com/t5/Building-Flows/Conditionally-check-out-of-office-to-update-share...

[zmansuri]

Is it working as you wanted it to?

[sudosaurus]

@zmansuri no it doesnt appear to be.