Relationship between sharepoint lists

(0) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-chenzhi on at

Like (1)

Report
Hi @Anonymous ,

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

Was this reply helpful? Yes No