Delegation Issue with Distinct Function

(1) Share

Report

Posted on by mokibby

 ClearCollect(ColOffice, Distinct('RSheet', Assistant)); rewrite this code to overcome the delegation issues please. RSheet is a SQL Table with more than 2000 rows. 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi mokibby,

You can collect RSheet rows in a collection first.
ClearCollect(ColRSheet, 'RSheet'); ClearCollect(ColOffice, Distinct(ColRSheet, Assistant));

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Suggested answer

MichaelFP 1,847 Super User 2025 Season 2 on at

Like (0)

Report

I would recommend you to create a view to apply this Distinct, and execute the view in the power apps.

Was this reply helpful? Yes No