Unanswered

Relationship between two CDS entities

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have a question about the relationships between entities in CDS. I have 2 existing entities which I want to connect through a relationship.

Entity1(Population): has 10000 records
Entity2(Contact): has 5 records

In Entity2 I created a many-to-one relationship(not sure which one to create as both entities has single entry for particular user). With this relationship a new "lookup" field gets added automatically to Entity2 which is called Entity1ID. At this time this field/column has no values in it. I want to populate the EntityID column (LookUp column) in your Entity2 with values (Primary Name) from your Entity1 based on the particular contact within CDS.

How can I achieve that?

Referred this link already but not able to what I want.

Any help is appreciated !

Categories:

Power Apps portals

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous :
Do you want to establish a mapping between records between two interrelated entities?
Firstly,let me explain why you can not patch the Primary Name to Entity1ID.
Because the lookup column only stores the ID of the corresponding record in the associated entity.
Secondly, there are many ways to establish a mapping between records between two interrelated entities:
I will introduce you to the two most common methods:
Method1:Using Relate function.(Canvas App)
I think this link will help you a lot:
Relate and Unrelate functions in Power Apps
Method2:Using Edit record function.(Model-Driven App)
Step1:Data-Entities-your main entity-data-Edit record
1.jpg
Step2:Related-related entity
2.jpg
Step3:Add New XX or Add Existing XX
*Contact is my related entity
3.jpg
Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response!
First of all, what is mean by interrelated entities?
Is there any method for PowerApps portal?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous :
Does the PowerApps portal you mentioned refer to the portal app?
First,interrelated entities means entities that have established relationship.
Secondly,If you need to add an associated record in the portal app, maybe you should modify the entity's from.
Best Regards,
Bof

Was this reply helpful? Yes No