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

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / COUNTIF in SharePointList
Power Apps
Unanswered

COUNTIF in SharePointList

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

The full ask is to have a complete count of how many YESs, N/As, and NOs in each row.   I've tried a couple COUNTIF versions but keep getting errors I can't share the full column names and data, BUT here's my excel example of what I'd like: Help???

 

 

OneTwoThreeFourTotal YesTotal NosTotal NAs
YESYESYESYES   
NOYESYESYES   
YESN/AYESYES   
NYESYESYES   
NOYESN/AYES   
N/ANOYESYES   

 

 

 

Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 153,084 Most Valuable Professional on at

    Hi @Anonymous ,

    The YES total would be (repeat for the others)

    CountRows(
 Filter(
 YourTableName,
 One="YES"
 )
)+
CountRows(
 Filter(
 YourTableName,
 Two="YES"
 )
)+
CountRows(
 Filter(
 YourTableName,
 Three="YES"
 )
)+
CountRows(
 Filter(
 YourTableName,
 Four="YES"
 )
)

     

    Please click Accept as solution 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 giving it Thumbs Up.

  • v-qiaqi@microsoft.com Profile Picture
    v-qiaqi@microsoft.com on at

    Hi@EEdwards,

    Based on the issue that you mentioned, do you want to count the Total YES/NO/NA in a row?

    Could you please share a bit more about the scenario, do you have a Gallery or a Form to do this calculation?

    In my scenario, I have generated an app directly based on a Table from the Excel as below:05.png

    This app has three screens by default, BrowseScreen for a Gallery to display all the items, DeatilScreen for a detail form to display the detailed information, EditScreen for an edit form to create or edit the certain item.

    In the Gallery, you could inset Labels as many as you want to display the column data. In my scenario, I insert 3Labels to display the Total YES/NO/NA.

    Set the Text property of the Label corresponding to the 'Total YES' as below:

    Sum(If(ThisItem.One="YES",1,0),If(ThisItem.Two="YES",1,0),If(ThisItem.Three="YES",1,0),If(ThisItem.Four="YES",1,0))

    Set the Text property of the Label corresponding to the 'Total NO' as below:

    Sum(If(ThisItem.One="NO",1,0),If(ThisItem.Two="NO",1,0),If(ThisItem.Three="NO",1,0),If(ThisItem.Four="NO",1,0))

    Set the Text property of the Label corresponding to the 'Total NA' as below:

    Sum(If(ThisItem.One="N/A",1,0),If(ThisItem.Two="N/A",1,0),If(ThisItem.Three="N/A",1,0),If(ThisItem.Four="N/A",1,0))

    What's more, if you want to save this total calculation into the Excel table, you could insert Button and set the OnSelect property as below:

    Patch(Table1,ThisItem,{'Total Yes':Label2.Text,'Total No':Label3.Text,'Total NA':Label4.Text})

    Note: Every clicking on the button in the current row of the gallery will save the total calculation result to the corresponding row in the Excel table.

    06.png

    Hope it could help.

    Best Regards,

    Qi

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    Tried it above and keep getting Sorry, something went wrong - Formula contains a syntax error or is not supported. 

     

    Here's the full messy names of just two of the columns to try and jumpstart it that way:::

    More> choosing calculated formula with output of a number

    this is what I tried once in Add Column> choosing calculated and data type returned of a number. 

     

    =CountRows(Filter(SiteAssessmentWorkPermit,ProperMonitoringTypeIdentifiedonWorkPemit="YES" ))+CountRows(Filter(SiteAssessmentWorkPermit,ConfinedSpaceSafetymeasuresSpecifiedOnPermit="YES"))

     

     

    EEdwards_1-1605717099639.pngEEdwards_2-1605717165699.png

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    This could potentially work for this view to give other some information, but the aim is to have this all push into a PowerBI for additional data analysis.  

     

    As for me following what you have listed above, I understand the concept of inserting Labels, but I have no idea where labels are , what view you have displayed below or how you start.  can you please fill in the blank for me?

    So far I'm looking at the list in gallery view....

  • CU-18081211-6 Profile Picture
    CU-18081211-6 9,270 Moderator on at

    @Anonymous ,

    So you are trying to get your result directly in calculated columns in Sharepoint. Here is my proposal for Total Yes:

    =IF([One]="Yes",1,0)+IF([Two]="Yes",1,0)+IF([Three]="Yes",1,0)+IF([Four]="Yes",1,0)

    Of course, the other columns will have a similar structure.

    From my point of view it is wise and safe to do this calculation directly in PowerBi ->PowerQuery.

     

    Hope it helps !

  • v-qiaqi@microsoft.com Profile Picture
    v-qiaqi@microsoft.com on at

    Hi@EEdwards,

    Could you please read my reply again?

    Could you please tell me what exactly is your data source, an SP list or ac Excel table?

    You said that you have an Excel table as the data source, so I advise you to generate an app directly based on the data source. 

    09.png

     

    10.png

    Then you could create an app, please check the following steps to inset Labels.

    11.png

    And you should put the formula I provided before within the Text property of the Label.

    I create a demo app, you can check it for details. Here are some guide how you can open this demo app on your device.

    12.png13.png

    Ps: If you have an SP list as your data source, please do make sure that every column type is a Text type in order that all the formula I provided you could use.

    Hope it could help.

    Best Regards,

    Qi

     

    Demo.msapp
  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    alright -- caught up and understand, but it seems the information is still not pulling or getting understood for any of the text after the ampersand.  my guess is I checked the data type and unfortunately it is listed as COMPLEX and not text, therefore that would be the why the "YES" and second portion may not be working? 

     

    EEdwards_0-1605824038548.png

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at

    unfortunately this one errors out in the powerBI option:  

     

    EEdwards_1-1605824584929.png

     

  • v-qiaqi@microsoft.com Profile Picture
    v-qiaqi@microsoft.com on at

    Hi@EEdwards,

    Could you please answer my questions firstly in order that I could capture the key?

    A complex column type, is it a Choice or other else?

    Please do provide more details for that I could not help if I'm the only one imagining things here.

    It is not enough to provide a screenshot about a formula, the error message is the most important.

    So please do answer the following question:

    1. What is the data type of the aimed column, a Choice type?

    If it is a Choice type, please replace the ThisItem.ColumnName with ThisItem.ColumnName.Value

    Hope it could help.

    Best Regards,

    Qi

     

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
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans