Short form: how do I create a relationship between two virtual entities with custom data providers that I authored so I can use them in subgrids related to each other?
Goal:
I want to create a subgrid view on a contact form that displays a list from VE1 (call it personal accounts). When clicking on a personal account, I want to view the activity (VE2) related to the selected personal account on a subgrid found on the personal account form.
Where am I:
- I have two data sources, each with their own providers for one virtual entity.
- I have the relationship defined between contacts and personal accounts
- I have the contact form modified to show the personal accounts in a subgrid using the RetrieveMultiple handler for this entity. This works beautifully.
- When clicking on the personal account, the form will load with details loaded.
What's Not Working:
- I cannot create a relationship between VE1 and VE2. I either get one of two errors:
- "Message: Relationship between entities [VE1]and [VE2] is not allowed as they have different data sources" when setting up the 1:N or N:1 relationship in the classic editor
- Unless I am mistaken, I cannot create a data source with multiple data providers. I don't understand this error message.
- In the Power App solution editor, I get "The entity could not be updated: For Relationships referencing Virtual Entites, Cascade link type must be No Cascade"
- With this attempt, I have tried to set the advanced options for this relationship to Custom, and set Restrict for delete and No Cascade for all others. When I reopen the relationship, it resets this to Referential behavior and Restrict for delete.
To me, I feel like I need this relationship to be present so that the subgrid can show associated records using the IDs from the virtual entities. Without this, the context doesn't have any concept of what record it is supposed to be associated with. How do I create a relationship between the two virtual entities so that the subgrid data shows correctly?
Thanks in advance!
