web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Hit column limit on Case (incident) table - looking for long-term design options

(0) ShareShare
ReportReport
Posted on by 8

Hi everyone,

Not too long ago we received an error saying we’d reached the maximum column limit on the Case (incident) table. We already have a large number of custom columns, Business Process Flows (BPFs), and forms.
We can delete some columns and possibly consolidate a few BPFs, but we don’t see that as a long-term solution. The incident table is very dynamic in our operations, and we’ll continue to need new fields and processes.

What’s the best approach to handle this? We’re considering creating a new custom table related to the incident table, moving some existing case types and their processes there (important: we can't lose any historical data), and then creating all new columns and processes on the new table. Practically speaking, is this possible? How much effort would it take, and what level of technical competence is required? If there’s an easier or more sustainable approach, we’re open to suggestions.

Thanks!

Categories:
I have the same question (0)
  • Suggested answer
    PerezAguiar Profile Picture
    Microsoft Employee on at
    Hit column limit on Case (incident) table - looking for long-term design options
    Hey!

    The same way that INcident Table also has IncidentClosure for example, perhaps this might be the best approach:  Additional tables with relationship
     
    Regards,

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 74 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 62 Most Valuable Professional

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 57

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans