Get list of unique users from list records in CDS

[NielsL]

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 😊

[abm · Accepted 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

[NielsL]

@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