Modified Date & Todays Date

(0) Share

Report

Posted on by dvaessens

Hi,

I'm trying to make a flow that:

send an email when modified = today minus 30 days. So the owner of the document receives an email. Hope anyone can help me.

All responses (7)

Answers (1)

dvaessens 14 on at

Like (0)

Report

Re: Modified Date & Todays Date

Hi Alice,

LessorEquals was the solution I needed. Thanks for your help!

Kind regards,

Danny Vaessens
Verified answer

v-yuazh-msft on at

Like (0)

Report
Re: Modified Date & Todays Date

Hi @dvaessens，

Maybe you could take a try with expression below:

@lessOrEquals(formatDateTime(items('Apply_to_each')?['Modified'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), -5), 'yyyy-MM-dd'))

Or expression below:

@greaterOrEquals(formatDateTime(items('Apply_to_each')?['Modified'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), -5), 'yyyy-MM-dd'))

Best regards,

Alice
dvaessens 14 on at

Like (0)

Report

Re: Modified Date & Todays Date

Hey Alice,

The flow succeeded, but there's no email send. I changed the @equal.. to -5 (because there are no items modified more than 30 days ago). But at the end, there's no mail send. In my opinion there shood have been send an email.

But when I test the flow it sais: Expression result -> False
GabrielStJohn on at

Like (0)

Report

Re: Modified Date & Todays Date

Hey, @dvaessens!

Thank you for posting on the Flow Community Forum! It appears as though @v-yuazh-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager
v-yuazh-msft on at

Like (0)

Report

Re: Modified Date & Todays Date

Hi @dvaessens,

Could you please share more details about the error message?

Could you please share a screenshot of your flow and the error run history of the flow?

I have made a test on my side and don't have the issue that you mentioned, please share more details so we would try to provide a proper workaround for you.

Best regards,

Alice
dvaessens 14 on at

Like (0)

Report

Re: Modified Date & Todays Date

Hi Alice,

When I test this flow, it sais error by condition.
v-yuazh-msft on at

Like (0)

Report
Re: Modified Date & Todays Date

Hi @dvaessens,

I have made a test on my side, please refer to screenshot below to create the flow:

The expression in the Condition as below:

@equals(formatDateTime(items('Apply_to_each')?['Modified'], 'yyyy-MM-dd'), formatDateTime(addDays(utcNow(), -30), 'yyyy-MM-dd'))

Please let me know if your problem could be solved.

Best regards,

Alice