web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to get counts base...

Power Apps

Unanswered

How to get counts based on the status?

(0) Share

Report

Report

Posted on by CU01080302-0

10

Hello Awesome PowerApps community!

I am new in PowerApps. I am currently facing some difficulties for generating count. Please help me to solve.

I have a collection for loaned items with 3 columns just like this.

Loan Number	Item Code	Status
Loan1	Item1	Returned	so, Loan1(Returned)
Loan2	Item2	Returned	so, Loan2(Partially Returned)
Loan2	Item3	Not Return
Loan3	Item5	Not Return	so, Loan3(Not Return)
Loan3	Item6	Not Return
Loan4	Item7	Returned	so, Loan4(Returned)

All I want is to count for return loan, not return loan and partial return loan.

For Example,

Already Returned Loan : 2
Not Return Loan : 1
Partial Return Loan : 1

Are there a wonderful soul out there, who can help me solving this?

Have a great weekend

Best regards,

MS

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

SM1998 11 on at

Like (0)

Report
Copy link

Link copied!
Hi @Mssg ,
First of all you have to update Status field in your collection for Partial Returned Loan. Else how would you distinguish between Partial Return and Already Return. Or you can add another column for this. After that you can use the below function.
1. To count Returned Loan:-
CountRows( Filter( CollectionName, Status = "Returned" ) )
2. To count Not Return Loan:-
CountRows( Filter( CollectionName, Status = "Not Return" ) )
3. To count Returned Loan:-
CountRows( Filter( CollectionName, Status = "Partial Return" ) )

------------------------------------------------------------------------------------
If this solution helped with your problem please Accept it as a Solution so that it would be easy for others to find the solution.

Best Regards,
Siddharth

Was this reply helpful? Yes No
CU01080302-0 10 on at

Like (0)

Report
Copy link

Link copied!

@SM1998 Thank you for the answer. But this is not what I wanted. Your solution will count based on the item status. I want to count based on both the loan number and status. Do you have any other solution? I really appreciate your help.

Was this reply helpful? Yes No

Join the conversation