Update field in Contacts from XLS

(0) Share

Report

Posted on by DawnK

I need to update one field in the Contact entity. The data is in an XLS with contact's name, email and account name. The data is a subset (6000 records) of our total Contacts (500,000).

In the past I had to export the Contacts from D365, merge that xls with my subset xls then run a Flow to update the Contact using the "Do Not Modify" GUID field as the identifier.

Is there an easier way of doing this without using the GUID field? I would rather use the email and not have to export, merge, etc.

Thanks!

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

If f you are on CRM Online then you have another tool which is Data Integration project to load/update contact field from xls file. You can use query to update record based on some unique field instead of using guid.

please have a look at below article.

carldesouza.com/.../

Please Mark My Answer Verified If I Were Helpful

Was this reply helpful? Yes No
DawnK 90 on at

Like (0)

Report
Copy link

Link copied!

THANK YOU SO MUCH! This works great and so much easier than using the GUID!!!

Was this reply helpful? Yes No
DawnK 90 on at

Like (0)

Report
Copy link

Link copied!

This creates a new record if one does not exist for the records in the xls. Is there a way to not create a new record? Thanks!

Was this reply helpful? Yes No