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
Community Champion
Community Champion

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

 

zmansuri
Community Champion
Community Champion

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

zmansuri
Community Champion
Community Champion

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.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,466)