If condition

(0) Share

Report

Posted on by iwsejet

Hi,

I am new to power automate.

I am trying to get the difference btw two date fields "Date Reported" and "Email Sent' from sharepoint and if the number of days is greater than 10 days send mail Notification.

My flow is :

dateDifference(item()?['DateReported'],item()?['EmailSent'])

The above flow is failing with error Unable to process template language expressions for action 'Condition_2' at line '0' and column '0': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

As an option2: I have a column in Sharepoint "Date Lapse" which has already calculated the difference just need to do the "if the number of days is greater than 10 days". My problem is I am not able to do the If stt greater than 10 days

Thanks in advance.

Categories:

General topics

All responses (4)

Answers (1)

Sort by

iwsejet 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Edited my question and posted in the original
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @iwsejet ,

The return value of datedifference is a string something like :

"1268.00:00:00"

Please try:

int(split(dateDifference('2015-02-08', '2018-07-30'),':')[0])

Best Regards,

Bof
iwsejet 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Thank you it worked for static dates, but when I use the dynamic content from sharepoint ( Date & time format column is used) it throws error.

int(split(dateDifference(item()?['DateReported'],item()?['EmailSent']),':')[0])

Can you share your thoughts.
Thanks.
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @iwsejet ，

The point is that the value of item()?['DateReported'] is null.

Best Regards,
Bof