Get the count of all rows in SP List with filters.

(0) Share

Report

Posted on by xvzms

103

Hi!
I've an Edit Form in my apps, connected to Sharepoint List.

Is it possible to display the number of all items from the list with Status is In Progress?
I would like this number to be displayed on my screen in the application. For ex. in the TextInput Control.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hi @xvzms ,
you can use something like:
Set(countStatus,countRow(filter('datasource,Status="inProgress")))

Was this reply helpful? Yes No
WarrenBelz 155,660 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @xvzms ,

If you want to have some Delegation control on this, try (assuming Status is a Single Line of Text)

With( { _Data: Filter( GalleryList, Status = "InProgress" ) }, CountRows(_Data) )

If it is a Choice field, you will need Status.Value

Was this reply helpful? Yes No