web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Data Modeling Resources
Power Apps - Microsoft Dataverse
Answered

Data Modeling Resources

Like (0) ShareShare
ReportReport
Posted on 3 Mar 2023 01:45:06 by RogerCP66 105

Hello, I am trying to learn more about how to create Data Models for Apps and am really struggling with how to develop the tables for my specific apps and also the relationships between them.

 

Would anyone have any suggested courses or resources that are specific to Dataverse that helped?

Categories:
Microsoft Dataverse
Tables
I have the same question (0)
  • Verified answer
    Fubar Profile Picture
    Fubar 8,230 Super User 2025 Season 2 on 03 Mar 2023 at 03:02:10
    Re: Data Modeling Resources

    For general data modeling knowledge, search the web for "Data Modeling 3NF"  (3NF = 3rd Normal Form)

    Specifically with regards to Dataverse as far as I'm aware no real data modeling theory type resources, but understanding 3NF generally will help you - from a Dataverse perspective key things to understand:

    • Each table has a Column with the same name as the table but suffixed with "id" that holds the system generated Primary Key with is a guid (e.g. a table with a logical schema name of "new_mytable" will have its primary key in a column called "new_mytableid" and it will be auto populated with a unique guid )
    • To create a foreign key relationship you either manually  create a 1:N relationship from the UI or create a new Column that is a Lookup (the lookup is the foreign key and will automatically store the primary key from the record that the Lookup is populated with)
    • Lookups in the UI display the value in the records Primary Name column (this behavior cannot be changed) - note this is not the Primary Key and does not enforce uniqueness by default
    • You can create Alternate Keys to enforce uniqueness
    • You can create/update relationship behaviors e.g. Cascade delete), but do not have the capability to create stored procedures (but can mimic them by writing plugin code)

     

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 686 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 433 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 266 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans