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,810 Super User 2026 Season 1 on at

Like (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 (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,810 Super User 2026 Season 1 on at

Like (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 (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 (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 (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