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

Relationship between sharepoint lists

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?

 

CamiloHU_0-1638824780254.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-chenzhi
Community Support
Community Support

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.

vchenzhi_0-1639017471325.png

vchenzhi_1-1639017506939.png

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

vchenzhi_3-1639017877113.png

vchenzhi_4-1639017888319.png

 

 

Best Regards,

Zhi Chen

 

 

View solution in original post

1 REPLY 1
v-chenzhi
Community Support
Community Support

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.

vchenzhi_0-1639017471325.png

vchenzhi_1-1639017506939.png

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

vchenzhi_3-1639017877113.png

vchenzhi_4-1639017888319.png

 

 

Best Regards,

Zhi Chen

 

 

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.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,078)