FILTER expression for Valid if

[Phil_Waite]

Hi,

I have a drop down list in a form based on another table using the valid if function. I want to filter out the items in the list based on whether those items appear in the table the form is based on (so each item can only be selected once a day) 

I have the expression below

FILTER("Areas", AND([Date]=TODAY(),NOT(IN([Unique Id],Area Checklists[Area]))))

This works but the next day nothing shows in the list at all.

I need the expression to say "only show [Areas] that that don't  appear in the table Area Checklists  that also don't have todays date in the [date] column (in the same row)

thanks

Phil

[Marc_Dillon]

Search for "prevent duplicates"