You’re offline. This is a read only version of the page.
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
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
Share
Report
All responses (
Answers (
541
