web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Distinct Searchable Co...

Power Apps

Answered

Distinct Searchable Combo Box

(0) Share

Report

Report

Posted on by Jamie1

1

Hi all,

I believe there is a bug in the combo box - when I set the items to

Sort(Distinct(Filter(Service_Systems,Supplier.Id = ACTIVESUPPLIER.ID),Name),Result,Ascending)

It populates correctly, when I switch isSearchable to true, no items are populated and typing does nothing.

There are no issues - just a warning for large data sets, but this is not an issue for us

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hey mate,

Distinct has issues on large datasets. If it's an SQL source, you can just create a view that grabs distinct records from where you're looking and this will fix the delegation issue.

Try removing Distinct() from that statement and seeing if it works.

Cheers,
Jacob | NextStep Creations
Taking your business the NextStep
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Jamie1 ,

Currently, the Distinct function is not a Delegable function within PowerApps, which could not be applied to a Delegable data source, otherwise, it would cause a Delegation warning issue.

Based on the issue that mentioned, I have made a test on my side, and don't have the issue that you mentioned. the screenshot as below:

The "IsSearchable" option of above ComboBox has been enabled.

As an alternative solution, please consider modify your formula as below:

Sort( GroupBy(Filter(Service_Systems,Supplier.Id = ACTIVESUPPLIER.ID), "Name", "GroupData"), Name, Ascending )

then check if the issue is solved.

Please consider re-add a new ComboBox into your app screen, then try above formula again, check if the issue is fixed. Also Please check if your "Service_Systems" data source is a Delegable data source

Best regards,

Join the conversation