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:

Building flows

Screenshot 2024-0...

I have the same question (0)

All responses (4)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
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.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No
Camlee98 8 on at

Like (1)

Report

Thank you! 😀

Was this reply helpful? Yes No
Camlee98 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No