Share
Report
359Hi,
I have a Ms flow, In which I am using an aggregate fetch but It's giving the error
"The provided query options are not valid: System.ArgumentException: 'select' and 'expand' cannot be both null or empty. at System.Web.OData.Query.SelectExpandQueryOption..ctor(String select, String expand, ODataQueryContext context, ODataQueryOptionParser queryOptionParser)at Microsoft.Crm.Extensibility.OData.EdmUtilities.PopulateSelectExpandClauseForQueryOptions(String selectClause, CustomQueryOptions queryOptions, String expandClause)"
As, I have checked the same fetch through 'FetchXMLTester', there it's giving the right result without any error.
fetch:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" aggregate="true">
<entity name="acl_eventparticipant">
<filter type="and">
<condition attribute="acl_eventlookupid" operator="eq" value="@{triggerBody()?['id']}" />
<condition attribute="acl_invitestatus" operator="eq" value="123456" />
</filter>
<link-entity name="contact" from="contactid" to="acl_contact" visible="false" link-type="outer" alias="contact" >
<attribute name="acl_company1" alias="Organization" groupby="true" />
</link-entity>
</entity>
</fetch>
All responses (
Answers (
