End goal: Get a list of unique users to send an email to.
I have a flow that runs the last day of every month and creates a bunch of records in CDS. Each user might have several records, where they are the owner.
I'm trying to come up with a way to get a list of unique users, so that every user will only get one email - and not an email for every record created.
If I use a List records action and then get records action for each user, the I'll end up with duplicates:
I've been playing around with Arrays and the Union function but I haven't found a way to get it to work.
Any input is appreciated 😊
Solved! Go to Solution.
Hi @NielsL
You could try constructing a fetchxml (Main entity as Users) with inner join (with other entity) using
<fetch mapping='logical' distinct='true'>
To execute the FetchXML you need to use CDS current environment connector. In order to get this connector you need to create a solution first and then create a flow from the solution.
See this post might help
https://www.itaintboring.com/dynamics-crm/two-most-ignored-features-of-fetchxml/
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @NielsL
You could try constructing a fetchxml (Main entity as Users) with inner join (with other entity) using
<fetch mapping='logical' distinct='true'>
To execute the FetchXML you need to use CDS current environment connector. In order to get this connector you need to create a solution first and then create a flow from the solution.
See this post might help
https://www.itaintboring.com/dynamics-crm/two-most-ignored-features-of-fetchxml/
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog@abmthanks for the help.
I was actually trying not to create the flow in my solution, as the ALM-story for flows really sucks at the moment (e.g. you need to manually re-active connections when you move from one environment to another).
However, everything is just so much easier with FetchXML compared to OData filter query.
Cheers
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
71 | |
27 | |
21 | |
15 | |
14 |
User | Count |
---|---|
141 | |
43 | |
42 | |
34 | |
30 |