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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - AI Builder / COUNT FORMULA SUPPORT ...
Power Apps - AI Builder
Suggested answer

COUNT FORMULA SUPPORT NEEDED

(0) ShareShare
ReportReport
Posted on by CU08100611-0
So I have 3 drop down lists showing
 
1) Owner : DropNames
2) Sites : DropSites
3) Technology:DropTech
 
 
I have 1st button applied this formula of SUM TOTAL HEADS
 
Sum(If(IsBlank(DropNames.Selected.Value) || IsBlank(DropSites.Selected.Value) || IsBlank(DropTech.Selected.Value),Sum(Prod,TotalHeads)),Sum(Filter(Prod,Owner.DisplayName = DropNames.Selected.Value,Site = DropSites.Selected.Value,Tech=DropTech.Selected.Value),TotalHeads))

I want to apply same formula for 2nd button which already has following formula 
CountIf(Prod,Status="G0")
 
How I can apply COUNT formula on my 2nd button using same logic as used in first button
 
Categories:
AI Builder
I have the same question (0)
  • Suggested answer
    WarrenBelz Profile Picture
    WarrenBelz 151,135 Most Valuable Professional on at
    COUNT FORMULA SUPPORT NEEDED
    The main issue here is Delegation and you can manage the first one like this 
    With(
   {
      Data:
      Filter(
         Prod,
         (
            Len(DropNames.Selected.Value) = 0 ||
            Owner.DisplayName = DropNames.Selected.Value
         ) &&
         (
            Len(DropSites.Selected.Value) = 0 ||
            Site = DropSites.Selected.Value
         ) &&
         (
            Len(DropTech.Selected.Value) = 0 ||
            Tech = DropTech.Selected.Value
         )
      )
   },
   Sum(
      _Data,
      TotalHeads
   )
)
    for the second one - I am not sure if you want more filters added, but you can use the structure above 
    With(
   {
      Data:
      Filter(
         Prod,
         Status = "GO"
      )
   },
   CountRows(_Data)
)
     
    Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful?
    Visit my blog     Practical Power Apps    LinkedIn  
  • WarrenBelz Profile Picture
    WarrenBelz 151,135 Most Valuable Professional on at
    COUNT FORMULA SUPPORT NEEDED
    A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.
     
    Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful?
    Visit my blog     Practical Power Apps    LinkedIn   

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

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 829 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 489

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 395 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Question for everyone : How are you using Create Text GPT in AI Builder?

Product updates

Microsoft Power Platform Community release plans