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

Announcements

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard