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 ).
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
81 | |
50 | |
37 |
User | Count |
---|---|
290 | |
244 | |
122 | |
74 | |
55 |