Hi all, i have a flow that is taking a date from an excel file, comparing it today's date in a conditional and then, if they match, do some stuff.
yesterday - this worked fine. today, it fails with the error:
Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2885': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
so here are the expressions i'm using to convert the date from the excel file to be the same for comparison purposes:
first - the excel input (using the "value - list of items" dynamic content:
formatDateTime(addDays('1900-01-01', add(int(items('Applytoeach')?['Date Conversion']), -2)), 'MM-dd-yyyy')
[Date Conversion] is my excel date column. my input looks like this once read out:
2021-01-13T00:00:00.000Z
next, i have an expression to get today's date for comparison:
formatDateTime(utcNow(), 'MM-dd-yyyy')
which is where the flow fails and i get the above error.
note, i have hundreds of dates in here, and they all fail, not just particular dates.
