Unanswered

How to send an email alert when an item in a Sharepoint list is overdue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a SharePoint list that in which there is a due date for an item, I've created a flow based on a recurrence, but I can't get what I need in order to send the email notification.

The main idea is to get the items, and if the item is overdue send an email only to the user that is the owner of it. Not to me or to the rest of users.

The main issue is that I'm trying to get only the email of the user that has at least one item overdue from "Get items" but can't separate them when I try to send the email notification.

I have tried several attempts with a lot of information that I've found online but it is not working well.

My last attempt:

Another one

I'll be really thankful if you can help me with it.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

First, I assume that your Get Items action is returning only those items which are overdue.

Are you trying to send an email to the "owner" of the overdue item?

If so, all you need is a single apply to each loop that loops through the items returned and send an email - one email for each item sent to the owner of the item.

Are you trying to send a single email to an "owner" showing all items they own which are over due?

Let me know and I'll provide an example.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @ScottShearer ,

My 'Get items' it's supposed to do that but it's not, I guess the filter query that I'm applying is failing.

Are you trying to send an email to the "owner" of the overdue item?

/ Yes, In the Sharepoint list I'm storing the owner email of each item in a column called "Nombredelsolicitante"

Are you trying to send a single email to an "owner" showing all items they own which are overdue?
/ It could be separated emails, is not necessary to be a single email.

Was this reply helpful? Yes No