We have three lists in modern SharePoint:

  1. Company:

enter image description here

  1. Employee: Used lookup on Industry column

enter image description here

  1. Database: Used lookup on Employee and Industry column

enter image description here

Question: How can I show only those employees which are belonged to specific company while adding new item in Database? Example: If I select CTS as company then only A employee should be visible in Employee column dropdown.

As per current lookup, all the employees are visible in all the companies while adding new item. enter image description here

Note: Modern SharePoint does not support any external scripting file.

  • Can you use PowerApps? If so check this link
    – Sandro
    Oct 1, 2020 at 13:42

1 Answer 1


If you want to create a cascading dropdown in modern experience, you will need to use PowerApps like Sandro said.

For classic experience, you can insert a java script to get it done or use InfoPath (not recommended).

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.