Filtering duplicate records in a list

[M-DH]

Hi,

I'm looking to create a mail activity for a set of contact records.

I start my flow from record 'a' trough a manual trigger after which I list records related to record A.

These records on their turn hold the necessary contact records I want to send a mail to.

[manuelstgomes]

Hi @M-DH 

Just for me to understand what you need, the duplicate values come from a List, and you want that list to have unique values correct? 

By list, you mean a SharePoint list or somewhere else?

The solution to de-dupe the list could be for you to do the following:

1. Define an array variable
2. Make a Loop on the duplicate list
3. Check if the item already exists in the array variable
4. If not, add it otherwise continue.

Then you would use the array variable with your unique values.

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[M-DH]

Hi @manuelstgomes ,

In this case the list is a list from Dynamics which contains a multitude of contact records which we fetch from a list of 'projects'.

The issue here is that a contact can be related to multiple projects at once, but we only want to send out one general mail to all our project contacts without one of those contacts receiving the same mail 2 - 6 times.

So I'm looking for a way to filter out the duplicate contact records in the last collection in order to get the desired result, I'm sure there is a way but my current level of knowledge doesn't allow me to.

[manuelstgomes]

Hey @M-DH 

I think the solution I provided you should work.

Do a "Get items" from dynamics to fetch the information that you want and then, for each, add them to the variable array if they don't exist there. Then you'll get the unique values to send the general email.

Makes sense? If not please let me know and I'll try to do a mockup for you.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[M-DH]

Hi @manuelstgomes,

I would love a mockup, I'm having some troubles creating the solution myself.

Thanks!

[v-bacao-msft]

Hi @M-DH ,

Your needs are similar to grouping records by on one or two fields, you can refer to this article below and see if it helps:

http://johnliu.net/blog/2018/6/do-group-by-in-flow-with-two-simple-elegant-loops

Best Regards,

[manuelstgomes · Accepted solution]

Hi @M-DH 

Here you go. It's quite simple. You'll do it in no time 🙂

Is this what you need?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[M-DH]

Hi @manuelstgomes ,

This worked out perfectly, thanks a million!

[manuelstgomes]

Hi @M-DH 

AWESOME!!!! Happy that it worked for you.

Anything else please let me know

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel