Unanswered

Sending auto email 30 days before due date

(0) Share

Report

Posted on by Ninovm

Hello everyone!

I'm new at power automate. Can somebody assist me in creating a flow that will remind end users about their due equipment? Any help would be appreciated.

I've done below flow:

Recurrence

Get future time for 30 days

List items in a table

Thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!

@Ninovm

I have created a SharePoint list with the date column 'Test Date'

We can add a OData filter query on the SharePoint "Get Items" action to filter the data to match our specified requirements

addDays(utcNow(),30,'yyyy-MM-dd')

or

You can also make use the Filter Array action in Power Automate to filter the data as needed

If the information shared helps you please consider giving a thumbs up 👍 and mark solution as resolved

Please follow my website PowerCards for more information related to Power Platform

Was this reply helpful? Yes No
Ninovm 12 on at

Like (0)

Report
Copy link

Link copied!

i have created below flow but with error.

Was this reply helpful? Yes No
Ninovm 12 on at

Like (0)

Report
Copy link

Link copied!

I already have this flow. but the mail i'm receiving is wrong as suppose on what it has on the excel file. i'm suppose to receive only 1 item and the other item to my colleague.

Was this reply helpful? Yes No
z_prins 12 on at

Like (0)

Report
Copy link

Link copied!

What is the expression I would need if I am trying to send an email 1 day before a due date? I am having a hard time finding help on this.

Was this reply helpful? Yes No