1. How to get drop down options using external Data?
  2. How to set up a rule if Column A ( Pens, Books, Sketches) and Column B (Parker,Reynolds,Cello, Text Books,Note Books, Ruled Books ).

When I select Column A - Pens, only (Parker,Reynolds,Cello) should be available as drop down options.

2 Answers 2


External data can be made available by using BCS.

For the cascading dropdowns have a look at SPServices


I saw you put as a keyword Infopath. Your point 2 can be achieved with Infopath easily, see this video which has a guide. If you want other guides, this feature is called "cascading filters". Infopath will still work in SharePoint for some years.

You can also achieve the same by using O365 PowerApps. Here is a guide https://www.itidea.nl/index.php/how-to-create-cascading-drop-downs-using-powerapps/

  • Nice catch. I did not see the reference to infopath.
    – Nils
    May 29, 2019 at 6:08

Your Answer

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

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