web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Gallery Based o...
Power Apps
Unanswered

Filter Gallery Based on combo box using People Picker field

(1) ShareShare
ReportReport
Posted on by 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."

 

Categories:
I have the same question (0)
  • v-yueyun-msft Profile Picture
    Microsoft Employee on at

    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:

    vyueyunmsft_0-1704260117742.png

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

    vyueyunmsft_0-1704261212038.png

     

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

    vyueyunmsft_1-1704260218598.png

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 534

#2
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 306

Last 30 days Overall leaderboard