search

rappen / FetchXMLBuilder

FetchXML Builder for XrmToolBox and Microsoft Dynamics 365 / CRM
https://fetchxmlbuilder.com/
GNU General Public License v3.0
133 stars 55 forks source link

Cannot find metadata for relation #1013

Open lambeaulady opened 5 months ago

lambeaulady commented 5 months ago

When I attempt to Convert to Power Automate Parameters, I get this message: Cannot find metadata for relation task.ownerid =>team.teamid

It otherwise works to generate the results/FetchXML. I really like this tool but the whole reason I was using it was to generate the ExpandQuery code.

image

MarkMpn commented 3 months ago

The conversion to Web API & Power Automate parameters relies on using the defined relationships - you can't join on arbitrary attributes in the same way you can in Fetch XML. In this case the relationship is defined as being task.owningteam >- team.teamid, so if you use Fetch XML like:

<fetch>
  <entity name="task">
    <link-entity name="team" from="teamid" to="owningteam">
      <attribute name="name" />
    </link-entity>
  </entity>
</fetch>

this will convert to Web API & Power Automate parameters:

image