I'm using SharePoint 2013 online. I've created one List in which one Column is Choice (Completed, Pending) column named Status. For all Item If Status is Pending, weekly one mail should fire with List of only Pending Items as a alert to a person/group.

I think this is possible through SharePoint Designer 2013 but not sure how. Please provide steps if you have any idea.


You can create a condition to check if the 'Status' is 'Pending' and send a e-mail with a workflow. See:


You can use this powershell and create a task of windows to run the workflow weekly

$sourceWebURL = '<URL>'
$sourceListName = '<List Name>'
$TargetWorkflow = '<Workflow Name>'
$spSourceWeb = Get-SPWeb $sourceWebURL
$spSourceList = $spSourceWeb.Lists[$sourceListName]
$items = $spSourceList.getItems()

#-- Getting a Workflow manager object to work with.
$wfm = New-object Microsoft.SharePoint.WorkflowServices.WorkflowServicesManager($spSourceweb)
#-- Getting the subscriptions
$sub = $wfm.GetWorkflowSubscriptionService()
#-- Getting the specific workflow within the list of subscriptions on the specific list. (SP2010 associated workflows basically)
$WF = $sub.EnumerateSubscriptionsByList($spSourcelist.ID) | Where-Object {$_.Name -eq "$TargetWorkflow"}
#-- Getting a Workflow instance in order to perform my commands.

Foreach($item in $items){
    #-- Creating the dictionary object I need to parse into StartWorkflow. This could be most other workflow commands.
    $object = New-Object 'system.collections.generic.dictionary[string,object]'
    $object.Add("WorkflowStart", "StartWorkflow");
    $wfis.StartWorkflowOnListItem($WF, $item.ID, $object)
  • Thanks Diego, Here I'm need help how to fire consolidated single mail weekly basis for only Pending Items. For this scenario I'm getting stuck. Please provide the steps or link if you have some idea about this. Thanks. – user3760253 Oct 29 '14 at 16:40
  • Thanks Diego, But I've only access for SP Designer as I'm using Office 365 small. – user3760253 Oct 30 '14 at 6:37

Would it work for you to create a View that shows the pending items and then create an Alert based on that view that will send weekly emails?


Based on your comments, I am under the impression that you are trying to create a View using '[PO Date] is equal to 0'. If this is the case, you have a lot to learn about SharePoint I am afraid.

In any case, the filter should probably be '[Status] is equal to Pending' (or something to that effect). I do not see why you included the PO date in the filter (and based on your other question, the calculated field will eventually include the requirement for the PO Date too).

After you create the view, you will need to create the alert based on this view (Send Alerts for these Changes) and opt to receive weekly alert (When to Send Alerts).

  • Sorry the column type is Calculated not choice column. I've column "Name = Order Status","Type = Calculated" & Data Type = "Date and Time". I've given this Condition in the column:- =IF(NOT([PO Date]=0),"ORDERED","NOT ORDERED"). This is not a choice column as per your provided steps. I'm getting error while create the view "Filter Value is not in a supported date format". Please advice. – user3760253 Oct 30 '14 at 6:17
  • In your provided link the mail will fire when someone will change the item. But here in my requirement mail will fire automatic for all items which showing in "Pending" status as a alert to a person/group weekly basis. Hope this is clear. – user3760253 Oct 30 '14 at 7:03
  • It doesn't matter if it is a choice field or not. Can you create the view based on the criteria you want? Moreover, if you set the alert to send a weekly summary it should get what you want. In any case, this is a straight out-of-the-box implementation. It may not be exactly what you need, but it could be close enough. – yandr Oct 30 '14 at 7:31
  • while creating view its showing error "Filter Value is not in a supported date format" however I follow the same steps which is provided in your above link – user3760253 Oct 30 '14 at 7:51
  • Yandr - I've column "Name = Order Status","Type = Calculated" & Data Type = "Date and Time". I've given this Condition in the formula:- =IF(NOT([PO Date]=0),"ORDERED","NOT ORDERED"). I'm trying to create view for this column but its getting error while create the view "Filter Value is not in a supported date format". Same error I'm getting for column "Name = Status","Type = Calculated" & Data Type = "Number". I've given this Condition in the formula:- =IF([PO Date]="","",IF(NOT([Balance Qty]=0),"OPEN","CLOSED")) – user3760253 Nov 1 '14 at 12:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.