Using Fetch Xml query in Power Automate Flow.
Hello Guys, In our previous blog we have seen how to use expand query in Power Automate Flow. Today we are going to see how to use fetch xml query using MS Flow. Do follow us to know more about Dynamics and Power Platform. Also if you like our blog then please comment and share this blog with your friends. There are some scenarios where we need to perform Joins which we were doing in SQL for joining multiple table to retrieve data from various tables. Here in D365 we are having the concept of lookup field which is nothing but the separate entity. This entity is also having some additional columns. As we have Contact table which is having Company(Account), Country(Country) lookup. These lookups are also a separate table. Also Country table is having Region lookup. Consider a scenario where we are retrieving contact list and we also want some additional fields from these various tables then we need to use fetch xml query in Power Automate Flow. Let's see how to retrieve and access