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 / how to use many-to-man...
Power Apps
Answered

how to use many-to-many relationships

(0) ShareShare
ReportReport
Posted on by 71

Hello,

 

I have an application that uses the SharePoint lists that I want to pass into the Dataverse, but I can't seem to use the many-to-many relationships.

Relationships.PNG

 

I created 2 tables, "Type of audit" and "Criteria". Then I created a many-to-many relationship.

The "Criteria" table already contains data, in 1 single column named "Critere".
The "Audit type" table does not contain data, there is only one column named "Audit type".

 

I would like to add data in the "Audit type" table and, in the "Criteria" relation, insert several values.

When I do "Add Record", I don't know how to add the criteria.

AddRecord.PNG

Thank you.

I have the same question (0)
  • Verified answer
    halifaxious Profile Picture
    217 on at

    2 things:

    • With 1:n and n:n relationships you have to save the record before you can associate it with other records.
    • your form for creating audit records needs to have a sub-grid component that is bound to the Criteria table
  • daruom Profile Picture
    71 on at

    Hello @halifaxious 

     

    Thank you for your answer.
    I had put the sub-grid correctly, but I thought I could add the relation to the creation.

     

    Thank you.

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