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:
You can
configure a cascaded lookup by using the filter in the lookup field
configuration panel:
Using the
Query editor you can create the cascaded lookup:
Now the
result is that if you select a country, only the regions for that country are
visible:
Related Articles
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. ...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 ...Secure Azure Function with Microsoft Entra ID for calling from Modern Forms and Automation Actions
This article will provide an example how to secure your Azure Function with Microsoft Entra ID to make secure calls from Modern Forms and Automation Actions using Start Power Automate / Azure Function action Secure Azure Function with Microsoft ...How to handle the lookup columns threshold in a Document Generator template for a single item
f your Document Generator Template contains more than 12 lookups that exceeds the SharePoint lookup column threshold, you may face the situation that the generated document may not include all lookup values. To overcome this problem we propose the ...