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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Help with Canvas App a...
Power Apps
Unanswered

Help with Canvas App and Junction Table and CDS

(0) ShareShare
ReportReport
Posted on by

Good morning. I have two tables that I'm trying to create a N:N relationship using a junction table. I've chosen this route because I need to add additional meta data on the relationship. Table 1 is the User table, Table 2 is the Team table. The additional meta data is team role. The junction table name is Team_Members.

I have a 1:N relationship setup between Employee and Team_Members
I have a 1:N relationship setup between Team and Team_Members
I have a 1:N relationship setup between Team_Role and Team_Members

In the app, I have a gallery configured to display a list of all employees that are in the Employee table. I have an icon that when clicked opens an edit form with the Team_Members table as the source. I'm trying to get the Employee drop down to populate with the name of the employee from the gallery. Then the user would select the team and role for the user and save it. 

Is this possible? Thanks in advance. 

I have Select(Parent) setup on the button. I thought that I could limit the item list using that but that's where I am stuck. 

I have the same question (0)
  • Bipin D365 Profile Picture
    971 on at

    Hi @sbarbarino ,

     

    On Select of Icon in Employee Gallery write below code to set the global variable

    Set(selectedAccount,BrowseGallery1.Selected);

    bipinshan_0-1639826954488.png

     

    Now on Team member Employee Dropdown DefaultSelectedItems property set the above variable 

    bipinshan_1-1639826990668.png

     

     

    Please mark my answer verified if this is helpful!

    Regards,

    Bipin Kumar

    Follow my Blog: https://xrmdynamicscrm.wordpress.com/

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard