I have created a simple list workflow (SharePoint Online) which emails a user, informing them a Document's Target Closure Date has been reached. The workflow works fine when started manually.
I want to trigger the workflow only when Target Closure Date matches today's date.
The best solution seemed to be to use a Retention Policy. So I went to:
> Library Settings
> Information Management Policy settings
> Document content type
> ticked 'Enable Retention'
> Time Period: Target Closure Date + 0 days
> Action: Start the relevant workflow.
This worked only on two occasions - both were Saturday mornings, at 3.30am and 4.30am. I can see in this MS article the Expiration Policy timer job only runs weekly on SharePoint 2013, so can anyone confirm that the schedule is the same in SharePoint Online?
If so, is there any way in SharePoint Online I can trigger a workflow when a date is reached?
Thanks for your help,