Hi Guys, i need help in creating automated email flow when the date is close to 0-7 days

Anonymous
2022-08-24T17:17:48.063+00:00

Hi Guys, i need help in creating automated email flow when the date is close to 0-7 days

I have created a recurrence flow with condition:

Is less than or equal to	 formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')  

This flow actually trigger the emails that is less than 0 days as well

so i created a new flow with condition:

AND
is greater than utcNow()
Is less than addDays(utcNow(), 7)

This flow is not triggering the emails.

Need help.

Attached snap shot of the flow.
234603-forecast-begin-date.png

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,297 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,258 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,596 questions
0 comments No comments
{count} votes

Accepted answer
  1. Renjie Sun-MSFT 2,856 Reputation points Microsoft Employee
    2022-08-25T08:20:54.73+00:00

    Dear @Anonymous ,

    Thank you for post in our forum.

    1.Per my test, the flow run successfully and create email automatically when the date is close to 0-7 days.
    234823-image.png

    2.Test list:
    ‘meeting day’ is a date column. My test date is 8/25/2022.
    Three of items meet the conditions.

    234750-image.png
    3.Test result:
    234832-image.png

    Hope that helps you a little

    Should you have any questions or concerns, please do feel free to contact me.

    Yours sincerely,
    Renjie Sun


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 additional answer

Sort by: Most helpful
  1. Sreeju Nair 12,176 Reputation points
    2022-08-24T17:25:11.41+00:00

    Based on your query, I can see the difference between the working sample and the non working sample is the use of formatDateTime. Try the formatDateTime with the greater than condition and see whether it works.

    Is greater than formatDateTime(utcNow(),'yyyy-MM-dd')

    Hope this helps