Cascading dropdown based on other list

%3CLINGO-SUB%20id%3D%22lingo-sub-443857%22%20slang%3D%22en-US%22%3ECascading%20dropdown%20based%20on%20other%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443857%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3EI%20need%20some%20help%20with%20cascading%20dropdown%20list%20in%20PowerApps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%203%20lists%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3ENewEmployeeForm_Departments%3C%2FSTRONG%3E%3CBR%20%2F%3Ewhere%20I%20have%20only%20one%20Title%20column%20with%20departments%20description%3C%2FLI%3E%3CLI%3E%3CSTRONG%3ENewEmployeeForm_Positions%3C%2FSTRONG%3E%3CBR%20%2F%3Ewhere%20I%20have%20one%20title%20column%20with%20job%20positions%20description%20and%20one%20lookup%20column%20connected%20with%20departments%20list%3C%2FLI%3E%3CLI%3E%3CSTRONG%3ENewEmployeeForm%3CBR%20%2F%3E%3C%2FSTRONG%3Emany%20different%20columns%20and%20two%20lookup%20columns%20connected%20to%20departments%20and%20positions%20lists%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI've%20prepared%20PowerApps%20form%20to%20third%20list%2C%20but%20unfortunately%20I'm%20not%20able%20to%20filter%20positions%20based%20on%20departments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20two%20following%20scenarios%3A%3C%2FP%3E%3COL%3E%3CLI%3E%3CBR%20%2F%3E%3CEM%3E%3CSTRONG%3EDepartment%3C%2FSTRONG%3E%3C%2FEM%3E%3CPRE%3EChoices(NewEmployeeForm.Department)%3C%2FPRE%3E%3CSTRONG%3EPosition%3C%2FSTRONG%3E%3CPRE%3ESort(Distinct(Filter(NewEmployeeForm_Positions%3BDepartment%3DDataCardValue2.Selected.Value)%3BTitle)%3BResult)%3C%2FPRE%3E%3CBR%20%2F%3EAnd%20this%20works%20fine%20-%20filter%20works.%20Unfortunately%20when%20I%20submitting%20the%20form%20Position%20column%20is%20empty.%20And%20it%20makes%20sense%2C%20because%20I%20am%20referring%20to%20the%20different%20list%20(NewEmployeeForm_Positions)%3C%2FLI%3E%3CLI%3E%3CEM%3E%3CSTRONG%3E%3CBR%20%2F%3EDepartment%3C%2FSTRONG%3E%3C%2FEM%3E%3CPRE%3EChoices(NewEmployeeForm.Department)%3C%2FPRE%3E%3CSTRONG%3EPosition%3CBR%20%2F%3E%3C%2FSTRONG%3EI%20tried%20with%20something%20like%20below%2C%20but%20probably%20it%20isn't%20good%20approach%3A%3CPRE%3EFilter(Choices(NewEmployeeForm.Position)%3BDepartment.Value%3DDataCardValue2.Selected.Value%20in%20NewEmployeeForm_Positions.Department)%3C%2FPRE%3E%3CBR%20%2F%3ECould%20you%20Guys%20point%20me%20to%20correct%20way%20to%20achive%20that%20goal%3F%3CBR%20%2F%3EMany%20thanks.%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-443857%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-462703%22%20slang%3D%22en-US%22%3ERe%3A%20Cascading%20dropdown%20based%20on%20other%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-462703%22%20slang%3D%22en-US%22%3EIf%201%20is%20populating%20then%20it%20should%20work%20fine.%20Are%20you%20using%20a%20form%20(Submitform())%20to%20submit%20the%20data%3F%20Might%20need%20to%20tweak%20the%20onsave%20for%20that%20drop%20down%20to%20be%20.value%20for%20what%20it's%20passing%20in%20or%20something.%20%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%2C%20your%20best%20way%20to%20get%20an%20answer%20is%20ask%20this%20in%20the%20PowerApps%20community%2C%20so%20many%20more%20PowerApp%20guru's%20there%20to%20jump%20on%20this%2C%20they%20don't%20really%20pay%20much%20attention%20to%20this%20forum.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Guys,

I need some help with cascading dropdown list in PowerApps.

 

I have 3 lists:

  • NewEmployeeForm_Departments
    where I have only one Title column with departments description
  • NewEmployeeForm_Positions
    where I have one title column with job positions description and one lookup column connected with departments list
  • NewEmployeeForm
    many different columns and two lookup columns connected to departments and positions lists

I've prepared PowerApps form to third list, but unfortunately I'm not able to filter positions based on departments.

 

I tried two following scenarios:


  1. Department
    Choices(NewEmployeeForm.Department)
    Position
    Sort(Distinct(Filter(NewEmployeeForm_Positions;Department=DataCardValue2.Selected.Value);Title);Result)

    And this works fine - filter works. Unfortunately when I submitting the form Position column is empty. And it makes sense, because I am referring to the different list (NewEmployeeForm_Positions)

  2. Department
    Choices(NewEmployeeForm.Department)
    Position
    I tried with something like below, but probably it isn't good approach:
    Filter(Choices(NewEmployeeForm.Position);Department.Value=DataCardValue2.Selected.Value in NewEmployeeForm_Positions.Department)

    Could you Guys point me to correct way to achive that goal?
    Many thanks. 
1 Reply
Highlighted
If 1 is populating then it should work fine. Are you using a form (Submitform()) to submit the data? Might need to tweak the onsave for that drop down to be .value for what it's passing in or something.

However, your best way to get an answer is ask this in the PowerApps community, so many more PowerApp guru's there to jump on this, they don't really pay much attention to this forum.

https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1