You’re offline. This is a read only version of the page.
I am working on building a flow that will automatically send an Outlook email based on items in my office’s SharePoint site. Our office worked with our IT(AIM) department to create a SharePoint site to house all of the data for our office’s subscriptions, vendors, and office staff certifications. Now that the SharePoint site is complete, we want to use Power Automate to automatically send a dynamic email 90 days, 60 days, 30 days, and 15 days from our expiration dates.
If someone could provide a flow template or instruction on how to build a flow, that could accomplish this task. Thanks!
Yes, that scenario that is occurring in the above flow. I apricate you for clarifying why that is happening.
Hi @EOAMJoeH2727 ,
You can expect to receive only one email.
Your item may fall under multiple categories.
For instance, if something is 90 days old, it automatically fulfills the condition of being 30 days old and 60 days old.
Is this the scenario that is occurring?
Here is a screenshot of my flow
Are you able to post screenshot of your flow?
After using the template you provided, I was able to send reminder emails. However, when I ran the flow, I ran into an issue. In my inbox set to receive the reminder emails, I got multiple emails for the same items in my SharePoint list. How can I make it so I only get one email per item?
Go to Power Automate settings and turn the experimental mode on
I am trying to complete the flow Sudeep Ghatak suggested and for some reason I am not getting the option to compare the outputs of the compose actions against renewal date column in my SharePoint site. Is there an expression I need to enter into the filter query type box? Or maybe my SharePoint sites is not properly setup and I need to adjust the columns to complete this flow. Please advise.
Thank you
Thank you, Sudeep Ghatak the flow you shared would help accomplish my goal. However, when I attempted to recreate the flow, I could not figure out how to "compose - today" and compute the dates that occurred 30, 60, and 90 days prior to today.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
