Answered

how to countrows

(0) Share

Report

Posted on by venky232

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No
Verified answer

venky232 on at

Like (0)

Report

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

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@venky232 ,

As I said CountRows is not Delegable - I see you added a bit to my code before accepting your own post . . .

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

its working if i use collection to store SP list

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

@venky232 ,

That was not something you posted - I can only respond to the question asked and it appears it answered the core of your issue.

Was this reply helpful? Yes No