You’re offline. This is a read only version of the page.
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
@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.
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:-
Share
Report
All responses (
Answers (
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
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
