Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Bulk update records

Posted on by 95

Hello,

I have found out how to bulk import contacts and also how to bulk delete contacts in Dynamics Marketing CDS. But I'm still strugling how to bulk update contacts...

Case : I have imported 5000 contacts. I now have a separate excel list with 400 of these contacts for which I would like to put the field 'donotemail' to TRUE.

Through Powerapps it seems that I only can import records and not update them. From the marketing program I can use Excel online to manually editing records. Also from the marketing program I can export data in Excel but I don't know how to re-import it after I changed it....

So I think I'm missing something here....

Thanks for any help.

Peter

  • Zheng Lai Profile Picture
    Zheng Lai 5 on at
    RE: Bulk update records

    Excellent video, thanks for sharing it!

  • Samuel Boulanger Profile Picture
    Samuel Boulanger 570 on at
    RE: Bulk update records

    You're welcome ;)

    I just released a video on my youtube channel showing the differents method to import data in D365. Feel free to take a look !

    www.youtube.com/watch

  • Suggested answer
    TWS - PVB Profile Picture
    TWS - PVB 95 on at
    RE: Bulk update records

    Hi Samual,

    Thanks for your reply. I really did't see that...shame on me !!

    Peter

  • Verified answer
    Samuel Boulanger Profile Picture
    Samuel Boulanger 570 on at
    RE: Bulk update records

    Hi Peter,

    Actually if you click on the Import from excel button (Not the down arrow), you will be able to import from an excel file directly.

  • TWS - PVB Profile Picture
    TWS - PVB 95 on at
    RE: Bulk update records

    Hi Samuel,

    Thanks for your response. The problem is : I can export in XLS format but I only can import in CSV. I would expect that I could export xls, change info and then import it back....

    pastedimage1589311749465v1.png

    pastedimage1589311774213v2.png

  • Suggested answer
    Samuel Boulanger Profile Picture
    Samuel Boulanger 570 on at
    RE: Bulk update records

    Hi Peter,

    The only way of updating records in CDS is by exporting the contacts, make the modifications to the exported excel file then re-import them. CDS use the GUID which is in a hidden column to determine which contact to update. You'll have to:

    1. Create a personal view with the columns you which to update
    2. Export it
    3. Update the records without deleting columns or renaming headers
    4. Re-import it

    You would probably have to use VLOOKUP to do a reconciliation between both of your excel files.

    Hope it helps.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans