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.
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.