You’re offline. This is a read only version of the page.
Announcements
Hello,
I oversee a few teams and created a sharepoint list to track who is active, coming onboard and is inactive. I am trying to figure out how to create a scheduled flow to change a person's status to inactive based on their end date. My end goal is to have it run every two weeks and change the status to inactive if it is after the end date entered and move them to another sharepoint list for archive. I have already created a second sharepoint list with all the same fields so that no data would be lost.
Any advice or guidance would greatly be appreciated.
Hi @BILLIUM6891,
You could use a Get Items action with the Filter query field. In that field you can compare the end date column values of your items with todays date and check if it is less than (lt) that. For each item (in an apply to each loop) that matches that filter you can update the status column value with an Update item action.
For the move part you would have to use create item/delete item approach. As far as I am aware there isn't any specific move to method for moving list items (only for files).
Below is an example for the first part of your question (setting the inactive status).
Share
Report
All responses (
Answers (
33,189
EndDate lt '@{utcNow()}'
1. The example list with the End Date column
2. The flow setup.
