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

Entity Relationship in Model driven app

 Hi All,

 

I have the below requirement:

EntityA  (columns --> entitya_id, name1)

EntityB  (columns --> entityb_id, name2)

 

EntityC

many to one relation to EntityA and also many to one relation to EntityB

columns --> entityc_id          entitya_id          entityb_id     name3

 

EntityD -- many to one relation to EntityC

columns are --> entityd_id      entityc_id      name4

 

1) View should look like:

name1       name2       name3       name4

 

2) Main Form should like

name1   Textbox

name2   Textbox

name3   Textbox

name4   Textbox

        save button

 

My main problems are:

Active view allows to show related fields, but when the data added - data shows some guid instead of actual data?

Main form allows to add the related entity's one field only as foreign key?

 

Please suggest how can i implement this scenario. Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Entity Relationship in Model driven app

Hi @vghanithala ,

 

As far as I know, if you don't consider JavaScript development, It is only supported to show the parent fields on the child record by Quick View Forms or Calculated Fields.

 

If you want the GrandParent fields(EntityA/EntityB) showing on the GrandChild record(EntityD), I think you might need to establish a 1:n linking EntityA/EntityB to EntityD (which could be copied via mapped fields or workflow from EntityC when you create EntityD) then you can surface EntityA/EntityB fields via Quick View Forms or Calculated Fields on the form.

 

Note: the parent fields and grandparent fields are all read-only on Child/GrandChild record.

 

Reference: Presenting Parent Information on a Child Record 

 

Hope this helps.

Sik

 

 

View solution in original post

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: Entity Relationship in Model driven app

Hi @vghanithala, please refer to my other response to your other post. The guid is the foreign key and what's saved in the database, what's shown on the view and forms is the primary field of the entity. This is detailed in one of the links in my other response (https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-entity). Suggest to have a read through them, it would give you the basics.

Good luck

Highlighted
Community Support
Community Support

Re: Entity Relationship in Model driven app

Hi @vghanithala ,

 

As far as I know, if you don't consider JavaScript development, It is only supported to show the parent fields on the child record by Quick View Forms or Calculated Fields.

 

If you want the GrandParent fields(EntityA/EntityB) showing on the GrandChild record(EntityD), I think you might need to establish a 1:n linking EntityA/EntityB to EntityD (which could be copied via mapped fields or workflow from EntityC when you create EntityD) then you can surface EntityA/EntityB fields via Quick View Forms or Calculated Fields on the form.

 

Note: the parent fields and grandparent fields are all read-only on Child/GrandChild record.

 

Reference: Presenting Parent Information on a Child Record 

 

Hope this helps.

Sik

 

 

View solution in original post

Highlighted
Frequent Visitor

Re: Entity Relationship in Model driven app

Hi Sik,

 

Your approach worked. Thank you. 

I have created new fields in EntityD as Look up to EntityA and EntityB like N:1. It started showing the output in quick view form. 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (6,298)