Unanswered

Two Names in ComboBox should Auto-populate Gallery

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I have a ComboBox1 and Gallery1.

Gallery1 auto-populates based on the default or chosen content of ComboBox1.

ComboBox1 is set for selecteMultiple = true; MultipleValueDelimiter ", "; IsSearchable = true.

Everything works with just one name chosen. However, if I choose two names in ComboBox1 nothing appears in Gallery1 even though there is a line item in the SP List with the two names in the same column separated by a comma.

How do I update the ComboBox/Gallery to provide the desired content when the two names in the ComboBox (in whatever order) match the two names in the column of the SP List (in whatever order)?

ComboBox1:
Items: Sort(EmployeeListCollection.Title,Title)
DefaultSelectedItems: [User().FullName]

Gallery1:
Items: Filter(SchedulerDetailsListCollection,Title in ComboBox2.SelectedItems)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

BCBuizer 22,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Phineas,

Can you please add .Value after SelectedItems to see if that fixes your issue?

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

It will not take .Value. There is an error "Name isn't valid. 'Value' isn't recognized"

It did take .Title.

However, that does not change what is displayed in the Gallery.

I get all the items from both names individually, but NOT the one item that has both 'Curtis T, Jimmy G' (as shown) even though there is a column in a line item in the SP List that has 'Curtis T, Jimmy G' as it's content.

Was this reply helpful? Yes No
BCBuizer 22,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Phineas ,

I assumed this is a single select column. Is there a maximum for how many names can be selected?

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @Phineas just to check if the interpretation of B is the same

Please try

ComboBox1:
Items: Sort(EmployeeListCollection.Title,Title).Title
DefaultSelectedItems: [User().FullName]

Searchfields: ["Title"]

Gallery1:
Items: Filter(SchedulerDetailsListCollection,Title in ComboBox2.SelectedItems.Title)

Hope it helps,

R

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

It is a Single line of text column in the SP list.

Power Apps has no restriction on the number that can be chosen and the field is set to 'SelectMultiple' = true.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Edit/Update: Issue resolved. I do see both individual AND where both names appear.

Can the edit be updated to show only 'both name data' when both names appear, and not the individual's as well?

Getting close.

Your edits get me the double name entries as desired.

However, the change also only returns the individual items associated with the first name chosen.

Desired display: Show the individual items associated with both names AND those where both names appear OR only show items where both names appear, and the use will have to remove a name to see individual's items.

Was this reply helpful? Yes No