I have a SharePoint List. I update each item in the list every morning using the following PowerShell script (because I need a calculated column to update daily):
Microsoft.SharePoint.PowerShell
$spWeb = Get-SPWeb -Identity https://mysite/sites/sitename
$spList = $spWeb.Lists["MyListName"]
$spList.Items | ForEach-Object { $_.Update() }
I also have a Sharepoint Designer Workflow on this list that is set to run when any item is changed. So the expectation is that every morning, when the Powershell script runs, each item is updated, then the workflow runs.
When I run the workflow manually on an item it runs without problems, however when it runs based on the update it results in a Canceled status.
Any ideas what the difference might be - or other suggestions on how to get the workflow to run daily?