Answered

Filter Status = "Active"

(0) Share

Report

Posted on by 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)))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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)))

Was this reply helpful? Yes No
bmarcowka 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked perfectly. You available for contract work? 😉

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ).

Was this reply helpful? Yes No