Power Platform Community Forum Thread Details

Hello,

I managed to make a virtual table in Dataverse. Fields I've got in this Person table are:

- name

- uniqueProjectId

- something else

And I want to make relationship with dataverse table - Project, where I have fields:

- project name

- person

- uniqueProjectId

Now I want to make relationship based on same uniqueProjectId (one to many). First I make new relations n:1 (on virtual entity). But when I made this - on table view I don't see any data and of course new lookup field (created on relations) is empty. How I can manage to do a properly relationship.

Final result need to be subgrid with related Persons in Project form.

Categories:

Microsoft Dataverse with Power Apps

Hi @mwojcik ,

I think what you want to do in this case is the following, please let me know if this makes sense for your business case:

1. Create an intersect table called something like "Project Team Member"

2. This table will have two lookup columns including "Project" pointing to your Dataverse table and a lookup column that is pointing to your virtual table

3. When you create these records you can set both of these values.

At this point you will have the relationship built (with Dataverse relationships because this is where the relationships must be maintained (see following from documentation https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/get-started-ve)

Screen Shot 2022-06-20 at 4.37.15 PM.png