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?
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.
@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.
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.
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021