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
Solved! Go to Solution.
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. 😉