Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
we want to remove email address data from 1200+ contacts.
We have a CSV file with only email addresses in it and all those are invalid.
What my I found out on my research for the problem is to go over Advanced search and export the contacts, manipulate them in Excel and re-import them after all.
But in the Advanced Search process I have only the option to say that the field contains data or the field contains excactly data which I enter.
Is there any option to find the contacts with the associated email address from my CSV file?
And If I have the contacts, is the Export -> Update in Excel -> Re-Import the correct way to update those contacts?
It would suggest that you use Kingswaysoft's Free SSIS toolkit community edition for this purposes if you have 10's of thousands of contact records to avoid exporting them all then re importing. You will be able to use the email address as a lookup key and then update the email address to be blank where it matches.
If you wanted a no-code solution - you could perform an import of another entity (such a task) and use the email address as a lookup to the contact name - you could then export to excel only those records that have this special task created through the import, remove the emails and then re-import.
Hope this helps,
thank you for your answer. Unfortunately, a code solution won't be work here because it will cost too much time and work.
The amount of contacts which have to be changed are 1500. The complete list of contacts with email addresses in CRM are 10.000 which I have exported to a Excel sheet.
Can I export the list with first, last name and email address, filter the addresses in excel and remove the email value and re-import them in CRM. Is this possible?
Is there a possibility to create a custom entity? I have a bad feeling using the task entity for that job.
Yes - you could certainly simple export to excel, remove the email addresses and then re-import. Any unchanged rows will not be updated.
I was assuming that you had 100's of 1000's of contacts for the importing entity technique - but yes you could create a custom entity for the purposes.
Hope this helps
I created a new entity and imported the email addresses from the CSV file. Now I'm stucked at the process to match the contacts with my new entity. Is it necessary to create a 1:n relationship from my new entity to contact and match those email fields or can I create this "lookup" in Advanced Find with no further adjustment?
After three evenings I found a solution based on your lookup suggestion.
I first created like you said a new entity. I gave that entity a "lookup" field and matched it with the contact entity. After I imported my CSV files with 2 columns containing both the email address. I matched the email address to the primary field of my new entity and the second column with the email field of contact entity. After the import I have all addresses matched with the contact.
After this step I created a new workflow process. In this workflow process I said if the primary field matches with the contact email field (actually this isn't necessary because else there would be no matching at the import), then it removes the email value in the contact entity.
Then I just selected all the items in my new entity view and started my workflow process. Finally, the email address from the lookup contact is removed!
Thank you very much for your help. It was very interesting and Dynamics CRM is really awesome.
Business Applications communities