Mass Updating Records in Dynamics 365 Made Easy

June 27, 2019 Jeff Katz

Have you ever had the need to mass update records in Dynamics 365, only to find it way too cumbersome and time-consuming? In this article, I will walk you through how to make updating records in D365 fast and easy.

You’ll learn how to open entity data in Microsoft Excel, update records and publish the updated data back into D365 using the Excel add-in. For my example, I will update records using the vendor master list page.

 

Ready to update your records?

Let’s start out in the All Vendors list page in Accounts Payable.

Note: If you want to export only a subset of data, you can filter your data before exporting it.

 

Screenshot of Dynamics 365 All Vendors

 

To export your data to Excel, do the following:

 

  1. Click on the Excel icon and under Open in Excel, select Vendors V2.
    1. Don’t select Export to Excel, this will not create the data connection that allows you to publish your updated records.
  2. Click Download to export the records; you have the option to open the file or save to your local PC.
  3. Once the file is open in Excel, you will want to “Enable Editing.”

Screenshot of Dynamics 365 Editing in Excel            

 

Once the Excel file is open, we can update the records to then be published back into D365. In my example screenshot, I have updated the phone numbers for the 5 records.

Screenshot of Excel updates for Dynamics 365

 

Once the data is updated in Excel, you are ready to publish back into D365. Click on Publish in the data connector task pane within the Excel file.

Screenshot of publish button in Excel for Dynamics 365

 

Let’s now go back into the All Vendors list page and click refresh. You will notice the 5 phone numbers have now been updated.

Screenshot of updated Excel spreadsheet on Dynamics 365

 

 

Need help with Dynamics 365?

Western Computer experts are standing by to answer your questions or help you work through many common challenges like this. Be sure to bookmark our online resource library for more help with Dynamics 365 or for more information on this topic, read this Microsoft article.

About the Author

Jeff Katz

Jeff is a Senior Solution Architect with experience in all aspects of implementing ERP. He has an excellent record on projects, successfully analyzing, designing, and implementing software solutions to drive the customers’ business needs. In his role as a Solution Architect, Jeff analyses customers’ requirements, designs solutions, and leads implementations.

Previous Article
Microsoft Adds Feature Management to Dynamics 365FO
Microsoft Adds Feature Management to Dynamics 365FO

Feature management in Dynamics 365 for Finance & Operations is a new enhancement. Contact us about the new ...

Next Video
Unlock the Power of Cortana Intelligence in Demand Planning in Dynamics 365 Finance and Operations
Unlock the Power of Cortana Intelligence in Demand Planning in Dynamics 365 Finance and Operations

Learn how to use the power of Cortana intelligence for demand planning in Dynamics 365 Finance & Operations...