Power Platform Community Forum Thread Details

Looking for suggestions on how to best build out the following:

Sharepoint List >>> has hundreds of work orders at any period of time. Each work order is assigned to a Person (Person column). Work orders are then set with a Status of: Submitted/Active/Complete

I want to be able to have some way to list the TOTAL number of active work orders for each person in a list/table/chart -- so as new ones come in, a manager can ensure equal distribution of work orders right at their fingertips quickly.

How would one best set this up? As new employees come and go, it needs to be able to adapt accordingly so it cant just be endless galleries filtered by employee as if someone left it would require manual updates.

Is a gallery the best way to do this? If so, how would it work "conceptually"? Filter only active requests? then how would I list by employee so it aggregates and doesnt list every single workorder they have and somehow/somewhere calculate the total number?

Ideas? thank you!

Categories:

Building Power Apps

Hi backinbusiness

The number of records with those Status values (I have assumed both that this is a Choice column and the field names) assigned to each person would be something like

With(
   {
      _Data:
      Filter(
         SPListName,
         Status.Value = "Submitted" ||
         Status.Value = "Active" || 
         Status.Value = "Complete"
      )
   },
   AddColumns(
      GroupBy(
         AddColumns(
            _Data,
            Assigned,
            Person.DisplayName
         ),
         Assigned,
         Grouped
      ),
      Allocated,
      CountRows(Grouped)
   )
)

The structure at the top is to give you some degree of Delegation capability as GroupBy is a "local" operation and the number of records it can address (the output of the top filter) is limited to your Data Row Limit.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee