web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Countif formula in Pow...

Power Apps

Unanswered

Countif formula in Powerapp using Dataverse tables

(0) Share

Report

Report

Posted on by SS76

32

Hi

Please can someone help me.

I created an app and i am trying to add a small dashboard

I have a dropdown column with the options: Complete. Not Started, In Progress

I have created Labels and under the TEXT i want to add a formula to count the number Complete

Another label for number Not Started

Another label for In Progress

I have tried everything and nothing seems to work.

My app using data from Table in Dataverse that I created.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!
@SS76

Please try as below:

CountIf('Sample Tables','Status (tg_status)'=Status.'In Progress')

Sample Table is my table name

Status(tg_status) my dropdown

Was this reply helpful? Yes No
SS76 32 on at

Like (0)

Report
Copy link

Link copied!

Thank you for responding.

Its not working 😞

CountIf(Blue, Status = Status."Complete")

This what i entered

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@SS76

Is it giving any error message ?

Can you share screenshots so we can help you further?

Was this reply helpful? Yes No
SS76 32 on at

Like (0)

Report
Copy link

Link copied!

It states: There is a error in this formula

It is nit recognizing the =

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@SS76

Is blue your dataverse table it is somehow about the names of your column but the formula is correct , may be you need to check the column names or your table name.

Was this reply helpful? Yes No
SS76 32 on at

Like (0)

Report
Copy link

Link copied!

Thank you

Was this reply helpful? Yes No

Join the conversation