Filtering dropdown

(0) Share

Report

Posted on by GuttormG

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?

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

GuttormG 23 on at

Like (0)

Report

Re: Filtering dropdown

Thanks! I could not make that work, but it pointed me in the right direction, and I ended up using
Sort(Filter(ForAll(Ansatte,Navn),Not(DisplayName in (Filter(Trening,DataCardValue2.SelectedDate=Dato).'{Name}'))),DisplayName)
CNT 10,926 on at

Like (0)

Report

Re: Filtering dropdown

@GuttormG your formula will be,
Sort(Filter(Ansatte,! (Navn in Concat(Filter(Trening, dateColumn=selectedDate, Navn), "," ) ),DisplayName)