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 / Can't add data to prim...
Power Apps
Unanswered

Can't add data to primary column

(0) ShareShare
ReportReport
Posted on by 235

Hi _ I'm excited to build my first model-driven app, I've looked at videos explaining it, and I have a simple task to practice on. But I'm completely stumped at the second step because I can't add any data to the primary column in any of my tables. I found out by accident that I can add data to another column in the table, just not the first one. When I have added data to another column, the first column auto-populates with a 36 character alphnumeric string! What is this, and how come none of the helpful videos talk about it, (not even Shane Young's "Everything you need to build a model driven Power app" which only came out 2 weeks ago)!

Here I have created a table for Dryer, which will only have 1 column and 2 rows - Dryer 1 or Dryer 2. But I can't add any data.

GraemeNZ_0-1666221737494.png

 

So maybe I can't have a one-column table, so I created another table called Department, thinking I can have Dryer as a column to pair with department. So I created a new table called Department (plural Departments), and didn't change the default primary column name from "Name" to hopefully generate a table called Departments, with the first column called Name so that I can add another column called Department. But instead, the table is generated and the primary column is called Department and is un-editable.

GraemeNZ_1-1666221955819.png

 

To prove the point, I add another column called Dryer, and I can see I can add text for this:

GraemeNZ_2-1666222029481.png

...and when I add text you can see the autogenerated string in the primary column...

GraemeNZ_3-1666222126604.png

What is going on?

For now, it is impossible for me to create tables with meaningful names, because if I do that, then the name becomes a field that I can't use... Is this right???

 

GraemeNZ

 

I have the same question (0)
  • AhmedSalih Profile Picture
    6,678 Moderator on at

    @GraemeNZ, Tables in Dataverse have multiple system columns that will be created by default. The unique identifier which contains GUID values is one of them. The column that called Department in your example is a Unique Identifier Column. The value in this column will be generate automatically when create new rows. You can add other columns if you want and add meaningful information in them.

     

     

    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


     

     

  • Verified answer
    GraemeNZ Profile Picture
    235 on at

    Hi @AhmedSalih Thanks for your reply. I would have expected a unique identifier column, but I didn't expect the unique identifier name to be the name I specified for my table, thereby making that name unsuable.
    In between my post and your reply, I worked out that I can rename the unique identifier column to something meaningless, like UniqueID, then I can create a new column with the name that I want to use, like Department.

    I don't understand why PowerApps doesn't already do that - why would they make the default name of the uniqueID the same name as the name of the table? And why aren't any of the user guides making this clear - it seems like there has been a change lately with an unexpected consequence...

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 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard