Introduction
FetchXML is a powerful XML-based query language used in Microsoft Dynamics 365 and Dataverse that allows for retrieving complex data sets. This capability is particularly useful in Power Automate, enabling users to create more dynamic and data-driven flows. In this article, we'll explore how to utilize FetchXML to sort and retrieve data from both a primary table and related tables.