Incompatible types for comparison - Date,Text in dropdown items power apps

[insandur]

Hi ,

I have a sharepoint column (Date column) and when using it in the dropdown value.

When i goto items and add filter   Date =  dropdown.selected.Value i get a error   

"Incompatible types for comparison - Date,Text"  .  

[AmiraBedh · Accepted solution]

I see that you are trying to compare a date value with a text value and since your SharePoint column is a date type and the dropdown returns a text value (dropdown.selected.Value), you need to either convert the text to a date or the date to a text, depending on your needs.

You can use the DateValue function to convert the text value from the dropdown to a date format before comparing it with your SharePoint date column.

Filter(
    YourSharePointList,
    DateColumn = DateValue(Dropdown.Selected.Value)
)

[insandur]

Thank You Amira,

It worked well without error in Items, However i get error in my collect variable for that Date column collection

[AmiraBedh]

what do you want to achieve here ?