Updating Dynamics 365 Records using Export and Import with Excel

2 Comments
BEFORE WE START, I NEED YOUR HELP.
 

I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.

IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.

THANK YOU, AND LET'S KEEP LEARNING TOGETHER.

CARL

https://www.youtube.com/carldesouza

 

Following on from a previous example, we can use Excel to update records in Dynamics 365 by exporting the records to an Excel file. To do this, select the records you would like to export in Advanced Find:

Export:

 

Open the downloaded spreadsheet and make an update to an account:

Save the Excel file. Create a new Import in Dynamics 365 under Data Management->Imports:

Select No to Allow Duplicates:

Click Submit to run the import. It will show the one updated record as successful:

Confirm in Dynamics 365 the record has been updated:

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

2 Responses to Updating Dynamics 365 Records using Export and Import with Excel

Leave a Reply

Your email address will not be published. Required fields are marked *