Unanswered

Flow was working but it fails because of the date format?

(0) Share

Report

Posted on by trekingalong

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.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

kokane Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#date-and-time-functions

Was this reply helpful? Yes No
trekingalong 4 on at

Like (0)

Report
Copy link

Link copied!

Good evening,

I have not been able to find a work around. Could you suggest an expression?

Was this reply helpful? Yes No
trekingalong 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No