Answered

Sorting and Switching for Views

Like (0) Share

Report

Posted on 8 Jun 2023 15:02:41 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 09 Jun 2023 at 13:57:34

Like (0)

Report

Re: Sorting and Switching for Views

That worked perfectly! Thank you so much!
IBrant on 09 Jun 2023 at 12:44:24

Like (0)

Report

Re: Sorting and Switching for Views

That worked perfectly! Thank you so much!
Verified answer

v-bofeng-msft on 09 Jun 2023 at 02:35:32

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