You’re offline. This is a read only version of the page.
Description of the Problem: I am trying to create a Power Automate flow that sends email notifications for software expirations based on a table in an Excel sheet. The notifications should be categorized by 30, 60, and 90 days before expiry and for past expiration dates. I want to use Group IDs to send emails to the appropriate contacts without overlaps.
Summary of the Setup:
Excel Table Structure:
Columns: Software_Name, Last_Renewed_Date, Expiration_Date, Contact, Group ID
Desired Email Notification Structure:
30 Days - Subject: "URGENT"
60 Days - Subject: "WARNING"
90 Days - Subject: "RENEW IT QUICK
Consider the following data from an Excel sheet:
|
Software_Name |
Expiration_Date |
Contact |
Group ID |
|---|---|---|---|
|
SW1 |
2024-09-30 |
123@abc.com |
1 |
|
SW2 |
2024-10-04 |
123@abc.com |
1 |
|
SW3 |
2024-11-24 |
456@xyz.com |
2 |
|
SW4 |
2024-12-01 |
456@xyz.com |
2 |
In this example:
- expiration email of sw1 and sw2 should go to 123@abc.com, and for sw3 and sw4 it should go to 456@xyz.com
this should work for n number of group ID's
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (