Sharepoint List choice column as Dropdown1 based on selected item in Dropdown2 in Powerapps

Question

I have a sharepointlist with 2 columns (Department; Shift[choicefield]) each department has different choices of shifts.
These values should be selectable in 2 different dropdowns in Powerapps, the dropdown values with choices of shift should be based on the selected value of the department.

Filter(Choices(Personal.Shift);Value = Dropdown_Department.Selected.Department) - But this does not work.

Answer 1

Hi @Remo Jagst ,

Do you want these two Drop dowm be like: when user select "A" in Drop down1 then user can only select "D" in Drop down2?

Per my test, you could use the following code:

If(DataCardValue6.Selected.Value = "A", Filter(Choices([@testchoice].Shifts),Value = "D"),Choices([@testchoice].Shifts))  

My test result: when select "A" in "Department" "D" will be the only choice in "Shfits", when select "B" in "Department" you could select "D" "E" "F"

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.