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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / When should an attribu...
Power Apps
Answered

When should an attribute become a separate table?

(0) ShareShare
ReportReport
Posted on by 55

Apologies, I know this is basic database structures but I'm struggling with a few scenarios. I'm building out a case management solution for IT faults and there are several situations where I don't know whether or not an attribute should be it's own table.

For example 'incident status', this would be a small list of case states (New, In Progress, On Hold, Pending closure, Closed), I can't at this time think of any attribute beyond 'name' and would normally just have this as an attribute of the 'incident' table, but in my current commercial application this is a separate table... am I missing something?
Sample Dataverse Schema.PNG

I have the same question (0)
  • Verified answer
    EricRegnier Profile Picture
    8,720 Most Valuable Professional on at

    Hi @johnbradbury,

    In general for future proofing especially if this is more of a large solution that is subject to have lots of enhancements, make is a separate table. See tip #9 and #10 at: https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Top-15-best-practices-when-configuring-Power-Platform-and/ba-p/850804

    Hope this 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard