cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ninovm
Regular Visitor

Sending auto email 30 days before due date

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

3 REPLIES 3
Gopala_Krishna
Super User
Super User

@Ninovm 

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

Gopala_Krishna_0-1638002293801.png

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

Gopala_Krishna_1-1638002453045.png

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
Ninovm
Regular Visitor

i have created below flow but with error.

 

Ninovm_0-1638148822846.png

 

Ninovm
Regular Visitor

Ninovm_0-1638176022619.pngNinovm_1-1638176084693.pngNinovm_2-1638176123237.png

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.

Ninovm_4-1638176384155.png

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,426)