Filtering Dropdown choices in a Power Pages form using Dataverse Relations

-

Filter dropdowns


Dropdown filters are a useful feature in form design, allowing users to filter options in one dropdown based on other selections in the form. In Power pages, leveraging the capabilities of Dataverse relations makes it possible to create these powerful filtering mechanisms. This is how it works.

What you need to know first.

Before we dive into the implementation details, ensure that you have a basic understanding of Power Pages forms and Dataverse relations. 

How is´t made

  1. Create two tables in your Dataverse environment: "Type" and "Category." These tables will hold the relevant data for the dropdowns.
  2. Establish a Lookup Relationship between the "Category" and "Type" tables. Create a lookup column in the "Category" table that references the "Type" table. This lookup column will allow us to filter the categories based on the selected type.
  3. Now, create a third table called "Request." This table will serve as the foundation for the form where you want to implement the filtered dropdown.
  4. Design the form in Power Pages Designer using the "Request" table as the data source. Add two dropdown controls to the form, one for the "Type" and another for the "Category" field.
  5. Populate the "Type" table with the available types. E.g. "Individual", "Collective" and "Organization".
  6. Populate the "Category" table and relate the different categories to types of requests.
  7. Now go back to the "Request" form in the designer and choose the "Category" control. Check "Filter by related rows" and choose the "Type" table under "Relationship to current table" and select the correct relation name under "Relationship to this lookup´s table".
  8. Now include the form in a page using the Power Pages Designer. When running the page in preview, it should look something like this.
The type is preselected in this instance, and when opening the lookup, the available items should automatically be filtered.


This feature allows you to design effective and easy-to-use forms. After all, your users have other things to do than scrolling through your forms, and I assume that you want quality data ;)

Comments

Post a Comment

Popular posts from this blog

Designing and programming - Part 2

-
This part of the series will handle the creative part of the cycle. You might loosely categorize the steps of the design process in three different stages. First is the creative methods - this stage contains methods that drives the design project forward adding new ideas and features to the design. However, systemizing the ideas and filtering them is also part of this stage. The next stage contains different methods of implementation. This is where the ideas meet the matter - where ideas become code and components. You get the idea:) The third and last stage is perhaps the most crucial one. This is where you test and evaluate your results. It is now that you have to decide whether the implementations meet with the requirements and visions of the design. The outcome of this stage will determent if the prototype is ready for some real world testing, also called a beta. Anyways, after clearing that up, the creative stage is what this part of the series will be all about. The Creati
Read more

Exploring the Power of Variables in Liquid and Power Pages

-
Covering the basics - Variables As a templating language, Liquid offers a rich collection of possibilities for web developers and designers, bringing Dynamics business data to the web. Variables in Liquid enable us to display dynamic content and enable us to implement a certain level of custom logic as well. We'll have a look at some examples on how to work with variables. Variable Assignment In Liquid, variables can be assigned values using the {% assign %} tag. For example, let's assign the value "Hello, Nerd!" to the variable greeting: {% assign greeting = 'Hello, Nerd!' %} Variable Output Once a variable is assigned a value, it can be outputted using the {{ }} syntax. To display the value of greeting, we can use: {{ greeting }} Assigning Site Settings Liquid is powerfull enough to allow you to assign values from site settings to variables. For example, if you need the site setting for inactivity for
Read more