1

Cascading drop downs have been a challenge in previous versions of SharePoint and I'm just wondering if this is supported in SharePoint Online. We have a Term Set with the structure shown below. As you can see, Canada has different cities than USA

enter image description here

Is there anyway to create cascading fields that are filtered based on the parent selection? If USA is chosen as a Country, then the Canadian cities should not be available in the child field. But as of now, they are completely independent.

enter image description here

2 Answers 2

1

The intent with metadata fields would be to use one field, instead of a field per level. So, create a field named something like "location", which would point to the metadata term set as its source. A user would use the tree structure to drill down to the desired city. The OOB list filter will allow you to filter at any level. So a filter on USA would display all records where the user selected USA, or any city in the US.

If you need two separate fields, then refer to Susan's answer, and configure something in PowerApps. (InfoPath is the older tool. It's great, but not recommended at this point).

3
  • That makes sense unless there are 2 cities with the same name in both countries. How do you decipher then? Aug 23, 2019 at 15:47
  • The metadata field has an option to display the full path of the item, so : USA:Paris. Though, last time I tried that, it broke the list filter....(this issue was in a modern view. If you're in classic, it may not be an issue.)
    – Mike2500
    Aug 23, 2019 at 15:49
  • Showing the full path would clarify those instances. I'll test it out thanks @Mike2500 Aug 23, 2019 at 15:50
1

The screenshot you posted is still realistic and achievable in sharepoint online. Almost nothing has changed in the term store management.

To be able to achieve it in other ways is

Infopath (see this video with a good example albeit much more simple than your scenario https://www.youtube.com/watch?v=-HnLhXVQf-M&t=2s). Might that Infopath is the old way to do things.

Powerapps (https://www.youtube.com/watch?v=5wfSAsU93b4)

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.