Combo Box Confusion

(0) Share

Report

Posted on by sperry1625

765 Super User 2024 Season 1

I have a Combobox. The Items Property of the Combobox is as follows:

Filter('Teams', drpEventType.Selected.'Name (Title)' in 'Event Type'.Value )

This works well, it filters the data from the Teams list based on the selection in another dropdown. The user can select from the available Teams. Were it breaks is when I set IsSearchable to true. I enter a search string and nothing happens. No items are found/displayed for seletion. I set the SearchFields property to the same property that the dropdown is displaying, in this case ["Title"]. Is there something else I need to do? Am I doing something wrong?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@sperry1625

Is your 'Event Type' Column a multi-select column? I assume so as the search (with a filter like that) will not work properly.

Was this reply helpful? Yes No
sperry1625 765 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

Yes it is. I have resorted to creating a collection in the OnChange for the Event Type dropdown and setting the Items property of the Teams drop down to the collection.

The only thing I need to do now is clear the selection from the Combo Box when the event type changes. That isn't as simple as I thought it would be. But making progress. Is this the best solution, or is there a way to get it to work without the collection?

Thanks.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@sperry1625

You don't need collections or Change actions for this. It will work with the correct formula. But you really need to do it from the Dropdown.

What is the Items property of drpEventType?

Was this reply helpful? Yes No
sperry1625 765 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

Items = 'Event Types'. It is just the list name.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@sperry1625

Here is what I would do:

1) Change the Items property of the drpEventTypes to the following:

AddColumns( 'Event Types', "recs", Filter('Teams', 'Name (Title)' in 'Event Type'.Value ) )

2) Change the Items property of your ComboBox to drpEventTypes.Selected.recs

3) To force a reset of any "search" text entered. Set the OnChange action of the drpEventTypes to : Reset(yourCombobox)

That should give you the functionality you want.

Was this reply helpful? Yes No
sperry1625 765 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

That solution did not work. The column was added to the Event Types drop down but it was empty. Is that Filter correct? The In the Teams table, the Event Type column is a Multi select Lookup Column.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@sperry1625

The solution works well, so there must be an issue with the filter as you suggest.

My assumption was that you had a Multi-Select Choice column in your List. You are now stating that it is actually a LookUp column?

Please verify.

Was this reply helpful? Yes No
sperry1625 765 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes. The Event Type column in the Teams list is a Multi valued Lookup column. The lookup list is the Event Types list.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@sperry1625

Yes, to verify I just gave it a test - all works fine with this formula:

AddColumns( 'Event Types', "recs", Filter(Teams, 'Name (Title)' in 'Event Type'.Value ) )

So, let's review.

1) In the Teams list, you have a Lookup column that is Multi-Select and is a Lookup to the Event Types list?

2) In the SharePoint definition of that column, you are using the Value to connect as 'Name (Title)'?

Was this reply helpful? Yes No