Announcements
I am trying to fetch distinct 5000 values from one table in collection. But it is only returning the distinct result to first 2000 rows due to delegate issue.
Hi , @preetiverma525
The Distinct() function do not support delegation in Power App side , if you want to extract all the distinct value in app , you may need to call flow to realize it.
Or you can add a second gallery to load the distinct value from the first gallery.
Distinct('Gallery1Name'.AllItems,'DistinctColumnName')
For more information, you can refer to :Solved: Delegation workaround for Distinct()? - Power Platform Community (microsoft.com)
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
Hi, Thanks for the prompt reply. I have applied this logic but my Gallery (hidden) is automatically showing only 100 records so distinct is now working only on 100 records.
How can I fetch full data in one go in hidden gallery (without paging).
Based on my experience, there is currently no way to automatically load all the data in the Gallery when the data source is delegable. So if you use this method , you need to manually scroll down the Gallery to get the whole data from your data source and it can not set visible in my thought.
If you want to auto get the data , i recommend you to use the flow instead.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 271
Mohsin Ali 239
