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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How to create Native M...
Power Pages
Suggested Answer

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 topics
I have the same question (0)
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,990 Super User 2025 Season 1 on at
     
    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

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 January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Suriyanarayanan V Profile Picture

Suriyanarayanan V 45

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 14 Most Valuable Professional

#3
DP_Prabh Profile Picture

DP_Prabh 13

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans