Filter Gallery by multiselect person column not working

(0) Share

Report

Posted on by Poweruser32490

126

Need to filter gallery by multiselect person column. May i know how to implement it? I tried below but doesn't work.

My Columnname is HODMultiselectCol

Filter(
        Datasource,
        Len(TextInput1_1.Text) = 0 || TextInput1_1.Text in Name.Value || TextInput1_1.Text in Department.Value || TextInput1_1.Text in HODMultiselectCol.DisplayName)
    )

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Poweruser32490,

Could you please try below code:

Filter( Datasource, //Update data source name as per yours IsBlank(TextInput1_1.Text) || TextInput1_1.Text in Name.Value || TextInput1_1.Text in Department.Value || !IsEmpty( Filter( HODMultiselectCol, //Confirm column name with your StartsWith( Lower(DisplayName), Lower(TextInput1_1.Text) ) ) ) ) //Update data source name and column name as per your names.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490,

You have tried very close, but probably it needs a little bit of tuning because the multi-select person column (HODMultiselectCol) is a table of records, I guess. And hence it is not a single value. You cannot directly use TextInput1_1.Text in HODMultiselectCol.DisplayName

Since HODMultiselectCol.DisplayName is a table, “in” expects a single-column table or a single value. Filtering data from a gallery by a multi-select person column based on a text input, you need to check if any of the selected people’s DisplayName contains the text input. We can achieve this by using the Filter and CountRows functions with Filter inside the multi-select column.

Please check this formula:

Filter( Datasource, Len(TextInput1_1.Text) = 0 || TextInput1_1.Text in Name.Value || TextInput1_1.Text in Department.Value || CountRows( Filter( HODMultiselectCol, TextInput1_1.Text in DisplayName ) ) > 0 )

What happens here:
CountRows(Filter(HODMultiselectCol, TextInput1_1.Text in DisplayName)) > 0 checks if any person in the multi-select column has a DisplayName that contains the text input.

In the first place, if it works, we can improve it further.

Please let me know if it helps. Please like or mark as answered if it does so.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490,

This is a bit complex and you need to "pull apart" the Table in the record with the multiple records as you cannot do a "double-in" filter (a Text String inside a Text value inside a Table).

The process below creates a record for each of the multi-value items with the rest of the fields the same values, which is then filtered with your Text input. You can use the non-Delegable in filter here as the process is already "local" after ther UnGroup action.

You then use the unique ID value on the output of this to get back one record for each (necessary if there are multiple matches on the same record for your text query). A proviso here (and you cannot avoid this no matter how you tackle it) - your Data Source numbers including the expanded set need to be under your (500 - 2,000) Data Row Limit.

With( { _Data: Filter( Ungroup( Datasource, HODMultiselectCol ), Len(TextInput1_1.Text) = 0 || TextInput1_1.Text in DisplayName || TextInput1_1.Text in Department ) }, Ungroup( ForAll( _Data As _D, Filter( Datasource, ID = _D.ID ) ), Value ) )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No