Thursday 25 January 2018

BULK UPDATE DYNAMICS 365 RECORDS USING EXCEL ONLINE

MICROSOFT DYNAMICS 365 RECORDS TO BE BULK UPDATED USING EXCEL ONLINE..


Let's gets started...

If you want to bulk update of the records on the Dynamics 365 online,

Follow the steps then you are good to go..

If you are not the owner of the records, first modify them to the current user or if you know what you are going to bulk update then select all the records in the view..



click on the three ... dots you will find the export to excel click that dropdown then  click on the Open in Excel Online, then all the records selected will be shown in the excel gird view and then you start updating or  enter the new values.


Once you are happy with the changes then  click on the button Save changes to Dynamics



Then a pop will come up, where you can click on the Import link then it will take you the data import section on the dynamics 365...


Please see the below image for the successful imported data..


So you can navigate to the active account view on the dynamics 365.. and check all the changes have been reflected..

..

This method is quite useful without using any tools on the dynamics 365...

I hope this concept help some folks out there..

Dynamics 365 project work or want to implement Dynamics 365 in your organisation, any support work.
Please visit our website : www.gmritsolutions.co.uk 
or
contact us : admin@gmritsolutions.co.uk
or call us on 00447809572230.

We can help organisations within the UK and around the world:-)

No comments:

Post a Comment

Note: only a member of this blog may post a comment.