cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mhuhka
Frequent Visitor

Relationship of Tables

Hello!

I have two tables in DataVerse:

1. With information about Objects. (Table 1)

2. With information about Employees and Objects that they liked (Table 2)

 

I got the information about the all Objects from the Table 1 (for Gallery 1). There is a button with function "Add to likes Objects" in the Gallery. The function (Patch) add a new row in the Table 2 with information about the Employee (Office365.User) and the Object (Gallery 1.ThisItem). The row is unique for the each Employee.

And now I need to get a Gallery 2 with the unique liked Objects for each Employee

 

How can I link the tables for the Gallery 2?

Maybe I can add a one-to-many relationship?

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Super User
Super User

Hey!

 

So, in Gallery 2 each row corresponds to a like of an employee in a certain product.

 

So you have the info about the product and about the employee. 

I think that you have a N:N relationship there. Because a product can be liked by many employees and an employee can like many products.

 

Anyways, if you want to show by employee you can order by/ sort by/ group by employee:

 

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-sort

 

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-groupby

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

View solution in original post

1 REPLY 1
Nogueira1306
Super User
Super User

Hey!

 

So, in Gallery 2 each row corresponds to a like of an employee in a certain product.

 

So you have the info about the product and about the employee. 

I think that you have a N:N relationship there. Because a product can be liked by many employees and an employee can like many products.

 

Anyways, if you want to show by employee you can order by/ sort by/ group by employee:

 

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-sort

 

https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-groupby

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,142)