Power Platform Community Forum Thread Details

Scheduled Deletion of old List Items in SPO

Hi Team,

Hope all's well. I've tried to create a simple flow to go through a list and remove specific items, just to keep the list nice and tidy. I've ran into a little (probably easy) problem though, and I'm a bit confused on the solution.

Context: I have a list of items with a start and end date, users put more items in via an app but the list is still very visible. Items need to be deleted when their end date expires to keep the list neat. Naturally I'd rather not have users going into the list and doing this, just to save time.

The flow I've created involves a reoccurrence of each day, so it'll check for items that have expired in the morning before the working day starts. It's targeted at the right list, I know I need a filter query but I don't have much experience with them. I had a look through a few blogs and posts and ended up with the below (End le utcNow()😞

I'm under the impression that this formula should bring back anything less than, or equal to 'Now' as in the time it runs - is that right? I had a check on my list this morning but it still has all the old entries from yesterday and earlier.