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)))
Solved! Go to 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)))
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)))
Worked perfectly. You available for contract work? 😉
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 ).
User | Count |
---|---|
125 | |
87 | |
86 | |
75 | |
69 |
User | Count |
---|---|
215 | |
181 | |
140 | |
97 | |
83 |