Count Duplicates in Array

[SylvieLet17]

This should be simple but I just can't get around it. 

I have an array that lists a bunch of users' departments. Only the department names, so it looks like:

Human Resources

Finance

Operations

Human Resources

 etc.

Naturally there are duplicates, since some users in this list are from the same department. 

I want to count the duplicates. 

Basically I want a final list like:

12 users from: Human Resources

1 user from: Operations

2 Users from: Logistics

[krootz]

@SylvieLet17 

here's a sample flow and the output:

[SylvieLet17]

Thanks @krootz, I replicated your flow, but it seems to be timing out on the Each Dept action, with only 20 items in the array to loop through.  

[Paulie78 · Accepted solution]

@SylvieLet17 try this flow, very simple. Produces this output, but can easily be adjusted to be formed however you like:

[
  {
    "Department": "HR",
    "Count": 12
  },
  {
    "Department": "Ops",
    "Count": 1
  },
  {
    "Department": "Logistics",
    "Count": 2
  }
]

Fewer steps so less complicated https://ibb.co/54KZH4R (Easier to view on link):

Code for the append to results for you to copy and paste is:

{  
  "Department": @{item()},
  "Count":@{length(body('Filter_array'))}
}

See how you get on.

Please...

If I answered your question Accept it as a solution ✔️ 

If I helped you out, please give me some Kudos 👍

Thanks 😙

[krootz]

@SylvieLet17 hmmm it only takes 10 secs for me to run it. 😅

[krootz]

@Paulie78 I like this, it's simpler! 🙂

[Paulie78]

@krootz thank you. You have been making some really neat solutions. Have learned quite a bit from your posts.