Answered

Allow multiple items selected from a combo box to appear in a gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a gallery where I want to show the items which have been selected through a combo box. The combo box formula is: Distinct('Referral Tracker',Department), meaning that as Departments are added through form responses, these are automatically included in the drop-down selections.

I’m currently stuck with the gallery only selecting the most recently selected item within the combo box, rather than selecting multiple at the same time. How can I amend my gallery and combo box, so I can select more than one department to appear within my gallery?

Gallery formula: Filter('Referral Tracker',IsBlank('Department Combo Box'.SelectedItems.Result) || IsEmpty('Department Combo Box'.SelectedItems) || Department = 'Department Combo Box'.Selected.Result)

Combo box: ‘Department Combo Box’

Data source: ‘Referral Tracker’

Column from data source: ‘department’

Combo box formula: Distinct('Referral Tracker',Department) Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

David_G 62 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello CamArmstrong, I'm not sure that how look the 'Department Combo Box'.Selected.Result result, but, in your filter, can you try to replace the "=" by "in"

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the help David, appreciate it!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

In case it's of use to anyone down the line, I was able to find a solution to this with the help of the below YT Video: https://www.youtube.com/watch?v=5dSk5iOgT68&t=540s

I replaced the '=' with 'in' and the 'Selected.Results' with 'SelectedItems' at the end of the formula.

Filter('Referral Tracker',IsBlank('Department Combo Box'.SelectedItems.Result) || IsEmpty('Department Combo Box'.SelectedItems) || Department in 'Department Combo Box'.SelectedItems)

Was this reply helpful? Yes No