Dear Experts,
How can i delete the last (oldest) 50 rows of a sharepoint list with power automate.
My list is sorted that when a user insert a new row it comes on top of the list. I would like
a flow that deletes the oldest 50 rows of the list.
I have wrote a powershell script that works fine but I want to use a power automate flow instead.
But i do not know how?
Gr. P
Accepted Solutions
Hey @PeKi72
Use Get Items function. In that in top count give 50 and in Order By give: Created asc
After this use action delete item.
I hope this helps. If you like it and it works accept it as a solution and a kudo will help too. 😉
Hey @PeKi72
Use Get Items function. In that in top count give 50 and in Order By give: Created asc
After this use action delete item.
I hope this helps. If you like it and it works accept it as a solution and a kudo will help too. 😉
Helpful resources
WHAT’S NEXT AT MICROSOFT IGNITE 2022
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Register for a Free Workshop
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Check out all of these events
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
