I would very much appreciate any help, I have been working on this for weeks but can only find online examples for sharepoint 2010. It doesn't help that I am not familiar with building collections.
I currently have a workflow running on each list item when it is created or modified. If the item isn't updated within a certain timeframe, the workflow starts sending the user listed in one of the columns a weekly reminder with a link to the item.
I am trying to build a site workflow for my sharepoint site that would send a single reminder to each user if they have overdue items, but have been unsuccessful. If that email listed the overdue items with hyperlinks as it currently does for the single item, even better. The issue is that previously users would only get a few emails, but now we have users that would have upwards of 50 items and that is a LOT of emails.
I have attached the list workflow that I have been using successfully.
Hi Robin Angell,
Create a site workflow with the below actions.
Hi Lakshmi Narayana C,
I was thrilled to see your thorough answer today. I was able to assemble the steps, but cannot get this to work. I get a suspended workflow with an error as follows:
RequestorId: 3d3f38a1-346d-b98f-0000-000000000000. Details: An unhandled exception occurred during the execution of the workflow instance. Exception details: System.ArgumentNullException: Value cannot be null. Parameter name: String at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Microsoft.Activities.Expressions.ParseNumber`1.Execute(CodeActivityContext context) at System.Activities.CodeActivity`1.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager) at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation) Exception from activity ParseNumber<Int32> ToString DynamicActivity<Guid> DynamicActivity<DateTime> Set Variable Set Workflow Variable ChildActivityStep Sequence ForEachKeyValuePairStep ForEachSequence If DynamicValue Is Not Empty And Number of Items Greater Than 0 For Each Sequence Flowchart Test Environment workflow.WorkflowXaml_c14f9b7d_ecba_49c5_81e1_b0d1471291d2
I tried to remove the date calculation step, since mine appeared like this:
But I get the same error as above.
I wonder if the problem is with my query (see below)?
I will try to go to the original post and attach the site workflow I made based on your instructions.
Would this workflow generate a single item with many list urls, or would I need to use build string to list all of the items for one user somehow?
Hi Lakshmi Narayana C
I was unable to get this solution to work, but ended up using the Send Grouped Notification Site Workflow for O365 developed by Giacomo Gelosi. As several of the steps seem similar, I am sure my lack of expertise was the major contributing factor to not getting this working. My version of Nintex site workflows does not seem to have some of the functionalities you are using, such as calculated date. I wanted to thank you again for your help, and I am sure having this all posted will help others with my issue.
Thank you so much,