
Due to delegation, the SharePoint list I’m grabbing for my collection is incomplete and I only want my collection to grab the last 90 days where the info will be filtered down by user.
currently the collection is grabbing everything it can but runs afoul of delegation. Is there a way I can do this? To filter a ClearCollect to only create a collection based on a time period.
Hi @Castner ,
Date queries are not delegable, but assuming what you are looking for is in the newest 2000 records (and you have your limit set to this in Advanced settings), then try this
ClearCollect(
colYourCollection,
Sort(
YourSPListName,
ID,
Descending
)
)Your date filters will then work on the collection.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.