Answered

CountIF question

(0) Share

Report

Posted on by iskguy

402

I need to do a countif (to return an integer) if the SharePoint list record matches the Last AND First Names from a different data source being brought in. I have this, but there is a delegation warning:

CountIf('Consumer List',ThisItem.LastName = LastName && ThisItem.FirstName = ThisItem.FirstName)

I want to use this in the text of a label in a datacard of a gallery.

The gallery Items is this:

Sort(GroupBy(ShowColumns('Consumer Orders',"FullName","Street","Apt","DOB","LastName","FirstName","ZIP","City"),"FullName","Street","Apt","DOB","LastName","FirstName","ZIP","City","FullNames"),FullName,Ascending)

If I do just a CountIf and use 'Consumer List'.FirstName, I get a non-delegated value. Or is there a better way to do this? I ultimately want to get a 'weighted' value based on matches between the two datasets.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

If your datasource will not go over the 2k limit you do not need to worry about delegation warnings, they will not be showed to your users.

That being said CountRows, COuntIf etc are not delegable as of yet. SO you will always get that error when using them on sharepoint. Only way around that would be to collect the data first then counting the local collection

See Sharepoint Delegation

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@iskguy

You can avoid the delegation warnings and issues, but your formula is not accurate for the CountIf.

Please consider changing your Formula to the following:

CountRows( Filter('Consumer List', LastName = LastName && FirstName = ThisItem.FirstName ) )

If that still provides delegation or other warnings, change it to:

With({_items: Filter('Consumer List', LastName = LastName && FirstName = ThisItem.FirstName ) }, CountRows(_items) )

I hope this is helpful for you.

Was this reply helpful? Yes No
iskguy 402 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply. The main dataset is around 50K records. The other is around 1000K depending on use,

Was this reply helpful? Yes No