none
SharePoint Designer - Send email when a date is entered in date field

    Question

  • I'm probably missing something obvious, but this is driving me crazy. I have a several workflow functions I need for one list.... starting with an email going to a reviewer when a new item is submitted... then basically there are about 5 date fields, and when a date is entered in the field, and email goes out. So, by default the date fields are all empty, and as the dates are entered, the requestor will get an email. I cannot for the life of me figure out how to add that functionality to a workflow. I'm kind of a newbie, I know how to send an email when a new item is submitted, and a few other basic steps, but having an email sent when a field is populated isn't something I've ever done. Hopefully I've explained what I'm trying to do well enough, I can't find anything searching the internet!


    alliswell0520

    Monday, February 6, 2017 9:30 PM

All replies

  • Hi,

    Please check the options below

    https://social.technet.microsoft.com/Forums/office/en-US/81cf2e9f-278e-4b8c-8986-fb9e72b8a8fc/how-do-i-send-an-email-when-a-specified-date-is-reached?forum=sharepointcustomizationprevious


    Please remember to click Mark as Answer on the answer if it helps you

    Monday, February 6, 2017 9:58 PM
  • Hello, you cannot achieve this if you are using SharePoint Designer workflows, this is a case of Event reciever which can be written using Event reciever when an item is added and you check whether a particular column has valeu.

    If you are in on premise farm you and can develop Add-ins then you can write Remote Event recievers

    https://msdn.microsoft.com/en-us/library/office/jj220043.aspx

    or you can go for a full trust code solution and write event reciever

    http://www.c-sharpcorner.com/uploadfile/5b1f04/create-a-custom-list-level-event-receiver-for-item-added-in/

    If you are using SharePoint Online maybe you can try Microsoft Flow

    https://synkventures.com/2016/12/18/microsoft-flow-create-from-blank/

    If you still want to use SP Designer worklfow there is one way but I will not recommend it, you can write a workflow which runs everytime there is a change in item and check if there is a value in date field if yes send an email and set a flag which is dummy column not visible to end users so that you don't send email next time when workflow runs as you don't know if value has been added this time or last time.

    Thanks

    Kislay

    If this has answered your query please mark reply as answer

    Monday, February 6, 2017 10:03 PM
  • Hi

    you need to use a condition if "empty" and inside that condition insert the send email step

    Please check ho to set the condition

    https://bhandariasb.wordpress.com/2015/06/29/check-if-a-date-field-is-blank-in-a-sharepoint-designer-workflow/


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Monday, February 6, 2017 10:35 PM
  • Hi alliswell0520,

    How are things going there on this sending emails question?

    Do these replies have the information which you want to get?

    Best Regards,

    Linda Zhang


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Friday, February 10, 2017 9:15 AM
    Moderator