web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Countif has stopped wo...
Power Apps
Answered

Countif has stopped working

(0) ShareShare
ReportReport
Posted on by 24

Help!!

 

I'm using a connection simple table in SQL server that has a collum called Date_Entered. I set up a countif in power apps using the following formuls to count the number of records entered today.

 

CountIf('[dbo].[Hotel]_2',Date_Entered>=Today())

 

I know this used to work but has stopped working sometime in the last few weeks.

 

I have 2017 records in the SQL table now.

 

Is this becasue of the 500 limit I have been reading about?

 

If so is there a way around this?

 

Any Help appreciated.

Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    on at

    Hi @andycreigh,

     

    Yes, it is because that CountIf function does not support delegation:

    Capture.PNG

     

    I'm afraid that there is no workaround that I could think of. 

     

    Regards,

    Mona 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard