There is one list Clients, and another list Projects. Latter is linked to Clients by looking up Clients ID column.

Now if I am in Clients list page, how can I click one client row and somehow display all the linked projects rows?

  • What SharePoint version are you using? And are you using classic or modern UI? – Denis Molodtsov Aug 17 '19 at 19:00
  • 1
    @DenisMolodtsov modern UI, sharepoint online in Office Business 365 – Sheen Aug 17 '19 at 19:07

In SharePoint 2013 and earlier you could have used a URL parameter to filter the Projects list web part by the ID of the Client, but currently, Modern SharePoint does not have the web parts or functionality to do that.

You could use an embedded PowerApp, though. Use the Client as one data source, use a drop-down to select the client, then use the Projects as another data source, filter by the selected client ID and show the results in a gallery.

| improve this answer | |

You can create edit/view form of 2 related lists, reference:


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.