web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issue with Accessing C...
Power Apps
Unanswered

Issue with Accessing CRM Data in Flow

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello - I am attempting to leverage a basic flow to trigger an email when a CRM Opportunity changes and moves to a particular stage in the sales process. 

 

I am hitting an error on the first step of the flow and unable to determine how to get past it. I have worked with one of our CRM admin to review setting and we are not able to determine if there is a flag that would need to be set at either the top level or at my User level in order to get this to operate as expected.

 

Any help would be very much appreciated... thank you!

 

Inputs & Outputs noted below (my Orgnaizaiton is obfuscated for obvius reasons ).

 

Inputs

Organization Name

<Our Organization Name>

 

Entity Name

Opportunities

 

Skip Count

0

Maximum Get Count

1

 

Filter Query

(empty)

 

Order by

(empty)

 

 

 

Outputs

Headers

{

  "Pragma": "no-cache",

  "x-ms-request-id": "eeacf735-cfa9-4db5-a1a9-33d565aee5ec",

  "Cache-Control": "no-cache",

  "Date": "Thu, 01 Sep 2016 15:51:04 GMT",

  "Set-Cookie": "ARRAffinity=bb0e64ea2955fbd6ee91664b2d1ba68ea9af2a1c1f19538edff75059230300d5;Path=/;Domain=dynamicscrmonlineconnectionprovider-centralus.tip0.p.azurewebsites.net",

  "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0",

  "X-AspNet-Version": "4.0.30319",

  "X-Powered-By": "ASP.NET",

  "Content-Length": "4128",

  "Content-Type": "application/json; charset=utf-8",

  "Expires": "-1"

}

 

 

Body

{

  "status": 400,

  "message": "{\r\n  \"code\": \"\",\r\n  \"message\": \"The query parameter %24skip is not supported\",\r\n  \"innererror\": {\r\n    \"message\": \"The query parameter %24skip is not supported\",\r\n    \"type\": \"Microsoft.Crm.CrmHttpException\",\r\n    \"stacktrace\": \"   at Microsoft.Crm.Extensibility.OData.QueryOptionsConverter.GetQueryExpression(ODataQueryOptions queryOptions, String edmEntityName, CrmODataExecutionContext context)\\r\\n   at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.RetrieveEdmEntityCollection(CrmODataExecutionContext context, String entityCollectionName, ODataQueryOptions queryOptions)\\r\\n   at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySet(String entitySetName)\\r\\n   at lambda_method(Closure , Object , Object[] )\\r\\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\\r\\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\\r\\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at Microsoft.Crm.Extensibility.OData.CrmETagMessageHandler.<SendAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at Microsoft.Crm.Extensibility.OData.CrmDelegatingHandler.<SendAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at System.Web.Http.HttpServer.<SendAsync>d__0.MoveNext()\"\r\n  }\r\n}",

  "source": "<Our Organization Name>.api.crm.dynamics.com",

  "errors": []

}

Categories:
I have the same question (0)
  • merwan Profile Picture
    Microsoft Employee on at

    @Anonymous - could you please send us the Flow ID? e.g. https://flow.microsoft.com/manage/flows/71e11820-9a3a-4787-b4ac-ed4370761520. Adding @Lalit to investigate further. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

     

    Thank yo ufor the response... here is the ID as described in the request.

     

    https://flow.microsoft.com/manage/flows/0ae6ec0d-a0a4-46e3-a45a-96e12211545d

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Any update on this?

  • merwan Profile Picture
    Microsoft Employee on at

    Apologies for the delay in response. We will have someone investigate this issue and get back to you soon. @RajRa 

  • RajRa Profile Picture
    Microsoft Employee on at

    Hi JJudas


    Sorry for the issues you've been having. The CRM connector has a bug with skip counts as the message suggests. Please recreate the flow, but don't fill the skip count for the card  - that should workaround the issue - Hopefully that is a good workaround for you - we will be removing the skip counts in upcoming releases.

     

    thanks

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks...I noted that when I created the new flow, althought I was connected to my company's CRM, the name of the company did not show up as an option in the drop down list. 

     

    When I scanned earlier versions of the flow, I noted the company name was a random string so I attempted to create the new flow with that string. I noted in the body of the error message that the random string does apparently aim at my company ( which I've modified below to "<companyName>".

    No Luck - still failing... please review and advise as soon as possible please because if I am unable to get Flow working as needed, I have to move to a different solution approach to the problem I'm attempting to address.

     

    new flow ID : 1b04070f-e55c-4048-a5f6-3c505999e670

     

    new flow error message : 

     

    Headers

    { "Pragma": "no-cache", "x-ms-request-id": "4a354dce-bed9-48bc-8d9f-3b814856740c", "Cache-Control": "no-cache", "Date": "Mon, 10 Oct 2016 13:28:05 GMT", "Set-Cookie": "ARRAffinity=f127150a104ea2db4d4f2285d4980c06ec0c4e0885b9c2dc5251f754dfe2979c;Path=/;Domain=127.0.0.1", "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Length": "4136", "Content-Type": "application/json; charset=utf-8", "Expires": "-1" }

     

    • Body
      { "status": 400, "message": "{\r\n \"code\": \"\",\r\n \"message\": \"The query parameter $deltatoken is not supported\",\r\n \"innererror\": {\r\n \"message\": \"The query parameter $deltatoken is not supported\",\r\n \"type\": \"Microsoft.Crm.CrmHttpException\",\r\n \"stacktrace\": \" at Microsoft.Crm.Extensibility.OData.QueryOptionsConverter.GetQueryExpression(ODataQueryOptions queryOptions, String edmEntityName, CrmODataExecutionContext context)\\r\\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.RetrieveEdmEntityCollection(CrmODataExecutionContext context, String entityCollectionName, ODataQueryOptions queryOptions)\\r\\n at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySet(String entitySetName)\\r\\n at lambda_method(Closure , Object , Object[] )\\r\\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\\r\\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\\r\\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n at Microsoft.Crm.Extensibility.OData.CrmETagMessageHandler.<SendAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n at Microsoft.Crm.Extensibility.OData.CrmDelegatingHandler.<SendAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\\r\\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n at System.Web.Http.HttpServer.<SendAsync>d__0.MoveNext()\"\r\n }\r\n}", "source": "<companyName>.api.crm.dynamics.com", "errors": [] }
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 413

#2
WarrenBelz Profile Picture

WarrenBelz 355 Most Valuable Professional

#3
timl Profile Picture

timl 315 Super User 2026 Season 1

Last 30 days Overall leaderboard