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
The largest Power BI, Power Platform, and Data conference in New Zealand