Hi @Shibato,
If I understand your situation:
- NewEmployeeForm_Departements
- NewEmployeeForm_Positions
- Title
- Department (lookup to Departments)
- NewEmployeeForm
- many columns
- Departement (lookup to Departements)
- Position (lookup to Positions)
In you form for the NewEmployeeForm list, once you have chosen a value for the Department field, you want to filter the list of values in the Position field according to the Departement field value.
If that's what you want to achieve, here is how you have to do it... In the Items property of your Position field, put the following code:
Filter(
Choices(NewEmployeeForm.Position),
Id in ShowColumns(
Filter(NewEmployeeForm_Positions, Department.Id=DataCardValue2.Selected.Id),
"ID"
)
)
Tell us if this works for you...
Emmanuel
