web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collection to only gra...

Power Apps

Answered

Collection to only grab time period from sharepoint

(0) Share

Report

Report

Posted on by Castner

30

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation