web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Help with TextSearch a...

Power Apps

Unanswered

Help with TextSearch and DropDown while using Gallery

(0) Share

Report

Report

Posted on by jneuen

55

Hi,

Trying to get our gallery to be filterable with DropDowns and TextSearch.

I have this for the dropdowns:

Filter('V23 Recruitment Request', 'HRIS Status'.Value = Dropdown3_14.Selected.Value && 'Request Category'.Value = Dropdown3_22.Selected.Value)

I have this for the textsearch:

SortByColumns(Search('V23 Recruitment Request',TextSearchBox1.Text,"VICELastName_x002f_New","VicePositionNumber","FacilitySearch"), "Created", If(SortDescending1, Descending, Ascending))

Is it possible to get them into one gallery?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@jneuen

Please consider changing your Formula to the following:

SortByColumns( Search( Filter('V23 Recruitment Request', 'HRIS Status'.Value = Dropdown3_14.Selected.Value && 'Request Category'.Value = Dropdown3_22.Selected.Value ), TextSearchBox1.Text, "VICELastName_x002f_New", "VicePositionNumber", "FacilitySearch" ), "Created", If(SortDescending1, Descending, Ascending) )

I hope this is helpful for you.

Join the conversation