51
Hello
Im having problems displaying all the dates in my filter. I have a sharepoint list i was using now has about 2392 records. I have a gallery that showed the data but first the user would select the date from the drop down to scroll to the record needed quicker. I had to update some of my records in sharepoint and now one of the dates doesnt show in the filter or gallery? Any help to resolve asap would be very much appreciated.
Hi @lterrazas @vipuljain03 is correct that this will be related to the delegation within your power app and your data source it larger than 2k records this will cause you delegation issues.
Using the date feild in the filter will be what is causing your this delegation issue maybe try and either find a way of converting the date to a numeric value such as ‘24/03/2024’ becomes 24032024 as a numeric value in your SharePoint list and then use this in your filter.
You could also try collecting the data in a batching process using power automate to gather the data and pass it back to your application.
Hope this helps
Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.
If the content was useful in other ways, please consider giving it Thumbs Up. 👍
Thanks
Andrew
@vipuljain03 I index the date column in sharepoint and that didnt do anything. Its still not showing the date in my filter.
@vipuljain03 so i just need to create an index column for my date column in sharepoint? My apologies I am a beginner and still learning.
Since your list has more than 2K records, the issue could be related to Delegation. The delegation limit for SharePoint data source in Power Apps is typically 500 records. This means that if you have a SharePoint list with more than 500 records, certain operations like filtering, sorting, and searching may not work as expected unless you implement delegation properly.
When filtering or sorting data in Power Apps, use delegable functions that SharePoint can process on its side. Examples of delegable functions include StartsWith, EndsWith, and operators like > (greater than) and < (less than) for dates.
Indexing in SharePoint: Check if the date column or any other relevant columns in your SharePoint list are indexed. Indexing can improve the performance of data retrieval and filtering operations, especially for large lists. You may need to index the date column if it's not already indexed.
https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint
Share
Report
All responses (
Answers (
