Just earlier this week I had to do a double expand (getting data from a table that are two relationships away) and realized that when I did that, I didn't get any dynamic content. Bleh. Well. Not too difficult to solve with an expression, continue to read to find out how. An example scenario So... Continue Reading →
How to Avoid the “Get Record” Action to Retrieve Related Data in Power Automate
In a previous blog post I wrote about how to use FetchXML to List Records from CDS in Power Automate. But what if a column you defined in your FetchXML doesn't show up in the Dynamic content because it is a column from a related record? Defining the FetchXML Let's start with using the most... Continue Reading →
Retrieve Records in N:N relationships with FetchXML and the New CDS Connector in Microsoft Flow
Have you tried to retrieve a list of records in Flow and had to go trough a many to many relationship condition? If you have I can relate to the frustration and complication that task brought. Earlier this week I found a solution - and it was easy, really easy. Let me show you what... Continue Reading →