Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Using CRM On-premise w...
Microsoft Dynamics CRM (Archived)

Using CRM On-premise with Logic Apps

(1) ShareShare
ReportReport
Posted on by awalters 3,079

I'm playing around with Logic Apps, and since it has connectors for a number of services we use, I'm interested in how we can integrate it with CRM - but as we're on-prem, nothing is ever as straightforward as it seems.

There's a Dynamics 365 Connector, and since our server is IFD enabled, I was hoping I'd be able to give it the URL.  However, there's no way to put in a URL - it just goes to Online.

So I tried adding in a Custom Connector, but it wants a Swagger file or Postman collection.  Does anyone know if this exists for CRM or if there's any way to generate it somehow?

Is there any other way of getting this working that I've missed, short of directly connecting to the SQL database?  *shudder*  I was at a Dynamics conference yesterday, and was told by one of the presenters that I should be able to use Flow/Powerapps/etc with on-prem as long as it was IFD enabled, but I'm really missing how to make that work.

*This post is locked for comments

  • sy-huss Profile Picture
    sy-huss 35 on at
    RE: Using CRM On-premise with Logic Apps

    I managed to do it by following this: eax360.com/.../

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Using CRM On-premise with Logic Apps

    I'm also looking for the similar kind of issue... My Dynamic 365 was hosted in virtual Machine which is in azure(nothing but on premise) .

    Now i want access the Dynamics 365 webapi using logic app from azure.. by creating a new  Webapi.. Can you any one suggest me how to achieve my requirement..

  • awalters Profile Picture
    awalters 3,079 on at
    RE: Using CRM On-premise with Logic Apps

    Yeah - I was never able to parse that and figure out anything to try.  Got busy with other things.  If anyone has an example, that'd be awesome.

  • StefanS365 Profile Picture
    StefanS365 3,573 Most Valuable Professional on at
    RE: Using CRM On-premise with Logic Apps

    Hi JP,

    Could you please describe/show an example of how you configured the connection and the action Invoke an HTTP Request ?

    Thanks.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Using CRM On-premise with Logic Apps

    Hi Allison,

    You can set up a Flow with the "HTTP with Azure AD - Invoke an HTTP Request" connector over the Data Gateway. Just check the Gateway box in the connector during setup. Make sure you test any firewall access between your on-prem servers as applicable. Test each component separately. Finally, if your connection is mis-configured, you can edit as necessary in PowerApps "Connections".

  • Verified answer
    awalters Profile Picture
    awalters 3,079 on at
    RE: Using CRM On-premise with Logic Apps

    Just found out that this is on the ideas site as a suggestion, and currently is in the Planned status.  So hopefully soon!

    Link for anyone who would like to vote/follow:

    powerusers.microsoft.com/.../18733

  • awalters Profile Picture
    awalters 3,079 on at
    RE: Using CRM On-premise with Logic Apps

    "I'm guessing that you can connect with onpremises if you are able to authenticate with oauth to your CRM api's"

    We can.  But I see no option in the connectors to give our internal URL to in order to even attempt this; that's the issue.  The gateway option connects directly to SQL, AFAIK, and so would only be supported for read-only (which isn't what we're looking for).

  • JohnAnonymous Profile Picture
    JohnAnonymous 5,241 on at
    RE: Using CRM On-premise with Logic Apps

    I'm guessing that you can connect with onpremises if you are able to authenticate with oauth to your CRM api's. Afaik this is support with the latest version of Windows Server and ADFS.

    There are options to connection your logic apps with you onprem envrionment using Gateways (and I think VPN's), but the OOTB connecter requires oauth authentication no matter if you are using a gateway or not.

  • awalters Profile Picture
    awalters 3,079 on at
    RE: Using CRM On-premise with Logic Apps

    So interestingly, I just found this page of features for online vs on-prem, and it says this:

    Dynamics 365 Connector Updates for Power App and Flow

    Both

    (from: https://technet.microsoft.com/library/mt812192.aspx )

    So this certainly implies there should be a connector...still haven't found an option for it, though.  I've looked through Dynamics 365 itself, in case the entry point is there rather than through PowerApps, but can't find anything on that end either (we are on 8.2, so if it was introduced in 365 like the page says, we should be good to go).

  • awalters Profile Picture
    awalters 3,079 on at
    RE: Using CRM On-premise with Logic Apps

    Theoretically we should be able to do it via the web API, but I need a definition file.  I could just give the base API URL and write all my own definitions that just call Web API URLs, it looks like, but that seems really unnecessary.  All of the definitions clearly exist somewhere, since they're (at least, most of them if not all?) the same for Online.  Just wish I knew how to find them...:-(

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans