rappen / FetchXMLBuilder

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

Power Automate parameters missing single quotes for GUIDs #933

Closed Roland80 closed 1 year ago

Roland80 commented 1 year ago

When you convert a FetchXML to Power Automate parameters and a filter contains a lookup to a specific record, the GUID is missing single quotes. Example FetchXML:

<fetch>
  <entity name="account">
    <filter>
      <condition attribute="accountid" operator="eq" value="3fee3d59-68c9-ed11-b597-0022489b41c4" uitype="account" />
    </filter>
  </entity>
</fetch>

Example Filter parameter: (accountid eq 3fee3d59-68c9-ed11-b597-0022489b41c4)

The List rows action expects there to be single quotes around the GUID, as it's a string-type column rather than an integer.

rappen commented 1 year ago

Will look into this issue. 👍

MarkMpn commented 1 year ago

Sorry, that shouldn’t have auto-closed just yet. Fix is done in the upstream package, will get a PR shortly to include it in FXB

rappen commented 1 year ago

Fixed in submodule by @MarkMpn.