If your status column is Choice type, then please use below formula in items properties of gallery:-
Please mark this solution if it fulfill your requirement
SortByColumns(Filter(testing,StartsWith(Refrence,txtSearchField.Text) && (Status.Value="one")),"Title",Ascending)
Above formula is working at my end, you just needs to change the DSN and fields.
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