Inkey Solution Logo
Case Studies Banner

Power Automate

Synchronize SharePoint files with the Dynamics 365

The Client

Our US based client, an advitising agancy had to manually create a lead in Dynamics 365 when a potential client showed interest in their services when their agents added that potential client's details in a SharePoint list. This was because their agents worked on contract and were not given access to the system.

The Challange

The challenge presented was to automate the creation of Lead entity records in Dynamics 365 whenever a new record was added to the SharePoint list. Additionally, the images attached to the SharePoint records needed to be seamlessly integrated into the related Notes section of the corresponding lead in Dynamics 365

The Solution

To address the client's requirements, we devised a comprehensive solution utilizing Microsoft Flow. Upon the creation of a new record in the designated SharePoint location, the Microsoft Flow was triggered. Subsequently, this flow facilitated the automatic creation of a new Lead record in Dynamics 365, along with the associated Notes.
The Microsoft Flow implementation involved various actions and expressions to ensure the successful transfer of images from SharePoint to Dynamics 365 Notes as attachments, conforming to the required format.

Other Features

In addition to the core functionalities, the solution offered a noteworthy feature:

  • Enhanced Synchronization: The synchronization between SharePoint and Dynamics 365 was enhanced, leading to improved accuracy and reduced delays in data synchronization.

The Result

The implementation of this solution significantly improved the client's workflow efficiency and data accuracy. By automating the lead creation process and synchronizing SharePoint files with Dynamics 365 seamlessly, the client experienced heightened productivity and reduced operational overhead. The client expressed high satisfaction with the automation process and the synchronous behavior between SharePoint and Dynamics 365, affirming the solution's effectiveness in meeting their business needs

Would you like to digitize your business and put it on the cloud?
Do you need clear, concise reports for your organization?