Filter Status = "Active"

[bmarcowka]

I am trying to filter a datasource with over 50K records and only want to display the records that have a Status = "Active".  

Where int the items data would I select from the below? 

SortByColumns(Search('[dbo].[CRMCASE]', TextSearchBox1.Text, "ACCTNO","ADDRESS1","CASECATEGORY","CASENO","CASETOPIC","DRIVER"), "CREATEDON", If(SortDescending1, Descending, Ascending)))

[Jeff_Thorpe · Accepted solution]

I assume you want to continue to use the search box but filter the results to the Active records:

You could try this:

SortByColumns(Filter(
Search('[dbo].[CRMCASE]', TextSearchBox1.Text, "ACCTNO","ADDRESS1","CASECATEGORY","CASENO","CASETOPIC","DRIVER"), 'Status' = "Active"), 
"CREATEDON", If(SortDescending1, Descending, Ascending)))

[bmarcowka]

Worked perfectly.  You available for contract work?  😉

[Jeff_Thorpe]

I am glad it worked for you. I am not a consultant (just a corporate cube jocky) but if you are looking for a consultant to help you out with a project I would recommend reaching out to the good folks at PowerApps911.com ( @Shanescows ).