How to filter Date that has dd-mmm-yyyy format in Excel

[Newbie12]

Hi,

My datasource is Excel file, and I am trying to create schedule flow,where I need to filter the Date column. The problem is Date is in dd-mmm-yyyy format (ex: 10-Mar-2020), and date is in Text format in Excel. I am using Filter Array in Data operation to filter the date. However, as shown below, when I use "-" below contains row. I am getting an Error that says "The Power Flow's logic app flow template was invalid. The template language expression 'contains(item()?['Signoff Date'], -)'is not valid: The value "-" at position 34 cannot be converted to number."

I am not sure how to fix the issue?  Any help is appreciated!

Thanks in advance for your time!

[sudharsan1985]

Hi @Newbie12 

Have you tried converting the date from Excel to the general date format and then filter?

[v-bofeng-msft · Accepted solution]

Hi @Newbie12 :

Please try this flow:

Best Regards,

Bof