web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get dates (remaining d...

Power Automate

Answered

Get dates (remaining days)

(0) Share

Report

Report

Posted on by Frolini

100

Hello,

I have a table with items and expiry dates.

How do I create a flow to email every week a list of items that are expiring within 60 days from the email date?

Thanks.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @Crostini ，

My Excel Table:

Please use scheduled flow:

@And(greaterOrEquals(item()?['expiry date'], utcNow('yyyy-MM-dd')),lessOrEquals(item()?['expiry date'], addDays(utcNow(), 60, 'yyyy-MM-dd'))) item()?['ID'] item()?['name']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Frolini 100 on at

Like (0)

Report

Hi @v-yetonggu-msft ,

It works! Thanks a lot!

Was this reply helpful? Yes No

Join the conversation