Microsoft Flow can be used to migrate data between SharePoint online and Dynamics 365. This tutorial assumes you have an instance of Dynamics 365 (online) and an instance of SharePoint online hosted on Azure. If you do not, sign up for a free trial of Dynamics 365 for development purposes at https://trials.dynamics.com
- First create a custom list in SharePoint online.
- In the Create List form, name the new list, Contact
- Rename the Title field to Email Address. Click on the gear icon and then select List settings.
- In the Columns section click on the Title column.
- Change the Column name to Email Address.
- Add two new columns for First Name and Last Name.
- Now that the SharePoint list is setup, click on app launcher in the upper-left corner.
- In the list of Apps, click on Flow
- On the My Flows page, click on Create from blank
- Find and click on the trigger for SharePoint with the label, “When an item is created”
- In the Flow interface, click on the down arrow in the Site Address field and if your SharePoint site doesn’t appear in the list, choose Enter custom value
- Click on the down arrow in the List Name field and the Contact list should be listed.
- Click on the New step button and click on Add an action
- Use the search field to find Dynamics 365 and click on the action labeled, “Create a new record”
- Click on the down arrow on the Organization Name field, choose the Dynamics 365 organization.
- In the Entity Name field, let the list of entities load and select the Contacts entity.
- Match the entity fields with the SharePoint Contact list fields. Click on the Last Name field and then use the search to find the SharePoint Contact Last Name field.
- Repeat this for the First Name and Email fields.
- Click on the Create flow button.
- Once saved, click on My Flows at the top and confirm the Flow is enabled.
- Go back to SharePoint and add new Contact to the list.
- Once saved, the Flow may take a couple minutes to execute. Go to Dynamics 365, open the Contacts entity and confirm the new record was created.