I have 2 sharepoint lists:
- Ansatte (Employees)
- Trening (Training)
In "Ansatte" I have a field "Navn" (Name) which is of the type peoplepicker.
In the "Trening" list, I have a dropdown that retrieves people from the "Ansatte" list. This field is saved as a text field with the value of DisplayName.
In addition, there is a date field that tells when the person has been in training.
Today I fill the dropdown list with names by using Sort(ForAll(Ansatte,Navn),DisplayName) which works just fine.
To simplify the filling, I want to show names in the dropdown list that are not already registered on the selected date in the "Trening" list.
The selected date is retrieved from DataCardValue2.SelectedDate
Can anyone help?
