Hello community,
even I am working with NWF for quite a while this is my first public request. Hopefully someone could help.
I have a SharePoint (on premise) which got a list of projects. Each project has an ID which is based on the year it started (P-StartDate) and a consecutive number: e.g. 18-001, 18-002, 18-003, ... 19-043. Actually it is entered manually but I like a workflow to do this. As far as I know (but I am a "forced-to-develop-myself-but-not-a-fully-skilled-developer"), I could use a collection to count items. The idea I have is to get the workflow to count all existing items with the same year (identified by the first two digits of the existing ProjectNumbers), save that count to a variable, simply add "1" to it and set the field value "ProjectNumber" to the new build string.
Any of you who can explain to me how to configure that? Would really appreciate that. Thank you!
Greetz,
TAA