web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter gallery by pers...

Power Apps

Answered

Filter gallery by person or group combobox

(0) Share

Report

Report

Posted on by marial16

443

Hallo,

i have a gallery which i want to filter based on a combo box that allows multiple values.

Items property in the combo box:

Sort(Distinct(Ungroup(colTargetGoals, "Assignee"), DisplayName), Result,Ascending)

Items in gallery returns error when i type the following:

Filter(
colTargetGoals,
And(
Or(IsBlank(AssignToCB.SelectedItems),
IsEmpty(AssignToCB.SelectedItems),
Assignee in AssignToCB.Selected.Result
),
TextInput1_2.Text in Title
)
)

"""Cannot use table values in this context..."""

Any ideas?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @marial16 ,

From the look of it, the Assignee column is a multiselect column and that's why it can't be used in the context of the "in" operator as that will only accept a single value, not a table as is returned in this case.

In case your combobox is a single select, you might try reversing the in statement:

Filter( colTargetGoals, And( Or(IsBlank(AssignToCB.SelectedItems), IsEmpty(AssignToCB.SelectedItems), AssignToCB.Selected.Result in Assignee ), TextInput1_2.Text in Title ) )

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/operators
marial16 443 on at

Like
a
(1)

Report
Copy link

Link copied!
Hallo,

I tried this with the allow multiple selections of the combobox to 'Οn'
Below code seems to work

Filter( colTargetGoals, And( Or(IsBlank(AssignToCB.SelectedItems), IsEmpty(AssignToCB.SelectedItems), AssignToCB.Selected.Result in Assignee.DisplayName ), TextInput1_2.Text in Title ) )

Join the conversation