How to configure a cascaded lookup in Forms

How to configure a cascaded lookup in Forms

If you want a cascaded lookup to give the user only choices in a dropdown that apply for a choice earlier made, you can configure that in your form.

In this example we want to filter regions based on a pull down menu from a list of countries. Therefor we have two lists in the background; a list with countries, and a list with Regions, that has a lookup to the list with counties, like this:

Ein Bild, das Text, Screenshot, Zahl, Schrift enthält. KI-generierte Inhalte können fehlerhaft sein.

You can configure a cascaded lookup by using the filter in the lookup field configuration panel:

Ein Bild, das Text, Screenshot, Schrift, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.
 
Ein Bild, das Text, Screenshot, Schrift, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.

 

Using the Query editor you can create the cascaded lookup:

Ein Bild, das Text, Screenshot, Zahl, Schrift enthält. KI-generierte Inhalte können fehlerhaft sein.

Now the result is that if you select a country, only the regions for that country are visible:

Ein Bild, das Text, Screenshot, Reihe, Zahl enthält. KI-generierte Inhalte können fehlerhaft sein.

 


    • Related Articles

    • Maintenance mode

      Note: This applies only to Modern Forms, List Actions, Automation Actions and Teamsware List/Library web part starting from version 1.3.114 or higher The Maintenance mode option allows solution owners to temporarily restrict access to Teamsware ...

    • Data lookup introduction

      What is Data Lookup The skybow Data lookup connector allows you to get values from different data sources, namely from a SharePoint list or library on any site collections of the current tenant and from the list of existing teams in the organization. ...

    • Rich Forms or Modern Forms – What's the Difference?

      With Teamsware Forms, you can customize SharePoint forms and implement business logic directly within your forms. There are two available approaches: Rich Forms Modern Forms Both options allow you to customize SharePoint Display, New and Edit forms. ...

    • Action: Send Mail in Rich Forms and Action Links

      Send Mail action allows dynamically sending emails from your SharePoint site to any email address. Example: * Configurations are available for actions that use the Microsoft Graph Send Mail API. Note: In order to use the Send Mail action in Rich ...

    • How to fix broken lookup on the site

      If your SharePoint list has a lookup column that was connected to a list which has been deleted, the field configuration will show an empty 'Get information from:' value. SharePoint does not allow you to select a new source list through the UI in ...