question

KranthiYadav-3443 avatar image
0 Votes"
KranthiYadav-3443 asked 71524405 answered

Convert Fetchxml to OData Query for Power automate(Flows) in D365

Hi folks,

I am not able to convert the fetch xml to odata query in mscrm flows.Please find below fetchxml condition and provide me odata query.

fetchXML :
<filter type="and">
<condition attribute="statuscode" operator="eq" value="180520000" />
<condition attribute="createdon" operator="last-x-days" value="5" />
<condition attribute="createdon" operator="olderthan-x-days" value="1" />
<filter type="or">
<condition attribute="qa_errorlog" operator="like" value="%Contact doesnot exist in D365 CRM%" />
<condition attribute="qa_errorlog" operator="like" value="%contacts donot Exist in D365%" />
<condition attribute="qa_errorlog" operator="like" value="%ContactDoesNotExist%" />
</filter>
</filter>

Regards

not-supported
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@KranthiYadav-3443
Dynamic 365 is temporarily out of the scope of Microsoft Q&A support. For currently supported products, please refer to: Microsoft Q&A supported products.
For questions about Dynamic, please go to the Microsoft Dynamics 365 Community Forums.

0 Votes 0 ·

1 Answer

71524405 avatar image
0 Votes"
71524405 answered

Hi i that you solved this this issue but if not yet you can try this method
1-download xrmToolbox
2-install FetchXML Builder tool
3- save your fetchxml in .XML file
4- open your detchXML file in fechxml Builder tool
5- now click the view tab and choose the data view

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.