cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Partisan
Post Partisan

Update item when date has passed 3 days

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.

 

sudosaurus_0-1622738326768.png

sudosaurus_1-1622738463026.png

 

 

6 REPLIES 6
zmansuri
Super User
Super User

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.

a84.jpg

sudosaurus
Post Partisan
Post Partisan

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

 

sudosaurus_0-1622740799655.png

 

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

sudosaurus
Post Partisan
Post Partisan

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

Is it working as you wanted it to?

sudosaurus
Post Partisan
Post Partisan

@zmansuri no it doesnt appear to be.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,850)