Announcements
Good morning everyone, I would like to use the CountIf function and I know that I need to enable the "Enhanced delegation for Common Data Service" option by following the instructions on this page https://learn.microsoft.com/it-ch/power-platform/power-fx/reference/function-table-counts but... I can't find the option in either the Model Driven or Canvas app settings. Is this by any chance an option that needs to be enabled by my company administrator?When I try to use CountIf anyway I get the message "CountIf" is an unknown or unsupported function.Thank you for your help
Hi @Alberto3 ,
I do not see this option available in my environments as well. I am expecting this is not rolled out completely yet. I am in the US and it is not available in my tenants. I am checking into this and will update if I find anything out...
Hi @dpoggemann , thank you.
If you or someone else can suggest me an alternative to that function it would be great 👍
Not available in my tenant either as of today. Did you find an approach that is workable for you?
This "enhanced marketed option!" is also not available in my UK tenant. Again, I have a similar issue as I want to CountRows() , running against a Dataverse filter. So is the only option to run an instant Power Automate and for it to run a FetchXML query and then count the rows in the array output?
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
