Here's how you can use work with using Aggregation in a Fetch XML inside a Flow for CDS (Current Environment) connector.
Blog Link: https://d365demystified.com/2021/03/29/fetchxml-aggregation-in-a-flow-using-cds-current-environment-connector-power-automate/
Fetch XML Aggregation: https://docs.microsoft.com/en-gb/powerapps/developer/data-platform/use-fetchxml-aggregation?WT.mc_id=DX-MVP-5003911
Follow my Blog: https://d365demystified.com/
Follow me on Twitter: https://twitter.com/priyesh_wngman7
#PowerAutomate #msDyn365 #MSFTAdvocate #PowerPlatform #MSFTDynamics365 #PowerApps #PowerAddicts #LowCodeNoCode #ProjectOperations #MVPBuzz #Microsoft #MicrosoftAzure #MicrosoftDynamicsCRM #MSDynamicsCRM