Problems linking tables

[Labraham36]

Hello Community! I'm having a problem with my Power Apps and I don't know how to fix it. Hopefully you can help me! My App is a Requirements Apps, and it works based on two tables. One with the data of the request, and another with the data of the comments. A request can have several comments, so what I would be needing is that when I access a request (which has a certain ID number) and I want it to go through a "View comments" button, for For example, I raised all the comments of that requirement (Obviously related to that requirement ID), and that I can also add new comments from the App. My database is an excel in One Drive that contains these two tables. I'm going crazy to be able to achieve this. Does Power Apps allow this or does everything have to be done in a single table, without relating it? Thanks!

[Drrickryp · Accepted solution]

Hi @Labraham36 

It sounds like you have a one to many relationship between your request and your comments table.

Please see my blog post about how to set up your tables using keys https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-... .  The following one explains how to implement the relationship in PowerApps. https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Design-fundamentals-Imple... 

[Labraham36]

Thank you very much for your answer! The truth is that I try and not get it. I have all the development of the App done, but if I can't get this out, it won't do me any good. Is there any chance that you can help me with this in a more personalized way by paying for the service? Surely for someone who knows more than me, it is something simple but I am going crazy!