cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kouliscon
Helper V
Helper V

Flow to send an email 2 days past due date

hello all,

 

I have a sharepoint list with the below main columns:

  • "status" with dropdown selection of "in progress" and "completed"
  • "assignmentduedate"

 

I would like a flow to send a reminder email to someone for an item that is past due the "assignmentduedate" with 2 days.

 

the flow which I have is:

 

  1. recurrence -> daily at 06:00am
  2. Get items -> here I believe I need the formula
  3. apply items
  4. condition to check if the status is "in progress"
  5. send email

 

thank you

1 ACCEPTED SOLUTION

Accepted Solutions
ChristianAbata
Super User
Super User

hi @kouliscon  what you need to do is add an expression, the expresion is addDays('YOur value from Sharepoint',2)



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

10 REPLIES 10
ChristianAbata
Super User
Super User

hi @kouliscon  what you need to do is add an expression, the expresion is addDays('YOur value from Sharepoint',2)



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

thank you @ChristianAbata  but can you elaborate a bit at the formula as I am not so familiar like the one below?

 

pastDue2Days.png

 

 

hi @kouliscon  you are doing it well but in the first part you need to select the dynamic content value, please change the tap from expresion to dynamic content and then select your colum value



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

thanks @ChristianAbata  but there is no Dynamic Content at the "Get Items" "Filter Query"..

 

any other ideas..

oh @kouliscon  thats because you are getting lots of results, please create a compose action and inside add your column sharepoint value then try again with the expression and user the compose output.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata  I am missing something here as I did the below

 

1.png

Error:
InvalidTemplate. Unable to process template language expressions in action 'Get_items' inputs at line '1' and column '2861': 'In function 'addDays', the value provided for date time string 'AssignmentDueDate' was not valid. The datetime string must match ISO 8601 format.'.

 

@kouliscon  what is assignmentduedate for you? is not a column sharepoint?

 

To di what I suggest you you need to frist get items then before that you can add days



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

@ChristianAbata  assignmentduedate is a SharePoint Date column

 

what query I need for Get Items? I think there is the problem

UFBobby
Regular Visitor

Did you ever solve this?  I am looking to do the same.

kouliscon
Helper V
Helper V

certainly this worked, below is the flow:

Flow1.png

 

 

where the expression is: formatDateTime(addDays(utcNow(),-2),'yyyy-MM-dd')

 

Flow2.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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,649)