Relationship between sharepoint lists

[CamiloHU]

Hello!

I have two lists in sharepoint, one of them with the data of the projects and, another one, where I will host the data of the people who will be assigned to those projects.

In the second list I have a LookUp type column with the project ID of the first list. When selecting a project from this list I should see in a gallery only the people assigned to that project, that is, where IDPrincipal = IDProject. How can I implement this?

[v-chenzhi · Accepted solution]

Hi @CamiloHU ,

Do you want to show people in Gallery who are assigned to projects?

Could please me more about your scenario?

I assume you have this in SharePoint and have a test on my side, please try the following workaround.

I add a Dropdown and a Gallery in canvas.

Set the items property of Dropdown to:

Projects.ID

Set the items of Gallery to:

Filter(People,'The look up'.Id=Dropdown1.Selected.ID).Title

It will show like this

Best Regards,

Zhi Chen