cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yuna-Evita
Helper I
Helper I

Count specific text in datatable column

Hello everyone,

 

In my apps I have a datatable like this: 

YunaEvita_0-1637844116317.png

All columns (no Title) is choice column

I need to count how many "No" each column have

 

I hope it's possible to do it !

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

You can use the Countif() function to count rows in a data table that match a particular condition.  Count, CountA, CountIf, and CountRows functions in Power Apps - Power Apps | Microsoft Docs



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365 and Pwr EduCon in Chicago
EduCon Chicago 2022

View solution in original post

2 REPLIES 2
Pstork1
Dual Super User
Dual Super User

You can use the Countif() function to count rows in a data table that match a particular condition.  Count, CountA, CountIf, and CountRows functions in Power Apps - Power Apps | Microsoft Docs



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365 and Pwr EduCon in Chicago
EduCon Chicago 2022

Yuna-Evita
Helper I
Helper I

Thank you for you answer,

 

But now, how can I display these countIf, because I have around 80 columns in my datable so I have scrollbar (horizontal) so I just can´t put 80 labels for each count

What should I use ?

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (2,450)