You’re offline. This is a read only version of the page.
251
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:
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.
so just to close the loop on this - they switched it back. you know, after i changed a couple dozen flows 😛 (at least it was only a couple dozen)
https://www.dontpapanic.com/blog/?p=681
Hi @Seuadr
Thanks for your posting.
According to your description, your flow got broken suddenly and error message related to date and time. Actually, it’s a known update for “List Rows action in the Excel Online (Business) connector” around January 15, 2021. Date format has been changed and we don’t need to do date conversion.
|
For detailed announcement, please kindly refer below link:
Excel Date changes in Power Automate - Power Platform Community (microsoft.com)
Hope the content above may help you.
Thanks.
Anna
#1
WarrenBelz
146,653
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
