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.
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.
@zmansuri I have posted in this new post as wanted to include a check out of office condition - any thoughts?
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.