cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DWTKBrook
Resolver I
Resolver I

Send email between 2 dates in a sharepoint list

Hello,

 

I have a requirement where I need to send an email every Monday, so long as that Monday does not fall within a date range defined in a SharePoint list (Start Date & End Date) I have been able to configure the Recurrence trigger but I'm confused at how I configure a condition to accommodate the date range omission.

 

Any Ideas on how I can accomplish this?

DWTKBrook

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
edgonzales
Super User
Super User

@DWTKBrook 

Are you getting a specific row within that SP list?  If so, it might look something like this:

edgonzales_0-1659542469607.png

You might want to adjust the utcnow() to your local timezone, and you definitely want to swap out the <startdate> and <enddate> with the dynamic values from your SP list item.

 

hope that helps.

-Ed

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

 

View solution in original post

2 REPLIES 2
edgonzales
Super User
Super User

@DWTKBrook 

Are you getting a specific row within that SP list?  If so, it might look something like this:

edgonzales_0-1659542469607.png

You might want to adjust the utcnow() to your local timezone, and you definitely want to swap out the <startdate> and <enddate> with the dynamic values from your SP list item.

 

hope that helps.

-Ed

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

 

DWTKBrook
Resolver I
Resolver I

Thank you ED.

 

The goal is it to loop through every row. each row has different start and end date values.

 

DWTKBrook

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,067)