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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / what column type to re...
Power Apps - Microsoft Dataverse
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
I have the same question (0)
  • Fubar Profile Picture
    Fubar 8,319 Super User 2025 Season 2 on at
    Re: what column type to reference unique IDs?

    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 Profile Picture
    Ram Prakash 5,576 Super User 2025 Season 2 on at
    Re: what column type to reference unique IDs?

    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
Forum hierarchy changes happening today, December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans