SortByColumns(Search(TABLE, TextSearchBox1.Text, "PrimaryId", "Please_enter_your_full_name", "Work_Order"), "PrimaryId", If(SortDescending1, Ascending, Descending))
How do I add a Filter to the above code? I essentially just want to Filter out things where Approve = "1". Tried every combination I can think of but the formula just isn't happy.
You can use the result of the Filter function as the argument of the Search function:
Filter(TABLE, Approve <> "1"),
If(SortDescending1, Ascending, Descending))
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.