cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jackson_Dhorty
Helper III
Helper III

Count If and First Delegation Problem

Hi,

I am facing delegation issue to count number of lines and first operation from my share point list.

 

Warning: Count If Operation is not supported by this connector

Warning: First Operation is not supported by this connector

 

This is what I am trying:

Patch(
mySPList,

First(
Filter(
mySPList,
'Id' = varID
),

 

Total Line: CountIf(
mySPList,
Email = User().Email
)

)

On the other side, I have used the same formula in my past created apps using share point list but it didn't popup any delegation warning.

 

Can someone please help me out on this?

 

Thank You

1 REPLY 1
RezaDorrani
Dual Super User II
Dual Super User II

Hi @Jackson_Dhorty ,

 

Replace first(filter with lookup

 

countif is just not delegable with SharePoint 

 

I have defined workarounds for a lot of these in my delegation playlist

check it out here https://youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,918)