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 / Connecting 2 Lists in ...
Power Apps
Unanswered

Connecting 2 Lists in a Power App

(0) ShareShare
ReportReport
Posted on by 170

This is an app within Teams.  I have 2 Sharepoint Lists.  One with Employees, one with certification details.  The primary key is the Employee ID associated with the employee.  I have 2 forms on the same page, in separate container.  I have The gallery as the Employee List.  I would like the 2nd form boxd to populate based on the employee ID. (picture shows employee but I'm going to switch it to the ID instead of the name to ensure a unique ID, but it's the same concept).  I'm really not sure how to go about this.  Would it be a lookup? 

MaryT0905_0-1666020170523.png

 

Categories:
  • WiZey Profile Picture
    3,023 Moderator on at

    Hello @MaryT0905 ,

     

    If your "Employee" and "Certification" tables have a one-to-one relation, then a single "LookUp()" should do the trick.

     

    LookUp(Certification, EmployeeID = Gallery.selected.ID)

     

    By putting this code in the "Item" property, it will populate the form with the item's values. You'll perhaps also need to use "EditForm()" to activate the form before use.

     

    Hope this was helpful to you.

  • MaryT0905 Profile Picture
    170 on at

    They are Sharepoint lists, not necessarily a table.  Does that make a difference? I'm not sure how to make sure I have a relationship setup between the 2.  I feel like I'm missing something really obvious here. lol 

  • MaryT0905 Profile Picture
    170 on at

    Could you explain the EditForm part please? 

  • WiZey Profile Picture
    3,023 Moderator on at

    Does that make a difference? No, not at all. I usually refer to any external datasource as "tables" and local collections as "collections" just to avoid any confusion for myself. 

    But you can still work on a collection the same way you work on a SharePoint list.

     

    "EditForm()" simply turns your form into "edit mode" to modify an existing record. I believe it also populates the datacards with the item you provided in "Item" property. 

     

    Also, because you're using SharePoint list there is no direct way to create a relation between two tables. The only solution is to add a column in the 2nd table to store the key of the 1st table, then use "LookUp()" as I mentioned earlier.

     

    If you're still stuck on the relation, could you please describe your two tables so I can better understand how you made them related?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 221 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 188 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 120

Last 30 days Overall leaderboard