Counting Rows from a Table

0
Hi,    I have the following domain model (see picture below) and uploaded an excel sheet with many thousand records (rows). Now I want to count all these records and want this number displayed  in a separate page for example TotalUser in order to the some further calculations from there.  Does anyone can help me this? Thank you  Jan  
asked
3 answers
1

Jan,

In a microflow, you can retrieve all of the objects in User entity and count them using an Aggregate List action, example below:

Then you can store the count in another entity, return it at the end of your microflow or do other calculations in the microflow with it.

Hope that helps,

Mike

answered
0

Hi Mike, 

my Microflow looks like this. Is that right?

Also I'm having difficulties to store count in the Total User entity. The error says: 

Microflow parameter 'User' should be of type MyFirstModule.TotalUser. Hope you can help me with this.

 

Thank you 

Jan

answered
0

Thanks Mike. 

One last thing, I think I did it all how you described, but after creating the page(All_Users) and adding a menu item for that page the error below will appear. Do you know a solution for that?

Jan

answered