Power Platform Community Forum Thread Details

Hi All,

I am trying to filter Gallery based on combo box value (RequesterDD). The Combo box value Item (Requestor field in SPO with mulit-people picker turned on).

The Gallery Item code:

Filter(
collectionName,

If(
IsBlank(RequesterDD.Selected.Value) Or Requestor in RequesterDD.Selected.Value,
true
)

)

Requestor error out and "Invalid argument type. Cannot use Table values in this context."

Categories:

Building Power Apps

Hi , @abeyenen72

According to your description, you want to filter the multiple Persons selection column using filter function.

For example , this is my test SharePoint list:

And for this list , we get the Table type in PersonsTest column, so we need to judge for the Table .

If the Combo box's filed is DisplayName for the users like this:

If your combo box allow multiple selections,We can use this code to filter :

Set(data2,Filter( Multy_PersonColumns , CountIf(ThisRecord.PersonsTest As persons , persons.DisplayName in ComboBox1.SelectedItems.DisplayName)>0 ) )

If your combo box do not allow multiple selection, we can use this code to filter:

Set(data4,Filter( Multy_PersonColumns , ComboBox1.Selected.DisplayName in ThisRecord.PersonsTest.DisplayName ) )

You need to replace the TableName and ColumnName in your side .

The "Multy_PersonsColumns" is my SharePoint List Name and the "PersonsTest" is my multiple selections Persons column in SharePoint list.

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution, thanks in advance!

Best Regards,

Yueyun Zhang