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
Solved! Go to Solution.
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.
I feel like I'm close but getting an error using this
The expression "Created lt '2020-06-06" is not valid. Creating query failed.
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
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!