I'd actually question what the flow is currently doing and if that's what you actually want. At the moment, Eric is going to get multiple emails (one for each overdue workstation) every single day. If a lease is 89 days it will send an email, if tomorrow it's 88 days, another email, 87 days, another email, etc.
What might be a better option is to bundle all the overdue workstations together into a single HTML Table and send just one email to Eric daily.
Below is how I'd probably build the flow based on what I mentioned above.
For this example, I have the following SharePoint List. Days Left On Lease is a Calculated Column as you already have.
See full flow below. I'll go into each of the actions.
Recurrence is set to run daily at whatever time you want to send out the email.
Get items uses the following Filter Query to return items that are less than or equal to 90 days and sorts the items by DateLeaseExpires.
Note that Get items will only return the first 100 items by default. We can easily increase this to 5000 items by setting the Top Count (not sure how many items you are expecting to be returned).
Also note that your internal column names might be different to what I have below - you'll need to ensure you use whatever you have in your list.
DateLeaseExpires le '@{addDays(utcNow(), 90, 'yyyy-MM-dd')}'
Create HTML table uses the output from Get items and maps the Title, Date Lease Expires and Days Left On Lease. It uses the following expression to remove any decimal places that Power Automate sometimes adds.
//You'll need to ensure you use the internal column name you have on your list
formatNumber(float(item()?['DaysLeftOnLease']), 'N0')
Style HTML table is a Compose action that contains some CSS for styling the HTML table, so it looks nicer in the email.
<style>
table {
border-collapse: collapse;
}
table td,
table th {
border: 1px solid #ddd;
padding: 6px 20px;
text-align: left;
}
table th {
background-color: #1C6EA4;
color: white;
}
</style>
Send an email will send just the one email to Eric (in your case) with a table of all the workstations that are expiring. It uses the output from Style HTML table and Create HTML table.
After the flow runs, we would get an email similar to that shown below.
----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
