Send email notifications when Go Live date is due within 7 days on SharePoint list

Harry N Nomikos 1,246 Reputation points
2021-10-01T07:39:53.797+00:00

Hi Team

I'm trying to see if it's possible to have an email notification target a user "Change Manager" (which is a field on my list) when their project is due within the next 7 days . I don't have access to script editor or power automate, so I'm quite limited with what I can do.

I can set up some basic rules, but that's pretty much it.

Any help will be greatly appreciated.

Thanks
Harry

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,614 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Wendy Li_MSFT 1,711 Reputation points Microsoft Vendor
    2021-10-04T08:20:00.22+00:00

    @Harry N Nomikos For this issue, it is better to use Power Automate to achieve it. However, considering you are limited to use Script Editor or Power Automate, you can check if you can use SharePoint 2013 workflow in your tenant. If yes, you can consider using SharePoint 2013 workflow to do that.

    The following steps for your reference:

    1. Open your site using SharePoint Designer 2013 and create a SharePoint 2013 workflow for your list
    2. Design your workflow like the following:
      137258-untitled.png
    3. Set the workflow automatically start when an item is created.
      137372-image.png
      Note: please remember to change your email content as your needs.
    4. Publish the workflow.

    Please have a try and let's know the result.

    -------------------------------

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.