cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bryanc78
Helper II
Helper II

Get items - avoiding changing the 100 item limit and SP lists

So, I know I can update the limit but for my purposes, I don't really need to increase the limit if I could just have flow sort my SP list and go through the default 100 items if it could start with the oldest item first

 

I have a SP list of about 4000 items.  I have a flow set up to delete items older than say 100 days.  In order to get through the entire list, I have the Get Item limit set at 4000 items but that takes up a lot of time to run.  Could flow just go through the oldest 100 items and check those instead?  I don't need flow to even look at new items as that would be a waste of time and resources

1 ACCEPTED SOLUTION

Accepted Solutions
rimatos
Community Support
Community Support

Hi @bryanc78 ,

 

You forgot to add a ' at the end of your formula

 

rimatos_0-1599055402875.png

 

After inserting this it should work fine 🙂

 

Regards,

Ricardo

View solution in original post

3 REPLIES 3
PrasadAthalye
Super User
Super User

In Get Item, you can provide where clause to filter on the Creation Date and only filter required items and delete them. Also add the index on Created Date in List Settings.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

@PrasadAthalye 

 

I feel like I'm close but getting an error using this

 

bryanc78_0-1599052043854.png

 

 

The expression "Created lt '2020-06-06" is not valid. Creating query failed.
clientRequestId: 7a5cd2f6-2bb0-46fd-bfe5-3d6659157cef
serviceRequestId: 7a5cd2f6-2bb0-46fd-bfe5-3d6659157cef

 

I'm trying to filter out items that are older than say 88 days so I can then delete them.  Anything obvious that I'm missing

rimatos
Community Support
Community Support

Hi @bryanc78 ,

 

You forgot to add a ' at the end of your formula

 

rimatos_0-1599055402875.png

 

After inserting this it should work fine 🙂

 

Regards,

Ricardo

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,348)