Reminder Flow for once a week for Overdue List Items

[Anniesoptera]

Hello!

I'm trying to create a flow that sends an e-mail once a week to Action owners whose tasks are overdue

Action	Start Date	Status	Assigned to
Task1	17 Jun 2019	Complete	Person1
Task2	17 Jul 2019	Not Started	Person1
Task3	1 Jan 2020	Not Started	Person1
Task4	17 Jul 2019	Not Started	Person1

So, it should send an e-mail to Person 1 for tasks 2 and 4, as they are both not started yet and they have past-due starting dates.

I tried following the solution here, but not only does it not give me exactly what I want, my company does not allow us to use the "Send e-mail" Action with outlook:

So I can only use the following option, which works quite well but I can only reference fields from the list but not embed the HTML Table I generated:

Any Ideas?

Alternatively:

I don't need to send a list of the action items. I'm happy to just send a reminder once a week that says "You have Items Overdue" which will link them to a view I can create that is just for overdue items that they own. So, as long as they have even 1 overdue item, they get an e-mail.

[v-yamao-msft · Accepted solution]

Hi @Anniesoptera ,

Yes, the output of HTML table could not be selected directly for the Body field of Send an email notification (V3).

Please consider adding a Compose action after the action Create HTML table, select HTML Output as its Inputs, then select Compose output for the body field.

I have made a test likes below, which is working properly.

The items I set in the HTML table action:

Title: item()?['title']

Startdate: item()?['StartDate']

Assigned: item()?['Assigned']?['Email']

Besides, you could create a connection to Outlook.com and try with its action Send an email as well.

Best regards,

Mabel       

[Anniesoptera]

Thank you Mabel! I'll give it a try.

How do I filter for items that have Not Started (status) AND Start Date has passed (i.e. date is before today?)

The header for my Start Date is Planned Start Date.

I've tried the following:

And get the following message:

{ "status": 400, "message": "The expression \"Status eq 'Not Started' and PlannedStartDate lt 2019-07-31\" is not valid.\r\nclientRequestId: c37c0873-c2cc-428a-b668-945b13ce224e\r\nserviceRequestId: c37c0873-c2cc-428a-b668-945b13ce224e" }

[Anniesoptera]

Ok! Got it to work using @v-yamao-msft's solution above and the following filter on Get Items:

Status eq 'Not Started' and StartDate lt 'utcNow('yyyy-MM-dd')'