Combo box with search function doesn't show list

Like (0) Share

Report

Posted on 28 Oct 2022 09:34:45 by Mojpage

103

Hello,

This is a small issue, but I know it can be resolved. I've inserted a dropbox into a datacard cell in a form. When i don't have the searchable function on (is searchable = false) it works fine and shows the dropdown list to choose from (see pic 1).

When I change the searchable to true, the search box covers the width of the box and when typed in it doesn't offer relevant options (see first image below). I have a colleague who has managed to make this happen (see second image below). Is there something I'm doing wrong? The only extra thing to note is that the box has a filter on it, so it only returns some items from a list rather than all of them. I don't see how that could be a factor, but what do I know!

Thanks!

I have the same question (0)

All responses (7)

Answers (0)

Mojpage 103 on 28 Oct 2022 at 10:50:40

Like (0)

Report

Re: Combo box with search function doesn't show list

The solution might have something to do with creating a collection? I've never done that, is that right?

Was this reply helpful? Yes No
Mojpage 103 on 01 Nov 2022 at 09:35:48

Like (0)

Report

Re: Combo box with search function doesn't show list

If anyone can advise on this, I'd really appreciate it.

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on 01 Nov 2022 at 09:54:41

Like (0)

Report

Re: Combo box with search function doesn't show list

@Mojpage Make sure you have the correct column defined in the SearchFields property of the Combo box:

Was this reply helpful? Yes No
Mojpage 103 on 01 Nov 2022 at 10:15:55

Like (0)

Report

Re: Combo box with search function doesn't show list

Yes, I do. I know I do because when I set searchable to 'false' the combo list appears as I would like. When I set it to 'true' the list disappears and the search bar appears wider than it should be (see second image in original post).

I do have this filter in the items field to ensure that only list items with an '(M)' at the end of their name come through.

Distinct(Filter(_Projects,"(M)" in Project_name), Project_name)

This seems to be the only difference between what I've done and my colleague, who was successful, has done.

Thanks

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on 02 Nov 2022 at 02:30:15

Like (0)

Report
Re: Combo box with search function doesn't show list

Distinct() returns a table with a single column "Result" so in SearchFields instead of ["Title"] like in the screenshot I provided, you might try instead:
["Result"]

Was this reply helpful? Yes No
Mojpage 103 on 02 Nov 2022 at 13:31:08

Like (0)

Report

Re: Combo box with search function doesn't show list

Yeah it sets to 'Result' as standard. In fact I just checked and you can't change it, so that's fine.

Was this reply helpful? Yes No
WarrenBelz 151,686 Most Valuable Professional on 06 Nov 2022 at 07:27:25

Like (0)

Report
Re: Combo box with search function doesn't show list

@Mojpage ,

If you want Title

RenameColumns( Distinct( Filter( _Projects, "(M)" in Project_name ), Project_name ), "Result", "Title" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No