cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Labraham36
Helper I
Helper I

Problems linking tables

Hello community! My name is Leandro, from Argentina! I apologize for my bad English, but I have a question about Power Apps and I would need your help:
I am creating a Tickets Apps, the same account of two tables: the "Requirements" table that contains the fields "Id_requerido", 
"creation date" and "status", on the other hand the "Comments" table that contains the fields " Id "," Id_requerido "
(where it should be related to the other table) and the" comment "field. The issue is that I have created a screen where it shows me
the data of the "Requirements" table, and I need that when I go to the "View comments" part, I link to the "Comments" table and show me
the comment of that Requirement . I can't manage to link those two tables !! I am using an online excel in OneDrive. Could someone help me?
Thank you very much!

 

3 REPLIES 3
Drrickryp
Super User II
Super User II

Hi @Labraham36 

Check out Shane Young's short video about Excel as a datasource.  https://www.youtube.com/watch?v=RtmZM3tm2Zs .  It probably isn't the best one to use for a production app that will have large numbers of records.

Labraham36
Helper I
Helper I

Thanks for your reply! The application will work in a SQL database, but I need to see how to link those tables in excel to present the prototype. Then it will go on to connect to a powerful database like SQL.

Drrickryp
Super User II
Super User II

Hi @Labraham36 

The link between tables (Primary key-Foreign key) is done with the ID columns in SQL.  In Excel, you have to manually add an ID column to a table and carry it over into the Child table.  See my blog post on keys and how they are managed in PowerApps. https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-... , and https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Design-fundamentals-Imple... 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (56,477)