Power Platform Community Forum Thread Details

Auto connect records between tables

Hello! So I have a problem that I'm trying to figure out and it feels like it should be easily possible, but its doesn't seem so and I'm not sure if I'm just missing something.

So I have 2 tables. One is a table that's in a 1 to 1 relationship with the "Contacts" table, and ill call the table "Parent". The other being a many to one relationship with Parent, and ill call this table "Child".

The set up for the pages would be a main page with the record associated with the currently logged in contact in Parent displayed. On this page there would be the list of the associated records in Child. There is then a button on the page that would take you to a form to create a new record in Child and have it automatically associated with the Parent record.

That is the ideal behavior. So far I have the main page with the Parent record, but I'm unable to make any kind of visibility/permissions condition to have a list that only displays items with relationships to the current Parent record. I'm able to mimic this by just having them related to the "Contact" table, and this is OK but again, not ideal. The main thing I cant figure out is how to make it so that when the user creates a record in Child, it automatically creates a useable relationship to either the Parent record, or even the current users Contact if possible. I think I could do some shenanigans with power automate to connect them but id prefer to check this way to see if there's some default way to connect them, since I feel like relying on the current logged in user will cause more problems down the road.

Thanks!

Categories:

General

On your dataverse Parent form add a Subgrid for its Child records. Then in the definition of the Power Pages form add a metadata record to the Basic Form / Step of Type = Subgrid, select the subgrid in question and then set the forms to be used for Create and Edit.

https://learn.microsoft.com/en-us/power-pages/configure/configure-basic-form-metadata#basic-form-metadata-type--subgrid

https://learn.microsoft.com/en-us/power-pages/configure/configure-basic-form-subgrid

The Power Pages form that you use to create the child record, also has additional settings that can set an associated table reference (depending on how you set things up you may not need to do this)

https://learn.microsoft.com/en-us/power-pages/configure/basic-forms#associated-table-reference

You will also need appropriate Table Permissions to be created and added to the respective Web Roles being used (e.g. the create button for the subgrid will not be visible if the user doesn't have create permissions for the child record).

Quick Links

Leaderboard > Power Pages - General Discussions