Answered

Sorting and Switching for Views

(0) Share

Report

Posted on by IBrant

I'm trying to figure out how to use a search box, and ascending/descending order button with different views. The below formulas work great on their own. How do I combine them?

SortByColumns(Filter([@'Recruitment tracker'], StartsWith(Title, TextSearchBox1_2.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Switch(Dropdown1.Selected.ViewName,"My Candidates", Filter([@'Recruitment tracker'],'Recruiter'.Email = User().Email))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @IBrant ,

Please try:

SortByColumns( Switch( Dropdown1.Selected.ViewName, "My Candidates", Filter([@'Recruitment tracker'],'Recruiter'.Email = User().Email), Filter([@'Recruitment tracker'],StartsWith(Title, TextSearchBox1_2.Text)) ), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending) )

Best Regards,

Bof

Was this reply helpful? Yes No
IBrant on at

Like
a
(0)

Report
Copy link

Link copied!

That worked perfectly! Thank you so much!

Was this reply helpful? Yes No
IBrant on at

Like
a
(0)

Report
Copy link

Link copied!

That worked perfectly! Thank you so much!

Was this reply helpful? Yes No