Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Showing related Many to Many entity as datasource in PowerApps

Posted on by

I have an Entity Teacher which has many to many relationship with another Entity called Student.

I am embedding the app in the Model Driven of Entity Teacher. In the embedded app, I want to display list of students from the recordid of Teacher.


I created a gallery where list of students are shown and set the Item in gallery as 

ModelDrivenFormIntegration.Item.Students

which I think should have work but is not showing anything.

 

I tried to LookUp Teacher with the record Id from item and tried this as well

LookUp('Teachers', new_teacherid = ModelDrivenFormIntegration.Item.teacherid).Students

I even tried using guid

LookUp('Teachers', new_teacherid = GUID("ffdea424-e5a2-e911-a96a-000d3a4e75ec")).Students

It gives on loading forever.

 

FYI: The student entity has around 150 fields.

Categories:
  • Verified answer
    summitb Profile Picture
    summitb on at
    Re: Showing related Many to Many entity as datasource in PowerApps

    Started working so no more an issue.

    ModelDrivenFormIntegration.Item.Students
  • Re: Showing related Many to Many entity as datasource in PowerApps

    Hi @summitb how are you progressing with this? Was the above reply helpful?

     

    @Anonymous 

  • v-monli-msft Profile Picture
    v-monli-msft on at
    Re: Showing related Many to Many entity as datasource in PowerApps

    Hi @summitb ,

     

    Check if below blog could help:

    https://baizini-it.com/blog/index.php/2017/10/10/powerapps-101-many-to-many-relationships-between-tables/

     

    Regards,

    Mona

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard