Filtering with a GroupBy and AddColumns

(0) Share

Report

Posted on by iskguy

402

GroupBy(
 AddColumns(
 ISK_Jails,
 "SSNMatchScore",
 If(
 CountIf(
 ISK_Consumers,
 SSN = SocialSecurityNumber
 ) > 0,
 3,
 0
 ),
 "FirstName",
 First(Split(Name," ")).Result,
 "MiddleName",
 First(LastN(Split(Name," "),2)).Result,
 "LastName",
 Last(Split(Name," ")).Result
 ),
 "cr4d3_name",
 "FirstName",
 "MiddleName",
 "LastName",
 "cr4d3_transtype",
 "SSNMatchScore",
 "cr4d3_socialsecuritynumber",
 "cr4d3_recordid","cr4d3_active",
 "GroupedRecords"
)

If I want to include a Filter on the above statement, what is the proper syntax or placement for the Filter? I have a column in the dataverse table that is cr4d3_active and I want to filter where only Active=true. I have tried putting Filter at the beginning and then right after the GroupBy but neither is working and perhaps my logic is flawed also. Is there a better best-practice for this? Thanks for the information.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

HenriDesmet59 295 on at

Like (0)

Report
Copy link

Link copied!
Hello @iskguy ,

I think you can put your filter just around your AddColumn :
GroupBy( Filter( AddColumn(...), //Filter ) )

Tell me if It's works 🙂

Henri

Was this reply helpful? Yes No