cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sparkymark75
Frequent Visitor

Connect to Dynamics CRM 2011

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.

9 REPLIES 9
renatoromao
Super User
Super User

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/


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

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

 

@sparkymark75 ,

 

How many minutes are running?

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/limits-and-config#request-limits


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

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

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


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

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

@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. 🙂

 


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

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!

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).


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,333)