You’re offline. This is a read only version of the page.
33
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."
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 :
Share
Report
All responses (
Answers (
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
