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

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages - General Discussions / How to create Native M...
Power Pages - General Discussions
Unanswered

How to create Native Many to Many relationship forms in Power Pages

(0) ShareShare
ReportReport
Posted on by PM-08010932-0

I have created a Native 'Many to Many' relationship table between my Account and Suppliers.

 

I have a Power Pages application in which I want to add records to my Native 'Many to Many' relationship table.

 

I want to select Accounts and assign them to their respective Suppliers.

 

Please help me with this requirement.

Categories:
General
I have the same question (0)
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,990 Super User 2025 Season 2 on at
    How to create Native Many to Many relationship forms in Power Pages
     
    In Dataverse, native Many-to-Many relationships create an intermediate table (known as an association table) that links the two entities (e.g., Account and Supplier). This table is hidden by default but can be exposed for configuration.
     
    Go to Tables in the Power Platform admin center.  Locate the Many-to-Many relationship between Account and Supplier in either entity's relationships tab. The name of the table will be something like Account_Supplier (or similar). 
    Open the relationship table and enable the Enable for Everyone option under the General tab.
     
    Create Power Pages Forms for Relationship Management  In your Power Pages app designer, go to Dataverse Tables and add the relationship table (e.g., Account_Supplier) and Create a Form
     
    Add a subgrid for the relationship table (Account_Supplier) to the Account and/or Supplier forms. Ensure the subgrid allows adding and editing related records.
     

    Create Entity Permissions: Go to Security > Entity Permissions in Power Pages. Set up permissions for the relationship table: Grant Read, Create, Write, or Delete access as required. Use filters to restrict access to specific Accounts or Suppliers.

     
    thanks

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 58

#2
Fubar Profile Picture

Fubar 46 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Product updates

Microsoft Power Platform Community release plans