'Flow: Dynamics 365 and Azure SQL Server

I have a database in Azure and I would like to bring over all the data from there into Dynamics 365. I have listed the following scenarios. I want to know if these scenarios are possible using Flow.

  • Initial import of all data from Azure to Dynamics 365 (is this possible using Flow?)

  • When a new record is created in Azure, Flow should be able to update it in Dynamics 365. Is this possible?

  • When a existing record is updated in Azure, Flow should be able to update it in Dynamics 365. Is this possible?

  • When an existing record is deleted in Azure, Flow should be able to delete it in Dynamics 365. Is this possible?

Thank you so much!



Solution 1:[1]

Yes I think all of these are possible.

Flow has connectors for SQL and Dynamics 365. You can also create custom connectors if those don't do what you need.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 James Wood