Announcements
Hello,
How to ensure uniqueness of primary column, and it should be not be empty?
Thanks
Although the default data type for the Primary Name column is Single Line Text and this cannot be changed on the initial set up of the Table, after you save the table, you can edit the Primary Name column and change it to an Auto-Number column. This will ensure the column remains unique, and not empty.
You can also look into setting up Duplicate Detection Rules and Alternate Keys, but I found the above to be the simplest solution.
https://learn.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.If you like my response, please give it a Thumbs Up.
Unique value: create an Alternate Key (still allows nulls) and set it to the Primary Column name https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-alternate-keys-portal#create-an-alternate-key
The Not null part: at the basic level make it business required (its default, but can be changed), to stop workarounds like importing it you can create a server side Business Rule or realtime Workflow to check if it does not contain data and error the rule or stop the workflow as cancelled.
If you just need a value to be populated you could set it to autonumber, but note this does not guarantee uniqueness, as the autonumber can be 're-seeded' to a lower number than the last used, and the field can be edited or imported into with a duplicate (Alternate Keys is the only way to guarantee unique values).
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
