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

All responses (11)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

Hello All, I'm trying to create a flow that does something similar to this except my data is in the data verse, and not in SharePoint. Is there anyway you may have a method of doing basically the same thing but with the data verse?
kouliscon 247 on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

certainly this worked, below is the flow:

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

Like (0)

Report

Re: Flow to send an email 2 days past due date

Did you ever solve this? I am looking to do the same.
kouliscon 247 on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

@ChristianAbata assignmentduedate is a SharePoint Date column

what query I need for Get Items? I think there is the problem
ChristianAbata 8,947 Most Valuable Professional on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

@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 247 on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

@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 8,947 Most Valuable Professional on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

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 247 on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

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

any other ideas..
ChristianAbata 8,947 Most Valuable Professional on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

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 247 on at

Like (0)

Report

Re: Flow to send an email 2 days past due date

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