web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Data calcualtion with ...

Power Apps

Answered

Data calcualtion with Sharepoint Items

(0) Share

Report

Report

Posted on by sunilkumar

62

I have created a sharepoint list with Request Status,

I would like to count the each status no of request, by using CountRows('CMM Offline Program List') formula, i am able to get total count,

as shown reaming data not showing

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @sunilkumar ,

For the others, you can use something like:
CountRows( Filter( 'CMM Offline Program List', StatusColumnName = "New" ) )

and then change the StatusColumName to match your sharepoint column and the status "New" to match the exact text you are storing in your SharePoint list for the status (might be "NEW" or "new" or "New") and then the same for the other columns like Completed.

Could you give that a try and let me know if that works for you?

Thanks,

Sancho

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @sunilkumar

What is the column type of request status?
First, filter out records of each status, then use CountRows to get row numbers.
If the Status column is Choices type, please try this:

CountRows(Filter('CMM Offline Program List', 'Status Column'.Value="New")) // take 'New' as an example

If the Status column is Text, please try this:

CountRows(Filter('CMM Offline Program List', 'Status Column'="New")) // take 'New' as an example

Hope this helps.
Sik

Was this reply helpful? Yes No

Join the conversation