cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KimberlyM
Helper IV
Helper IV

CountIf no longer counting all my record entries

Up until recently I was able to keep count of all my record status settings. Now I notice none of my numbers are changing so I did an export of all my records and sorted by my 2020 records so so the excel screenshot is showing my actual record values where my powerapps is "maxed" out at 1624. Can someone suggest to me why this is happening?

 

My formula is:

CountIf(Lead_Data, CreatedYear = ReportYear_1.SelectedText.Value)

 

I have no delegation warnings so I am unsure why it would not be able to count the records.

See attached screenshot to see the formula, powerapp screen and excel document side-by-side.

11 REPLIES 11

Hi @KimberlyM ,

The reason why you still have problem is that:
The SharePoint ID field for a table is a number field in Power Apps. However, SharePoint only supports the equal ('=') operation for delegation on an ID field. "<",">" is not delegate for ID field.

 

You need to use other number field to filter.

I suggest you read more detailed about delegate functions for sharepoint :
https://docs.microsoft.com/en-us/connectors/sharepointonline/

 

To add a new number field, you need to update them one by one manually.

There's no very good solution.

Please do not use calculate column. This is not delegate neither.

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you @v-yutliu-msft so much for helping me! I am currently manually inputting the number to pull the records but it is working perfectly. Thank you for you patience in helping me understand and accomplishing what I needed! 

Helpful resources

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

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (4,429)