Power Platform Community Forum Thread Details

So I already know how to do cascading drop downs using power apps and sharepoint lists where certain drop down choices are dependent based on what is chosen in another. But it isn't really dynamic and is based on what is hard coded in each sharepoint list. I was hoping that there was a way to make the choices in one drop down, the exact items selected in another. For example.

DropDown1 contains HR, Marketing, Accounting, IT, and Facilities. If a user selects HR, Accounting, and IT. I want DropDown2 to only have those choices available.

Off the top of my head, I was thinking about creating two identical multiple choice drop down columns in SharePoint. One called "Assigned Departments" and one called "Task Complete". They would both contain the same choices. Then I was hoping there would be a way to use filters in power apps to only show what was selected in "Assigned Departments" drop down in the "Task Complete" drop down.

Basically I want am creating an app where the top level manager will assign tasks to each of various departments (there are a lot more than what I listed above). As each department completes their assigned task, I would have them go in and check that they are done with the task. I figure the easy way would be to have two columns/dropdowns. One called "Assigned Departments" and one called "Task Complete". So the person assigning tasks will select the assigned departments. Then as departments complete their tasks, they go back into the form and select their department in the "Task Completed" drop down. I would then display a third data field in there powerapp that will show who has not completed their task so that the manager assigning the task can quickly see who didn't complete their task. If anyone has any other suggested method, that would also be great.

Categories:

Building Power Apps