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
Solved! Go to 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,
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
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,
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
90 | |
50 | |
36 | |
30 | |
27 |
User | Count |
---|---|
75 | |
60 | |
50 | |
41 | |
38 |