Skip to main content

Notifications

Power Platform Community / Forums / Power Apps Portals / Overcoming Delegation ...
Power Apps Portals
Unanswered

Overcoming Delegation Issues

Posted on by 28
 ClearCollect(ColOffice, Distinct('Reviewsheet', Assistant)); This is my code which is in the OnStart property of my app. How can I overcome the delegation issue in the distinct function.
The 'ReviewSheet' Table is a SQL Table.
Categories:
  • Suggested answer
    FLMike Profile Picture
    FLMike 23,361 on at
    Overcoming Delegation Issues
    Hi
     
    Unfortunately doing it how you are doing it no, there isn't.
     
    1 the collection itself will only hold 2000 even if you could query, if there are 2001 distinct you wont get them all no matter what
     
    But the Distinct is a Client side thing.
     
     

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,745

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard