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?
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video Tutorials@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.
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsDive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
12 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
19 | |
18 | |
10 | |
10 | |
9 |