Unanswered

I want to create an automated flow on Power Automate where it sends an email if an expiry date is near.

(0) Share

Report

Posted on by Camlee98

Hi guys,

I'm wondering if anyone would be able to help me with creating a flow on Power Automate where it looks for expiry dates for software licences on SharePoint list and sends an automated email with the licence name and how long it has left till it runs out. I want it to send an automated email when it is 7, 14, 30 and 60 days from expiry.

Any help will be great, thank you!

Categories:

Business Process Flows

Screenshot 2024-0...

All responses (4)

Answers (0)

Camlee98 8 on at

Like (0)

Report

Re: I want to create an automated flow on Power Automate where it sends an email if an expiry date is near.

Thank you! that seemed to do it 😄 and if I wanted to send email out after its gone through the operations saying something like: "Licence is running out in 7/14 days" how will I go about doing this?
Thank you
Camlee98 8 on at

Like (1)

Report

Re: I want to create an automated flow on Power Automate where it sends an email if an expiry date is near.

Thank you! 😀
abm abm 32,492 Most Valuable Professional on at

Like (2)

Report

Re: I want to create an automated flow on Power Automate where it sends an email if an expiry date is near.

Hi @Camlee98

First you need to find todays date + 7 which is matching with your expiry date column. For that you need to use the below expression

formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')

Then use this under the filter query against the column name. Here below my column name for the filter is LicenseExpiryDate

See below

You can extend the same for 14, 30 and 60 days. Add more compose and change the expression. Then use the GetItems filter query.

You could also add an or operator under the filter query to find 7 or 14 or 30 or 60. For that you need to follow the below steps:

Thanks
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report
Re: I want to create an automated flow on Power Automate where it sends an email if an expiry date is near.

Hi @Camlee98

You need to add days to the current date using an expression and then compare with the expiry date in SharePoint list. Expression that adds 7 days to the current date is:

addDays(utcNow(),7,'yyyy-MM-dd')

Similarly, create expressions for other reminder dates. You need perform logical OR for all 4 clauses in the condition action so that the flow sends notification if any of those becomes true.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.