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

Problems linking tables

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

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... 

View solution in original post

2 REPLIES 2
Drrickryp
Super User
Super User

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... 

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!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,364)