Flow to send an email 2 days past due date

[kouliscon]

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

[ChristianAbata · Accepted solution]

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

[kouliscon]

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

[ChristianAbata]

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

[kouliscon]

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

any other ideas..

[ChristianAbata]

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.

[kouliscon]

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

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.'.

[ChristianAbata]

@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

[kouliscon]

@ChristianAbata  assignmentduedate is a SharePoint Date column

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

[UFBobby]

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

[kouliscon]

certainly this worked, below is the flow:

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