Answered

"addDays" Expression Error

(0) Share

Report

Posted on by SunnyChoudhary

Hi All,

Is there any update in Power Automate? I have one flow which was working till yesterday but from today it is getting failed with this error.

"The execution of template action 'DateFilter' failed: The evaluation of 'query' action 'where' expression '@equals(addDays('1899-12-30', int(first(split(item()?['Due date'], '.'))), 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd'))' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'."

The Expression which is having issue is :
"addDays('1899-12-30', int(first(split(item()?['Due date'], '.'))), 'yyyy-MM-dd')"

Raw data on which above expression is working :

"Due date": "44302.5492361111"

Please let me know if anyone is having update on this.

Thanks,
Sunny

Categories:

General topics

All responses (5)

Answers (1)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Mate, @SunnyChoudhary

Your Final Expression should be -

addDays('1899-12-30',int(float(first(split(string(outputs('Compose')), '.')))),'yyyy-MM-dd')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
SunnyChoudhary 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CFernandes ,

Thank you for such a quick response, I have updated my expression and added "float" in it but getting same error my old expression(in previous message) was working perfectly form last 3 months today suddenly it started giving error, the new expression looks like this:
addDays('1899-12-30',int(float(first(split(item()?['Due date'], '.')))),'yyyy-MM-dd')

Error: The execution of template action 'DateFilter' failed: The evaluation of 'query' action 'where' expression '@equals(addDays('1899-12-30', int(float(first(split(item()?['Due date'], '.')))), 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd'))' failed: 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
Verified answer

SunnyChoudhary 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi All,

Just to close this loop all the expressions mentioned in this forum are Correct, the problem was not in the expression it was in the data on which the expression was running. As I mentioned in my previous conversation my flow was working perfectly from last 3 months but from couple of days my raw data started getting blank values in column "Due date" (this never happened before) hence the flow was getting failed. I have fix this issue now by Combining "IF-ELSE" expression and "addDays" expression.

The Final Expression looks like this:
if(not(empty(item()?['Due date'])), addDays('1899-12-30',int(first(split(item()?['Due date'],'.'))),'yyyy-MM-dd'), 'NA')

I would like to thanks @CFernandes for such a quick response and trying to help.
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Mate @SunnyChoudhary , I am glad that your problem is resolved. Thank you for your kind words.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Can you help me on fixing this error: