web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Canvas app Many to man...
Power Apps
Unanswered

Canvas app Many to many Combo box -relate dataverse record

(0) ShareShare
ReportReport
Posted on by 120

Hi,

 

We have a custom entity called Category which has a M-M relationship with Contact in dataverse. A contact can have many categories applied and vice versa. We have got under 10 categories.

 

We want to set the categories on contact form. Therefore added a custom data card and a combo box in it. Now Combo box has got category as data source. We are able to select multiple categories however not able to save those against contact.  I wonder upon  select of a category from combo box we could use "Relate" function to associate the category with the contact?  and similarly  upon removal we could somehow obtain the removed value therefore unrelate that in dataverse?

UmerJaved_0-1654545344989.png

 

Thanks

 

 

 

I have the same question (0)
  • AhmedSalih Profile Picture
    6,680 Moderator on at

    @UmerJaved , I would also think of using relate and unrelate. Here are some examples https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-relate-unrelate

     

    One more thing to have in mind that app users should have append and append to securiy roles on the related tables. Here is some explanation https://stackoverflow.com/questions/56636838/for-dynamics-crm-365-security-roles-what-does-append-and-append-to-mean#:~:text=Append%20and%20Append%20To%20basically,the%20lookups%20on%20this%20entity.

  • UmerJaved Profile Picture
    120 on at

    Thanks @AhmedSalih . I had already used relate to achieve the functionality however unrelate seems tricky given upon save how will the logic work out what is removed from the list?

  • jets Profile Picture
    24 on at

    Any news on the functionality of the logic when removing items? I am thinking of a "unrelate all" and then a "relate selected" but have no idea on how to implement it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard