cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeKi72
Post Patron
Post Patron

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

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?

 

PeKi72_0-1663247388761.png

Gr. P

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Sundeep_Malik
Community Champion
Community Champion

Hey @PeKi72 

Use Get Items function. In that in top count give 50 and in Order By give: Created asc

 

Sundeep_Malik_0-1663248801949.png

 

After this use action delete item. 

 

Sundeep_Malik_1-1663248838852.png

 

I hope this helps. If you like it and it works accept it as a solution and a kudo will help too. 😉

View solution in original post

1 REPLY 1
Sundeep_Malik
Community Champion
Community Champion

Hey @PeKi72 

Use Get Items function. In that in top count give 50 and in Order By give: Created asc

 

Sundeep_Malik_0-1663248801949.png

 

After this use action delete item. 

 

Sundeep_Malik_1-1663248838852.png

 

I hope this helps. If you like it and it works accept it as a solution and a kudo will help too. 😉

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,009)