Help Building "Send Email" when item is within 0-10 Days of Due.

(0) Share

Report

Posted on by teddycram

Hello!

Background: New Power Automate User ( skill level : Low )

First, I would like to start by saying I have the email notification working...ISH. It CURRENTLY sends an email with a list of items DUE within 3 days. The way I got this current flow was in SharePoint... I clicked on "Automate > Set a reminder"

THE PROBLEM.

It only sends an email of items EXACTLY within 3 days. I need it to send me a list of ALL items from 0 to 3 day.

CURRENT FLOW:

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

selfy100 228 on at

Like
a
(0)

Report
Copy link

Link copied!
Can you use an Add Time action to add 3 days to utcnow(), then get items on the Sharepoint list, with a filter query
DueDate le [Calculated Time]
That would return all items on the sharepoint list with due dates in earlier than 3 days from now.
teddycram 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@selfy100

Thank you so much for the fast response! Im still a very new user in the World of Power Automate. Where would I add that in my flow ? Is there any chance you could show me an example?
selfy100 228 on at

Like
a
(0)

Report
Copy link

Link copied!

I would start with a much simpler flow like this, then fine tune from there:
The HTML table action will create a super simple table with headers that you specify and the values you need to pull from the SP list. The only problem with this flow is that it'll run every day and send you an email every day even if you have no deadlines in the next three days so I would put a condition that would only send the email if the filter returned values.

Edit: oh **bleep**, the filter in Get Items should be le not ge.