Skip to main content

Notifications

Announcements

No record found.

Power Platform integration forum

Use Power Automate to integrate data between Dynamics 365 F&O and On-premise SQL server

Posted on by 47

I'm new to Power Automate and I need to establish a bi-directional data flow between an on-premise SQL server and a D365 Finance and Operations cloud database. This involves pushing data from the SQL server to D365 FO and vice versa.

After some research, it seems achievable by setting up a data gateway on the external server (or establishing a direct connection), creating D365 data entities, obtaining an unattended RPA license, and configuring flows using Power Automate Desktop on the on-premise server.

I also require these flows to trigger upon insertion or update of specific fields/tables on both the on-premise and D365 sides. While I've found some online resources indicating the feasibility of this integration, I'd appreciate any additional tips or recommended resources from this forum. Thanks!

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans