Sharepoint 2013 email workflow all but one field change

Lenea Deshields 1 Reputation point
2022-12-03T18:38:58.797+00:00

I’m attempting to set up a workflow in sharepoint 2013 or 2010 that will allow an automatic email to be sent when any of the fields except one on the list/form is updated.

Microsoft 365 and Office | SharePoint | For business | Windows
{count} votes

1 answer

Sort by: Most helpful
  1. Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff
    2022-12-05T09:17:07.303+00:00

    Hi @Lenea Deshields ,
    We are unable to set up a workflow directly in sharepoint 2013 or 2010 that will allow an automatic email to be sent when any of the fields except one on the list/form is updated. But I have researched another workaround that can achieve your needs.
    The field I don't want to trigger the email(Called column1 during my test).
    Here are steps:
    1.Create a column (called column2 in my test) with the same content as column1 using powershell, as a workflow trigger condition.
    Powershell code:

    $web = Get-SPWeb http://sp16:22074/sites/xyza   
    $listName = "list1"   
    
    #Get the Contacts List  
    $List = $web.Lists[$listName]  
    
    #Get All Items by update its title  
    $ListItems = $List.items  
    
    #Iterate through each item  
    foreach($Item in $ListItems)  
    {  
        $update=$item["column1"]   
        $item["column2"] = $update  
    
        #Update the item  
        $item.Update()  
    }  
    

    267162-image.png
    2.Create a workflow in SharePoint Designer 2013.
    267142-image.png
    My test environment is finally realized: when I update the value of column1, the email will not be triggered, and the email will be sent in other cases.
    After the setting is complete, column2 can be hidden to prevent others from updating it by mistake.
    267172-image.png


    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.