Flow to send an email 2 days past due date

(0) Share

Report

Posted on by kouliscon

247

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:

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

thank you

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report

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

any other ideas..

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report

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

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@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

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report

@ChristianAbata assignmentduedate is a SharePoint Date column

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

Was this reply helpful? Yes No
UFBobby 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report

certainly this worked, below is the flow:

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

Was this reply helpful? Yes No