cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
todaytoo
Frequent Visitor

Dataverse Primary Name Column

Hello! I keep seeing conflicting details around the 'Primary Name Column' in dataverse when creating a table. What should be populated in this column or is it even needed? Some documentation I see says that it should have your Primary Key in this column, others say to leave this column alone.

 

Can someone help to explain what this column is and how it should be used, or point me to clear documentation around this topic?

 

Thanks!!

1 ACCEPTED SOLUTION

Accepted Solutions
AhmedSalih
Super User
Super User

Hello, @todaytoo, Primary Name column is always created by Microsoft Dataverse when you create a new custom table. This is the first column that is listed and available so you have a way to identify a record in the new custom table by using a business value or an autogenerated whole number. In the model-driven apps, the value in the Primary Name Column will be clickable so you can navigate to the Form of that record. So, it needs to be user friendly value, like company name, or Order number. 

 

Also, when you have relationship between tables through lookup column, the Primary Name column value will show as the value of the Lookup column in the Child tables. 

 

It is needed and as a best practice you should use it and you can't avoid using it.

 

 

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


Visit my Blog: www.powerplatformplace.com


 

 

 

 

 

View solution in original post

1 REPLY 1
AhmedSalih
Super User
Super User

Hello, @todaytoo, Primary Name column is always created by Microsoft Dataverse when you create a new custom table. This is the first column that is listed and available so you have a way to identify a record in the new custom table by using a business value or an autogenerated whole number. In the model-driven apps, the value in the Primary Name Column will be clickable so you can navigate to the Form of that record. So, it needs to be user friendly value, like company name, or Order number. 

 

Also, when you have relationship between tables through lookup column, the Primary Name column value will show as the value of the Lookup column in the Child tables. 

 

It is needed and as a best practice you should use it and you can't avoid using it.

 

 

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


Visit my Blog: www.powerplatformplace.com


 

 

 

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,241)