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!
Solved! Go to Solution.
Have you tried converting the date from Excel to the general date format and then filter?
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!