Unanswered

Filter a form according to the selections in Dropdown

(0) Share

Report

Posted on by LeonGrußler

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?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

cchannon 4,702 Moderator on at

Like (0)

Report
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.

If( !IsBlank(MyBusinessUnitControl.Value), filter( BusinessLines, BusinessUnit = MyBusinessUnitControl.Value ), If( !IsBlank(MyLocationControl.Value), filter( BusinessLines, Location = MyLocationControl.Value ), BusinessLines ) )

Hope this helps!

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report

@LeonGrußler did this post help resolve your issue? If so, please mark the solution for future forum visitors!

Was this reply helpful? Yes No