cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SylvieLet17
Responsive Resident
Responsive Resident

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
Paulie78
Super User
Super User

@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
krootz
Solution Supplier
Solution Supplier

@SylvieLet17 

here's a sample flow and the output:

flow1.pngflow2.pngflow3.pngoutput.png

SylvieLet17
Responsive Resident
Responsive Resident

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
Super User
Super User

@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 😙

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

krootz
Solution Supplier
Solution Supplier

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

Paulie78
Super User
Super User

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

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,626)