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:
https://www.youtube.com/watch?v=nNxD82KiUhQ
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.
$wfis=$wfm.GetWorkflowInstanceService()
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)
}
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).
