Filtering table from ComboBox

[James90]

Hi,

I have done a fair bit of searching but I can't quite find the answer that will work. 

The end goal is that the user can filter the table but selecting dates up to 10 days in the future. 

I have a ComboBox that displays 10 dates ( Today(), Today()+1, Today()+2.... etc) 

In the filter I am getting an error with the '=' sign when trying to filter on the dates vs the combobox.selectedvalues. 

SortByColumns(
    Filter('SharePointList', Assigned=false && Region=ChooseRegion.Selected.Value && 'Call back date calc'=ComboBox4.SelectedItems),
    "Callbackdate", Ascending
)

The error is on the final '=' between 'Call back date calc' and ComboBox4.SelectedItems

i am getting "Invalid Argument Type

any help would be great!

[Jeff_Thorpe · Accepted solution]

Since ComboBox4.SelectedItems is a list of values you can't use the "=" operator to compare against it. Try replacing the "=" with "in".

Example:

SortByColumns(
    Filter('SharePointList', Assigned=false && Region=ChooseRegion.Selected.Value && 'Call back date calc' in ComboBox4.SelectedItems),
    "Callbackdate", Ascending
)