Unanswered

Filter not working

(0) Share

Report

Posted on by albertocapm

I have 2 problems:
1- In the following formula only the search with the Ticket is working, if I eliminate the formula " || Ticket = Value(TextInputSearch.Value)", then SartWith works. But they don't both work at the same time.

2- The second problem is that the filters that use the combo box do not work together, only separately. For example, if the Status filter is used the Project number filter will not work

Full Code:

SortByColumns(
Filter(
CreateRecords,
StartsWith(
Description,
Trim(TextInputSearch.Value)
) || Ticket = Value(TextInputSearch.Value)
&& (Status = FilterComboBox_Status.Selected.Status || FilterComboBox_Status.Selected.Status = Blank()) && ('Project Number' = FilterComboBox_Project.Selected.ProjectNumber || FilterComboBox_Project.Selected.ProjectNumber = Blank())
),
"Ticket",
SortOrder.Descending
)

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (0)

QuentinDURIEZ 577 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Instead of chaining AND operators, you can simply chain conditions within the filter formula

SortByColumns( Filter( CreateRecords, IsBlank(TextInputSearch.Value) Or Or(StartsWith(Description, Trim(TextInputSearch.Value)), Ticket = Value(TextInputSearch.Value)), IsBlank(FilterComboBox_Status.Selected) Or Status = FilterComboBox_Status.Selected.Status, IsBlank(FilterComboBox_Project.Selected) Or 'Project Number' = FilterComboBox_Project.Selected.ProjectNumber ), "Ticket", SortOrder.Descending )

Regards,

Was this reply helpful? Yes No
WarrenBelz 154,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @albertocapm ,

You just need two extra brackets around the Or() elements - also set the Value of TextInputSearch to "" (empty string)

SortByColumns( Filter( CreateRecords, ( StartsWith( Description, Trim(TextInputSearch.Value) ) || Ticket = Value(TextInputSearch.Value) ) && ( Status = FilterComboBox_Status.Selected.Status || FilterComboBox_Status.Selected.Status = Blank() ) && ( 'Project Number' = FilterComboBox_Project.Selected.ProjectNumber || FilterComboBox_Project.Selected.ProjectNumber = Blank() ) ), "Ticket", SortOrder.Descending )

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
albertocapm 32 on at

Like (0)

Report
Copy link

Link copied!

I still have the same problem. It only filters based on the ticket and does not filter based on the description. As with combo box filters, only apply one at a time

Was this reply helpful? Yes No
albertocapm 32 on at

Like (0)

Report
Copy link

Link copied!

I still have the same problem. It only filters based on the ticket and does not filter based on the description. As with combo box filters, only apply one at a time. I have add the brackets and the he Value of TextInputSearch is set to "".

Please find below the code:

SortByColumns(
Filter(
CreateRecords,
(
StartsWith(
Description,
Trim(TextInputSearch.Value)
) ||
(Ticket = Value(TextInputSearch.Value))
) &&
(
Status = FilterComboBox_Status.Selected.Status ||
(FilterComboBox_Status.Selected.Status = Blank())
) &&
(
'Project Number' = FilterComboBox_Project.Selected.ProjectNumber ||
(FilterComboBox_Project.Selected.ProjectNumber = Blank())
)
),
"Ticket",
SortOrder.Descending
)

Was this reply helpful? Yes No
mmbr1606 14,615 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @albertocapm

can you please try this:

SortByColumns( Filter( CreateRecords, (StartsWith(Description, Trim(TextInputSearch.Value)) || Ticket = Value(TextInputSearch.Value)) && (Status = FilterComboBox_Status.Selected.Status || IsBlank(FilterComboBox_Status.Selected.Status)) && ('Project Number' = FilterComboBox_Project.Selected.ProjectNumber || IsBlank(FilterComboBox_Project.Selected.ProjectNumber)) ), "Ticket", SortOrder.Descending )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
albertocapm 32 on at

Like (0)

Report
Copy link

Link copied!

thanks for the help. Still I am facing the same problem with that formula

Was this reply helpful? Yes No
WarrenBelz 154,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@albertocapm ,

If you want my help. please tag me - this is really a matter of logic and understanding what exactly it is you want in the combination of those filters.

Was this reply helpful? Yes No
albertocapm 32 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Yes I would like your help. The logic is that the gallery should be able to be filtered with any combo box, and more than one filter should be able to be used at the same time. Also to be able to search the gallery using a text that searches in the Ticket and Description columns. I am using SQL as a data Base, and de table name is CreateRecords

Was this reply helpful? Yes No
WarrenBelz 154,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@albertocapm ,

Yes, but it is the and/or logic that needs to be understood. Do you want a "reducing" set, so you are filtering each data set further with the next selection, or do you want to show all records that match any of the selections (or a combination of this)

Was this reply helpful? Yes No
albertocapm 32 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz a combination will be perfect

Was this reply helpful? Yes No