Skip to main content
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Unanswered

Bulk import of Service Activities

(0) ShareShare
ReportReport
Posted on by

Hi!

I would like to import a number of interactions as 'Service Activities' and each upload is failing with the following error (The source data is not in the required format):

2020_2D00_06_2D00_05_5F00_13_2D00_19_2D00_47.png

The field itself is a look up field however when I use either the 'Import Template' or the view as a template, no dropdown options are exported and when the text is added, the error still occurs despite it matching the text as it is in the system. 

pastedimage1591334682839v3.png

Is it possible to bulk upload Service Activities and if so, how can I overcome this error?

Thanks in advance :)

  • Community Member Profile Picture
    on at
    RE: Bulk import of Service Activities

    Thank you Hao. I have explored what you suggested but looks like the out of the box service is not been used like your image shows. The developers have created a customised service as a new entity and activity uses that but when I input those options on the excel, I continue to experience issues.

    One to refer to developers I feel.

  • LuHao Profile Picture
    40,888 on at
    RE: Bulk import of Service Activities

    Hi Nikki,

    Please try to do so.

    Open Advanced Settings, look for Services, see its result.

    pastedimage1591350264703v1.png

    Export to static worksheet.

    pastedimage1591350300411v2.png

    In the Excel, copy the Name to the lookup field of the Excel that is to import.

    pastedimage1591350337687v3.png

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

News and Announcements

Now Available: 2025 Release Wave 2

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 51 Most Valuable Professional

#2
Ramesh Kumar Profile Picture

Ramesh Kumar 42

#3
David Shaw_UK Profile Picture

David Shaw_UK 27

Featured topics

Product updates

Dynamics 365 release plans