CountRows is returning a delegation error

(0) Share

Report

Posted on by johnjohn123

3,514

I have the following formula, but it is raising a delegation error:-

is there a way to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@johnjohn123

Short answer, No. CountRows isn't delegable. You can make the visibility of the error go away by using a With() statement but that won't change what data the formula returns/acts on.

To fix, you can create a collection of your data then apply the formula to that. Bear in mind that if you need more than 2000 records you will need to apply some extra code

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymouswe already has 8,000 items inside the Activities SharePoint list and 1000 records inside the Project list.. so how we can fix this issue? what i am trying to do is to get the number of activities that are related to the Project and has the status = completed then divide the number by the total number of of activities under the project.. so how i can achieve this then?

in short i have 2 SharePoint lists; Project Master & Activities. the Activities has a lookup field to the Project list named ProjectTitle, as follow:-

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@johnjohn123

It seems you are filtering on 1 Project number only, is this correct? If so, and you know that there will NEVER be more than 2000 activities / Project then you could just do something like this

With( { wCompleted: Filter(Activities, ProjectTitle.Value=varProjectdetails.Title, Status.Value = "Completed"), wAll: Filter(Activities, ProjectTitle.Value=varProjectdetails.Title) }, CountRows(wCompleted) / CountRows(wAll) // add your formatting here )

You can add your formatting where I've indicated - I was just lazy and didn't do it lol

This will remove the delegation error but be aware that this formula will only ever bring back a maximum of 2000 records each for wCompleted and wAll.

Was this reply helpful? Yes No