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:

Using Apps Using Formulas

All responses (3)

Answers (1)

IBrant on at

Like (0)

Report

Re: Sorting and Switching for Views

That worked perfectly! Thank you so much!
IBrant on at

Like (0)

Report

Re: Sorting and Switching for Views

That worked perfectly! Thank you so much!
Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Sorting and Switching for Views

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