Announcements
i have created records in SharePoint list with status column, i connected list to PowerApps. based on login user it should count rows/ status column= "completed" to show result as percentage. how to do in PowerApps
@venky232 ,
Note this is not Delegable
CountRows( Filter( SPListName, Status = "Completed" ) ) / CountRows(SPListName) * 100
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
not working showing delagation lines , iwant to count based on login user records .CountRows(Filter(SPListName,Status.Value = "Completed"&& Person.Email=Lower(User().Email))) /CountRows(Filter(SPListName,Person.Email=Lower(User().Email)) * 100
As I said CountRows is not Delegable - I see you added a bit to my code before accepting your own post . . .
its working if i use collection to store SP list
That was not something you posted - I can only respond to the question asked and it appears it answered the core of your issue.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 541
WarrenBelz 434 Most Valuable Professional
Valantis 289
