You’re offline. This is a read only version of the page.
I am trying to filter a processing form.
The basis of this form is a table.
In the table there are the columns Location, Business Unit, Business Line and Department.
The columns are configured as choices
The names of the entries are structured as follows:
Business unit: Businessunit
Location: Location
Business line: Location.businessunit.businessline
Department: Location.Businesunit.Businessline.Department
I have a total of 4 dropdowns, one for each column.
If I select the businessunit and the location, the dropdown Businessline should only show the businesslines that belong to the selected businessunit and location.
If I have selected the businessline, it should only display the departments that match the businessline in the Department dropdown.
Can one of you help me?
@LeonGrußler did this post help resolve your issue? If so, please mark the solution for future forum visitors!
Maybe try the example as a starting point. I don't know your table or control names so I've just put in placeholder names and I wrote this off the top of my head so syntax might not be exact, but hopefully this gives you an idea...
This example shows how you might build the dataset for Business Lines: We start with an IF to check, "is there a value in Business Unit?" If so, we will return Business Lines where they match the Business Unit. If not, we will look to the Location Control value. If that contains a value, we will return Business Lines where they match that location, otherwise, we will just return all business lines, unfiltered.
Share
Report
All responses (
Answers (
If(
!IsBlank(MyBusinessUnitControl.Value),
filter(
BusinessLines,
BusinessUnit = MyBusinessUnitControl.Value
), If(
!IsBlank(MyLocationControl.Value),
filter(
BusinessLines,
Location = MyLocationControl.Value
),
BusinessLines
)
)Hope this helps!
#1
WarrenBelz
85
Most Valuable Professional
#2
mmbr1606
55
Super User 2025 Season 1
#3
Michael E. Gernaey
52
Super User 2025 Season 1
