Filtering after most recent 500 items SP List

[TorreyFalconer]

Hey all, 

I have a SP list to collect data, however I only want to keep the most recent 500 items. If they do not fall within the most recent 500 items, I need to create a flow that will move that item to another identical list that can be the master list. I have most of the flow build already, but I am not sure exactly how to create a filter that would be able to identify the oldest items up until the most recent 500. 

Any thoughts?

Thanks

[manuelstgomes]

Hi @TorreyFalconer 

I think you need to work in the opposite direction. First, select the 500 you want to keep and then exclude the remaining ones. This way, the sort, and record filtering will be done for you, and all you need to do after is filter out the remaining ones in another "Get Item".

Here's how to fetch the most recent 500.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[v-bacao-msft · Accepted solution]

Hi @TorreyFalconer ,

You can also sort by ID, Like ID desc.

You may also need to set Pagination to a maximum value above 500.

Please take a try.

Best Regards,