47I am new to power automate and I have a requirement to push data from an external on-premise SQL server to a D365 Finance and Operations cloud database. Additionally, I also have the vice-versa requirement to push data from D365 FO to the on-premise SQL server.
I have done some research and I believe this bi-directional data integration will be achievable through setting up a data gateway on the external Server, creating D365 data entities, getting an unattended RPA license, and then setting up flows on power automate desktop on the on-premise server.
I also need these flows to trigger upon insert/update of certain fields/tables on both sides (on-premise, and D365).
From what I have found online this integration seems possible, but I wanted to ask this forum here if anyone has any tips or resources for this requirement.
Thanks in advance!
