Skip to main content

Notifications

Customer Service forum

Excel Online Update Issue

Posted on by 545

Hi All, 

      i am trying to update the ticketnumber in case entity through excel online, the import showing success, but the ticketnumber is not getting updated, also there is no plugin or workflow on case entity. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Excel Online Update Issue

    Hi,

    It is true, and as I know, ID field in Case entity is automatically generated. This cannot be modified.

    If you think the kind of Case ID is not suitable for you, you could follow the article below to customize it.

    community.dynamics.com/.../custom-auto-number-for-cases

    Hope it helps.

    BR,

    Judy

    -------------------------

    Appreciate to Mark it as Answer if it helps.

  • ganesh198715 Profile Picture
    ganesh198715 545 on at
    RE: Excel Online Update Issue

    The excel online works for all the fields but case number, if you try it for case number its not working

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Excel Online Update Issue

    Hi,

    I followed the steps below to save my changes in CRM directly from excel online, and it succeeded.

    1. Go to My Case view.

    2. From the ribbon, select Export –> Open in Excel Online.

    3.png

    3. The data will open in excel online. Make necessary changes to the data. Here for an example, I am updating the “Origin” values for the Case.

    4. After making all the changes, the interesting part is we can save the changes back in CRM. We have a button at the top ‘Save changes to CRM”

    3.png

    4. Once clicked, in the background CRM creates a data import job. It might take some time before the data is refreshed in CRM. So I come back in the CRM grid, click "Refresh", and find my data has been refreshed.

    4.PNG

    Note: Please keep in mind, after you do this, you need to refresh your web page.

    Hope it helps.

    BR,

    Judy

    -------------------------

    Appreciate to Mark it as Answer if 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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans