Skip to main content

Notifications

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

Bulk update records

(0) ShareShare
ReportReport
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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans