How to delete the last (oldest) 50 rows of a Sharepoint list with Power Automate?

[PeKi72]

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

[Sundeep_Malik · Accepted 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. 😉