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

One-to-one 1:1 relationship between tables

Hi,

 

At the moment it is not possible, but it would be nice if it will be possible to create an 1:1 relationship between the tables in Dataverse. 

6 REPLIES 6
AB18
Frequent Visitor

And what is the reason why this is not possible atm?

Fubar
Solution Sage
Solution Sage

There is not a native 1:1 but you can mimic it by putting a Lookup on each entity (for the other end of the relationship) and when you populate one, you also populate the parent using workflow/plugin/flow (and you also stop the creation on another child record if the parent is already populated).

EricRegnier
Super User
Super User

Hi @AB18,

The workaround is to have two relationships, 1-N and N-1 between the two entities and have custom logic (such as classic workflows) to populate the the lookups on each entity. Feel free to vote on this feature request at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/One-to-one-1-1-relationship-type-in-Common-Data...

Cheers

poweractivate
Community Champion
Community Champion

@AB18 

 


@AB18 wrote:

And what is the reason why this is not possible atm?


This is because you can already model it by just another Column on the Table. Usually having two Tables with 1:1 is not needed in Dataverse. 

 

For now you can try the suggestion of @EricRegnier as well as that of @Fubar 

 

It also may be possible to produce this functionality right now, in pretty solid way by using a Custom C# Plugin as well, also alluded to by @Fubar - however, this is also requiring pretty much same setup as the one @EricRegnier suggested with mirroring the N:1 and 1:N with Lookup on both ends, and setting these, and then not setting it if already populated, and if it already can be done with Classic Workflows, that is much simpler to implement than C# plugin, so that is why we recommend you try that suggestion actually if it will accomplish the goal in your case.

EricRegnier
Super User
Super User

Yeah, where possible I always suggest to go out-of-the-box low/no code versus customizations like plugins...

@AB18 

Unless there is a good reason not to do it, merge the two tables into one.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,396)