Count Duplicates in Array

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Sort by

krootz 458 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous
here's a sample flow and the output:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Paulie78 8,424 Moderator on at

Like (5)

Report
Copy link

Link copied!
@Anonymous 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 😙

Was this reply helpful? Yes No
krootz 458 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
krootz 458 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Paulie78 8,424 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
grootgrootgroot 2 on at

Like (0)

Report
Copy link

Link copied!

When you are incrementing the variable under Apply to each, what is the value that you are using?
The if(...)?

Was this reply helpful? Yes No
Swap2909 10 on at

Like (0)

Report
Copy link

Link copied!

Hey

Thanks for your inputs. I tried using your solution here. It is counting but out it repeated. I have a list currently which has 24 entries - 14 of 1 type and 10 of others. I used the above flow to count these from a list - the output is coming as array of 24 items - 14 times for 1 type and 10 times for other - and does show the count. So it looks something like this

Type 1 10
Type 1 10
Type 2 14
Type 1 10
Type 1 10
Type 1 10
Type 1 10
Type 2 14
Type 2 14
Type 2 14

and so on.
How to do i correct to show like below
Type 1 : 14
Type 2 : 10
And maybe in future i will have a type 3 and so on

Was this reply helpful? Yes No
Swap2909 10 on at

Like (0)

Report
Copy link

Link copied!

Hey

Thanks for your inputs. I tried using your solution here. It is counting but out it repeated. I have a list currently which has 24 entries - 14 of 1 type and 10 of others. I used the above flow to count these from a list - the output is coming as array of 24 items - 14 times for 1 type and 10 times for other - and does show the count. So it looks something like this

Type 1 10
Type 1 10
Type 2 14
Type 1 10
Type 1 10
Type 1 10
Type 1 10
Type 2 14
Type 2 14
Type 2 14

and so on.
How to do i correct to show like below
Type 1 : 14
Type 2 : 10
And maybe in future i will have a type 3 and so on

Was this reply helpful? Yes No
Chriddle 8,686 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

xpath() can count more efficiently within only one Select 😉

https://powerusers.microsoft.com/t5/General-Power-Automate/Check-if-a-category-has-two-or-more-items-in-a-SharePoint-list/m-p/2692054/highlight/true#M164477

Was this reply helpful? Yes No