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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / what column type to re...
Power Apps
Unanswered

what column type to reference unique IDs?

(0) ShareShare
ReportReport
Posted on by Andreas_S1 7

Hello, 

surely a beginner's question, but I cannot find an answer anywhere. 

I want to make a table column (in table A) that references another table's (B which is a standard table) unique id.  This can be seen as a 1:1 relationship. 

There is no column type for Unique IDs selectable. What has to be used? Text ??

Or has it to be done via 1:N relations? 

thanks

Andreas

Categories:
Microsoft Dataverse with Power Apps
I have the same question (0)
  • Fubar Profile Picture
    Fubar 8,463 Super User 2026 Season 1 on at

    There is no 1:1 relationship in DataVerse.  1:N relationships are defined by creating a field that is a Lookup (selecting the Parent entity as its type) on the Child entity (behind the scenes DataVerse use the Parent records internal GUID to set the foreign key - the Lookup - on the child).

     

    You can mimic a 1:1 by doing a 1:N (lookup on Child) and then another N:1 (on the Parent), then when Child is created also populate the Lookup on the Parent (usually via Workflow or a Plugin), you can also enforce the 1:1 e.g. Workflow or Plugin that fails the create of a Child if the Parent's lookup already contains data (there is also more that can be done - but this is probably enough to get started).

  • Ram Prakash Duraisamy Profile Picture
    Ram Prakash Duraisamy 5,660 Super User 2026 Season 1 on at

    Hi @Andreas_S1 

     

    There is no standard behavior called 1:1.

     

    If you are referencing with lookup then it is called 1:N Relationship that will be mapped with GUID values

     

    Please mark as Answer if it is helpful and provide Kudos

    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

    Blog : https://microsoftcrmtechie.blogspot.com

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

News and Announcements

Welcome to the Power Platform Communities

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!

Congratulations to the January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans