Skip to main content

Notifications

Community site session details

Community site session details

Session Id : +90bykF1u5dlUryJ+0FwdS
Power Apps - Building Power Apps
Unanswered

Connect to Dynamics CRM 2011

Like (1) ShareShare
ReportReport
Posted on 20 Feb 2020 15:12:30 by 30

We have an On Premise install of Dynamics CRM 2011 as we haven't gotten around to migrating to Dynamics 365 yet. How can I connect a Power App to the CRM 2011 web services?

 

We have a data gateway configured that we've successfully used for PowerBI and we have our on premise AD synchronized with Azure AD.

Categories:
  • CU22081450-0 Profile Picture
    Most Valuable Professional on 21 Feb 2020 at 15:45:51
    Re: Connect to Dynamics CRM 2011

    Nice!

    If you click on the "Show advanced options" and Authentication with type "Active Directory OAuth" (Client ID or Client Secret) or "Basic" (user and password).

  • sparkymark75 Profile Picture
    30 on 21 Feb 2020 at 15:42:48
    Re: Connect to Dynamics CRM 2011

    Thanks. Getting somewhere now. It's still failing but with an authorization error because the CRM web service will be expecting AD authentication (which is why I was using the HTTP with Azure AD action). I now need to figure out how to get past this!

  • CU22081450-0 Profile Picture
    Most Valuable Professional on 21 Feb 2020 at 15:29:40
    Re: Connect to Dynamics CRM 2011

    @sparkymark75 ,

     

    Insert an action before the Http request called "Compose", insert the url on there and in the URI (Http action), insert the Output the Compose method.

    The errors are common when we are configuring the difficult process. 🙂

     

  • sparkymark75 Profile Picture
    30 on 21 Feb 2020 at 15:01:35
    Re: Connect to Dynamics CRM 2011

    It's not even reaching the Response action yet so I'm not worried about that until I can get it to actually connect to the CRM web service and retrieve data.

     

    They claim these tools are easy to use, but that's only the case when you're using the latest Microsoft products!

     

    I've changed it to an HTTP action but now can't get the URI to be accepted!

     

    2020-02-21_15-00-36.png

  • CU22081450-0 Profile Picture
    Most Valuable Professional on 21 Feb 2020 at 14:36:17
    Re: Connect to Dynamics CRM 2011

    The last action you use the "Response" instead of "Respond to a PowerApp"

     

    respond-app.png

     

    Why you are using the Invoke Http request action?

    If is it possible to change, modify to "Http" action.

     

    http-action.png

  • sparkymark75 Profile Picture
    30 on 21 Feb 2020 at 14:27:28
    Re: Connect to Dynamics CRM 2011

    I cancel it after its been running for around 5 or 6 minutes. If I take the URL and paste it into a browser window, it returns results within 2 or 3 seconds.

    If I look at the error attached to the button I'm using to run the Flow from Power Apps it shows the following....

    2020-02-21_14-25-58.png

  • CU22081450-0 Profile Picture
    Most Valuable Professional on 21 Feb 2020 at 13:36:30
  • sparkymark75 Profile Picture
    30 on 21 Feb 2020 at 13:27:20
    Re: Connect to Dynamics CRM 2011

    Ok, I've created a flow which calls the CRM web service and parses the returned json. However when I run it, it just sits and runs for minutes and I eventually have to cancel it. If I check the Flow, the "Invoke an HTTP request" has a Bad Gateway message but keeps running.

    2020-02-21_13-24-52.png

     

  • CU22081450-0 Profile Picture
    Most Valuable Professional on 20 Feb 2020 at 15:25:31
    Re: Connect to Dynamics CRM 2011

    Hi @sparkymark75 ,

     

    When your app loads or click on the button, use the Power Automate to search all items on the Dynamics CRM 2011.

    And in your Power Automate, you connect with the Data gateway and respond to Power Apps.

    In the Power Apps, you read the result and set it in a new collection.

     

    Items property --> Set(Results, 'MyFlow.Run()')

     

    ---
    If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

    Thanks!
    Renato RomĂŁo
    https://www.linkedin.com/in/renatoromao/

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard