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.
Solved! Go to 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
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:
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
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.
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
Hi @manuelstgomes,
I would love a mockup, I'm having some troubles creating the solution myself.
Thanks!
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,
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
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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
90 | |
50 | |
36 | |
30 | |
27 |
User | Count |
---|---|
75 | |
60 | |
50 | |
43 | |
38 |