Relationship of Tables

[mhuhka]

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?

[Nogueira1306 · Accepted solution]

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!