0

I have two SharePoint lists on the same site. One list (List A) has a lookup field (called Select Material) that displays the variables in the "Description" column in list (List B).

I have customized the Default New Form page for List A to also display List B in a web part beneath it on the same page. When a user completes the form for a new list entry, there is a drop down field (which is a lookup field, called "Select Material") wherein they must select the description for the item they would like to change. I would like for the Description column List B to automatically filter the based on the "Select Materials" choice in List A. Can this be done?

FYI, I am not a strong script user and I do not have access to PowerApps.

Any help would be much appreciated. Even if the solution is that it cannot be done because the first column is a lookup column.

1 Answer 1

0

You can achieve your needs through the Dynamic List Filtering function.

Note: The Lookup column does not support the Dynamic List Filtering function

For example:

1.Create the Choice column named Materials in the ListA.

enter image description here

2.Create the Choice column named Material Name in the ListB.

enter image description here

3.Create a Site page and add List web part to insert ListA and ListB

4.Edit the ListB web part

enter image description here

5.On the Edit List Web Part windows, turn on the "Dynamic filtering" option and select the filter.

enter image description here

6.Publish page

enter image description here

1
  • Hello, and thank you so much for getting back to me. I am using SharePoint 2013 on prem (not modern). However I have tried this approach as well as "connected web parts" which I believe are the same - to no avail. I have not been able to make this work at all. Which is why I wonder if the issue is the column type in list A. Not sure if lookup columns can be used for this scenario.
    – Its_Jen
    Commented Sep 15, 2021 at 15:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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