Define Entitiy Relationships in Canvas App

(0) Share

Report

Posted on by Community Power Pla...

Hi Guys,

does anyone have some experience on the following topics?

Write the “GUID” of an m:n relationship between 2 entities with a patch function in the canvas app:
We submit a new form and want to patch the “GUID” of the last submitted form in a new record of another entity.

How can you define and write relationships (many to many) in CDS?

Access Teams (Dynamics)
How can you add or remove Users from “Access Teams” (Dynamics) via a Canvas App?

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report

Hi @Anonymous

I prefer to handle M:M relationships by creating a junction table as a separate entity. Then, I can address the one to many relationships from either side of the junction table. This approach has the advantage that I can add additional fields to the junction table. A feature that cannot be done using the "built in" relationships created by CDS. https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 has an example of the junction table in a paradigm of Students and Classes with the additional feilds that would most appropriately be found in each table.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous,
To create a many-to-many (N-N) relationship you have two options in CDS:
Out-of-the-box N-N. Here are the steps: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-edit-nn-relationships-portal
Like @Drrickryp mentioned, a custom N-N with a junction entity which could give you more flexibility.
To create/update the record and relationships, it is fully supported with the CDS Web API which is what the Connector uses. Here's more details this and suggest to have a quick read: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/create-update-entity-relationships-using-web-api

For you 2nd question, members of Access Teams are just user records. To add/remove, all you need to do is create/delete the membership record for that Access Teams. There are two API operations to achieve this:
Add: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/addusertorecordteam?view=dynamics-ce-odata-9
Remove: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/removeuserfromrecordteam?view=dynamics-ce-odata-9
Hope this helps!

Was this reply helpful? Yes No