Count number of rows in Entity with filter (VB Expressions)

[stch (Steffen Christensen)]

Hi,

How do I count the number of rows in a Data Service entity and apply filters to the count as well?

The equivalent to Count(Filter()) function in Legacy apps.

I have a App variable created on the entity.

Thanks

/stch

[mkankatala (Mahesh Kankatala)]

Hi @stch

Check the below thread for the information,

How to use 'Count' function with Data service entities?

Hi Team, I have a ‘Status’ field in the Data Service entity. The field contains any of two values: “Assigned” or “Unassigned”. While integrating the entity with UiPath apps, there is a requirement to count the records separately based on the value in the ‘Status’ field. I have given the count expression as below: [image] But the output is the total count of the entire records. Can anyone help me with the correct expression for the Count function? Thank you in advance, Alwin.

Hope it helps!!

[stch (Steffen Christensen)]

I know how it works in Legacy Apps. What I am looking for is how I do it in VB Expressions

Thanks anyway

[ppr (Peter Preuss)]

At least fetching the filtered Entities to a second variable and using afterwards the Count() should work

[Arvind_Kumar1 (Arvind Kumar)]

@mkankatala ,

Please create a App variable of type List source and into list source variable please update the records based on your filter and once that is done you can call the app variable for count as below.

Appvariable.TotalRecords

[stch (Steffen Christensen)]

I went with this solution. Thanks