Power Platform Community Forum Thread Details

Hi all,

So I've made a gallery to house a set of dropdowns, for the aim of reducing the number of controls on a screen. I've made a table like below:

Table(
 {Name: "Department", Items: Sort(RenameColumns(colDepartments, ShortName, Value), SortOrder)},
 {Name: "TaskType", Items: Distinct(colTaskTypes, TaskType)},
 {Name: "Responsibility", Items: Distinct(colResponsibility, Responsibility)}
)

I've renamed the Department outputs to Value so it'll work with the "fields" parameter of the dropdown. Each of the collections being referenced have an extra row to act as a default value/header for the dropdown.

This gives me something like this:

Now what I'd like to do is two things:

1. I'd like to make it so that both the Task Type and Responsibility dropdowns are disabled while the Department dropdown has "Department" selected. I figure i might need to reference the specific values within the dropdown, but I can't figure out how. Some combination of With() or As? Whatever I try in DisplayMode doesn't seem to work.

2. I'd like to filter the Task Type dropdown based on whatever Department is selected. colTaskTypes (the collection this dropdown is populated by) has separate entries based on the Department selected.

It would be as simple as anything if these were seperate controls, but using this method of reducing the number of controls is boggling my brain. Can anyone offer any advice, as well as explaining how it works?

To add, I know that reducing the number of controls is not essential, and that it really would be a problem to just have three seperate dropdown controls, but this is really an exercise in improving my PowerApps knowledge!

Categories:

Building Power Apps