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.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

v-yuazh-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
dvaessens 14 on at

Like (0)

Report

Hi Alice,

When I test this flow, it sais error by condition.

Was this reply helpful? Yes No
v-yuazh-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

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

Was this reply helpful? Yes No
dvaessens 14 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-yuazh-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
dvaessens 14 on at

Like (0)

Report

Hi Alice,

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

Kind regards,

Danny Vaessens

Was this reply helpful? Yes No