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 Tables (o...
Power Apps
Unanswered

Connecting 2 Tables (or more) (database Excel)

(0) ShareShare
ReportReport
Posted on by

Hi Everyone,

 

I am just starting to learn how Powerapps are working and I stuck at the point where I want to connect 2 tables.

I created 3 different Tables with names, addresses and birthdays. Every Table has a primary Key, addresses and birthdays have also a foreign key from names.

 

Now I want to create a DetailForm where you can see all data (name, address, birthday) from one Person (the one I selected on the screen before).

I tried so many functions for a field like LookUp(Tabelle2; NamesID = N_ID; City) to get the city form the person with the same ID/primary  key.

 

I hope you can help me.

If you have further questions, please ask.

 

Thank You,

Lena

Categories:
I have the same question (0)
  • v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @LS11 ,

     

    What is the issue you are facing?

    If you want to retrieve the related info of selected name, the LookUp formula you post should do the trick.

    If you want all related info shown in the DetailForm (Display Form Control), I'm afraid it's not supported. Since the Data Source of Form Control must be the real data source, Collection is not supported. I would suggest you display these related info in the label using the LookUp formula you post. Customize the layout of these labels to show as the Form.

    Hope this helps.

    Sik

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 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard