Answered

Trying to connect Sort(Filter and a filter through my Text input search bar for my Gallery.

(0) Share

Report

Posted on by SomeArmyVet

Hello,

Separately, I can connect my Sort(Filter without issues and I can connect my Text Input (search bar) without issues, but I am having issue trying to connect them together. Can someone help please? Thank you in advance!

***I understand this is not delegable, but it doesn't need to be.

Sort(Filter(DIV3WorkPlanFY22,Status.Value= "Refer To Compliance"),Title,Ascending) ***This filters my gallery by a choice in my SP List and then sorts by Title ascending.

And this...

Filter(DIV3WorkPlanFY22, StartsWith(Title,SearchFilterFirm_2.Text)||StartsWith(FEI,SearchFilterFirm_2.Text)||StartsWith('CbCMSCase#',SearchFilterFirm_2.Text))

***This is my Text Input Search Bar that searches 3 ways... Title, FEI and CMS#.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SomeArmyVet ,

You can combine the arguments in the filter by separating them with a comma, which will treat them as a logical AND:

Sort( Filter( DIV3WorkPlanFY22, Status.Value= "Refer To Compliance", StartsWith(Title,SearchFilterFirm_2.Text)|| StartsWith(FEI,SearchFilterFirm_2.Text)|| StartsWith('CbCMSCase#',SearchFilterFirm_2.Text) ), Title, Ascending )

Was this reply helpful? Yes No
SomeArmyVet 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for looking at this.

It doesn't show any errors, but it also leaves my gallery blank. I might have to add a IsBlank formula, but I am not sure.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SomeArmyVet ,

I assume the gallery does show something in case you type something in SearchFilterFirm_2?

If so, adding an IsBlank() should do the trick:

Sort( Filter( DIV3WorkPlanFY22, Status.Value= "Refer To Compliance", IsBlank(SearchFilterFirm_2.Text) || StartsWith(Title,SearchFilterFirm_2.Text)|| StartsWith(FEI,SearchFilterFirm_2.Text)|| StartsWith('CbCMSCase#',SearchFilterFirm_2.Text) ), Title, Ascending )

Was this reply helpful? Yes No
SomeArmyVet 23 on at

Like
a
(0)

Report
Copy link

Link copied!

I feel like I am right there, but still even with the added IsBlank() my gallery doesn't show info. Which is weird because I can connect one formula at a time and that formula works great it's when everything is combined it goes blank.

Was this reply helpful? Yes No
SomeArmyVet 23 on at

Like
a
(0)

Report
Copy link

Link copied!

No, my search doesn't pull anything up either. It does when connected by itself though.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SomeArmyVet ,

So either formula for Items property is working as per you said, you could try the nested filter as follows:

With( {Fitered:Filter(DIV3WorkPlanFY22,Status.Value= "Refer To Compliance")}, Sort( Filter( Filtered, StartsWith(Title,SearchFilterFirm_2.Text) || StartsWith(FEI,SearchFilterFirm_2.Text) || StartsWith('CbCMSCase#',SearchFilterFirm_2.Text) ), Title, Ascending ) )

Hope this helps.

Was this reply helpful? Yes No