cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
omi18
Post Partisan
Post Partisan

ComboBox Allow Search Not working

Hello,

 

I have a Combobox with items set to "Sort(Distinct(database.ID,ID),Result,Ascending)". 

I'm trying to make this Combobox searchable but it is not allowing me to do so.

 

Any suggestions? 

 

Thanks,

Omi

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

 

Sort(
       Distinct(
                 datasource,Text(
                                  ID
                             )
        ),1*Result,Ascending
) 

@omi18 

I checked it out on my side as well and confirmed that behaviour.   It will not search for numbers, just text so

I got Sort(Distinct(datasource,Text(ID)),Result,Ascending) to work.  The sort will appear flaky though unless you multiply Result*1. 

View solution in original post

2 REPLIES 2
Drrickryp
Super User
Super User

 

Sort(
       Distinct(
                 datasource,Text(
                                  ID
                             )
        ),1*Result,Ascending
) 

@omi18 

I checked it out on my side as well and confirmed that behaviour.   It will not search for numbers, just text so

I got Sort(Distinct(datasource,Text(ID)),Result,Ascending) to work.  The sort will appear flaky though unless you multiply Result*1. 

Hi @Drrickryp ,

 

That's right. I figured it out too. 

 

Thanks,

Omi

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,813)