You’re offline. This is a read only version of the page.
4
I have a Flow tied to a spreadsheet and am trying to convert the date, "Reminder Date" below, to match utcNow(). The expression below has worked. Today, Flow indicates the expression failed and I receive the error message beneath it.
FormatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['Reminder Date']),-2)),'MM-dd')
Error: Unable to process template language expressions for action 'Condition' at line '1' and column '10245': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
Please tell me how to correct this error. Thanks!
Solved. The window where the expression is entered is small so I typed it in MS Word. For some reason Word turned the apostrophe at the end of '1900-01-01' into a single quotation mark. 😩This is the only place where it occurred. When I copied and pasted the expression into Flow and ran it, I got the error message. I corrected the error and the Flow worked perfectly.
This Flow sent an email to someone based on a date in a spreadsheet. The spreadsheet is located on OneDrive for Business. I upload a copy of it into Teams and created a new Flow. The Flow recognized the expression above and it ran successfully. No emails were sent, however.
Good evening,
I have not been able to find a work around. Could you suggest an expression?
Hello
Function 'int' was invoked with a parameter that is not valid, so you can use other functions to instead of it.
Please check the function reference.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
