Skip to main content

Notifications

Power Pages - Power Apps Portals
Unanswered

Overcoming Delegation Issues

Like (1) ShareShare
ReportReport
Posted on 10 Sep 2024 10:57:39 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 27,286 on 10 Sep 2024 at 22:40:18
    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.
     
     

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.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,769

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,466

Leaderboard
Loading started