Send email using Sharepoint Item expiration dates

[EOAMJoeH2727]

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!

[SudeepGhatakNZ · Accepted solution]

Here you go

Sending reminder emails 30, 60, 90 days before expiration - Powering your Apps (sudeepghatak.com)

[EOAMJoeH2727 · Accepted solution]

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.

[EOAMJoeH2727]

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

[SudeepGhatakNZ · Accepted solution]

Go to Power Automate settings and turn the experimental mode on

[EOAMJoeH2727]

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?

[SudeepGhatakNZ]

Are you able to post screenshot of your flow?

[EOAMJoeH2727]

 

Here is a screenshot of my flow

[SudeepGhatakNZ]

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?

[EOAMJoeH2727]

Yes, that scenario that is occurring in the above flow. I apricate you for clarifying why that is happening.