Gallery not filtering on Text field

(2) Share

Report

Posted on by S S

224 Season of Giving Solutions 2025

Hello,

I have a combo box that I want my Gallery to filter on. The combobox currently has Supervisor selected but the Gallery below is not filtering on the Combobox selection

The combo box items property is

Filter(Commands,StartsWith(Title,Self.SearchText))    Ref: Reza Dorrani https://www.youtube.com/watch?v=3tcmlvxgafk
 
For the gallery I have items property = 
Filter(Commands, Title.Text in 'Combobox1-Title_1')
 
I want to eventually combine that filter with the filter of other combo boxes.
Filter(Commands, EchII.Value='ComboboxCanvas2-EchII_1'.Selected.Value||'ComboboxCanvas2-EchII_1'.Selected.Value= "All") Ref Reza Dorrani
 
The filter in the gallery works for choice columns ("EchII") but not for the text column ("Title")
 
Any suggestions is appreciated.
 
Sharon

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Haque 3,653 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @S S,

For a text column like Title, you should compare directly to the selected value of the combo box:

Filter( Commands, (IsBlank('Combobox1-Title_1'.Selected.Value) || 'Combobox1-Title_1'.Selected.Value = "All" || Title = 'Combobox1-Title_1'.Selected.Value) )

Combined Filter with Choice Column, now merge with your EchII choice column filter:

Filter( Commands, (IsBlank('Combobox1-Title_1'.Selected.Value) || 'Combobox1-Title_1'.Selected.Value = "All" || Title = 'Combobox1-Title_1'.Selected.Value), (IsBlank('ComboboxCanvas2-EchII_1'.Selected.Value) || 'ComboboxCanvas2-EchII_1'.Selected.Value = "All" || EchII.Value = 'ComboboxCanvas2-EchII_1'.Selected.Value) )

Please note that the key difference is that choice columns in Dataverse are stored as records with a .Value property, while text columns are plain strings. That’s why your filter works for EchII but not for Title.

An optmized version of the code:

Filter( Commands, // Title filter (text column) (IsBlank('Combobox1-Title_1'.Selected.Value) || 'Combobox1-Title_1'.Selected.Value = "All" || Title = 'Combobox1-Title_1'.Selected.Value), // EchII filter (choice column) (IsBlank('ComboboxCanvas2-EchII_1'.Selected.Value) || 'ComboboxCanvas2-EchII_1'.Selected.Value = "All" || EchII.Value = 'ComboboxCanvas2-EchII_1'.Selected.Value) )

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
Verified answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
Correct Gallery Filter for Text Column

Use:

Filter(
Commands,
Title = Combobox1.Selected.Title
)

If the combobox displays the Title field, this will filter correctly.

Check these properties:

ComboBox Items

Filter(Commands, StartsWith(Title, Self.SearchText))

ComboBox DisplayFields

["Title"]

ComboBox SearchFields

["Title"]

Was this reply helpful? Yes No
S S 224 Season of Giving Solutions 2025 on at

Like
a
(1)

Report
Copy link

Link copied!

@Haque and @11manish Thank you! I will try these solutions out and I'll post how it goes. I very much appreciate the quick response

Was this reply helpful? Yes No
S S 224 Season of Giving Solutions 2025 on at

Like
a
(1)

Report
Copy link

Link copied!

@Haque and @11manish

I tried both of your solutions and they both worked like a charm! Thank you for the detailed explanation of why mine didn't work.

and

Was this reply helpful? Yes No