cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Count Duplicates in Array

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@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):

CountDuplicates.png

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 😙

View solution in original post

6 REPLIES 6
Solution Supplier
Solution Supplier

@SylvieLet17 

here's a sample flow and the output:

flow1.pngflow2.pngflow3.pngoutput.png

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.  

Super User III
Super User III

@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):

CountDuplicates.png

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 😙

View solution in original post

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

Solution Supplier
Solution Supplier

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

Super User III
Super User III

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

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (11,456)