web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I want to create an au...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 8

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!

Screenshot 2024-04-05 152325.png
Categories:
  • Manish Solanki Profile Picture
    15,169 Moderator on at

    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.

  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    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
     

    image.png

     

    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:

     

    image.png

     

     Thanks

  • Camlee98 Profile Picture
    8 on at

    Thank you! 😀

  • Camlee98 Profile Picture
    8 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard