Is it possible to use GROUP BY in expand query list records action

[selam]

Hello All,

I am trying to get list of records associated to parent entity in dynamics 365 using a flow and i needed to group the related records GROUPED BY certain fields of the related entity, is there any way to do that? 

[abm]

Hi @selam 

Looks like you can. Please see this post about how to generate the FetchXML for related entity group by. Once you have the fetch you can run the query via CDS connector.

https://crmchartguy.com/2013/05/27/groupby-on-a-related-entitys-related-entity/

Thanks

[selam]

@abm  thank you for your response, that would have really worked for me except i have more than 10 entities to link to so if i used fetch xml query it errors out that i have reached the max number of link entity, Si i have to really use flow's get record to achieve that and when getting children records i want to get distinct records or some how group them by some value, please let me know if you have any tips.  

[abm]

Hi @selam 

You could use fetchxml distinct 'true'

To run the fetchxml you need Common Data Service Default Environment. To access this connector you need to create a solution, then create flow. Search for Common Data Service. Select the second from the list. Use Get List Items and set the fetchxml query.

Thanks