Querying Common Data Service (CDS) data in Power Automate can be difficult without prior experience in OData. For citizen developers, at least, that is a fair assumption to make. The Filter Query field in Power Automate utilises an OData structure, so those who are not knowledgeable will have to learn it first.
Luckily, there is a way to get around that roadblock using the Fetch XML Builder. To explain this method, let’s use a scenario.
Let’s say your client wants to generate an automated email list of opportunities that will close in the next 90 days. Let’s also imagine that you have no previous experience in OData, and you don’t have time to go through all the documentations online.
You can skip that step with this method using two different connectors: the original CDS connector and the CDS current environment connector. Let’s begin with the original CDS connector.