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 / multiple Many-to-many ...
Power Apps
Answered

multiple Many-to-many relationships and data loading weirdness / bug

(0) ShareShare
ReportReport
Posted on by 113 Most Valuable Professional

Hi team,

One of my PCF controls (for Model Driven app) displays many-to-many relationship available records as checkbox (or toggle).

 

One user reported issue with data loading when having two many-to-many relationships between the same records.

 

I reproduced the error. To do so:

  • Added two subgrids for each relationship on the form
  • Configured them to use my PCF control
  • Publish form
  • Load the form for a record

What we can see is that all linked records for both relationships are ticked in the PCF for the first relationship. The second PCF see no ticked checkboxes (see attached picture)

 

It seems to me that the PCF control receives data from all many-to-many relationships in the first control, then nothing is send to the second control.

 

The fact that the name of the relationship is not passed to PCF makes me think the records are retrieved based on all relationships

 

Any thoughts? @HemantG ?

 

Thanks

2019-11-21_08-34-30.png
I have the same question (0)
  • Verified answer
    Tanguy TOUZARD Profile Picture
    113 Most Valuable Professional on at

    I was completly wrong, sorry for that.

     

    So it turns out that as multiple instance of the same PCF control reside in the same form, controls must have unique ids. My control was inserting same id multiple time which explains the whole behavior.

     

    Lesson learnt : Be sure to always have unique id, meaning add in the id the name of the attribute or dataset you are playing with so that the id is always unique.

  • Hemant Gaur Profile Picture
    Microsoft Employee on at

    Thanks for figuring this out and sharing the solution @TanguyT . I also ran into this once and one of my demo was magical :).

    Usually Math.random(); does the trick if there is not a need of something as rigorous as Guid.  

     

    I will send  a note to doc team to add this to the best practices for upcoming doc updates. 

     

    Hemant 

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard