Within Sharepoint, I would like to create a unique ID that resets the count every month and by service type code. So if 2 requests are made within the month of March for the same service and an additional one made in April - the April request will count back to '01'. If 2 different service requests are made within the same month - both request counts will end in '01'. I need a "counter" to append at the end of the following taxonomy:
yr/mm | service type code | counter
1904 123 01
1904 123 02
1905 123 01
1905 456 01
1905 456 02
1905 789 01
Basically, the counter resets by yr/mm and by type of service code and combined there can't be duplicates of the final unique ID - '190512301' for example. I appreciate any insight to this. I've scoured several articles but I'm having a hard time applying these 2 conditions to program a "counter".
@vk1 Hi there!
This one is fun, thanks for bringing it up!
I am especially sharing my usual disclaimer on this one: There are likely more elegant ways to do this, but this is the hammer I have for this particular nail-looking-thing.
Going to just do theory until you agree on the proof of concept, let me know what you think and we can build a practical model if it sounds like it will fit your situation.
I'll pretend that you want to update the ticket number immediately after the row is created in the Sharepoint list, if that's not the case, we can adjust.
What do you think? I'm sure it will need some tuning. I'm new.
I am new to Flow and interested in some instructions on how to something similar to this.
For me, I need to create a "Case" which is in format YYMM-(sequential number) within a list called Case in SharePoint online with the sequential number re-starting for each month so
Then, once that is created there would be "Claim(s)" created against the "Case" and these would be within a list called Claims in SharePoint online with format 1909-1-1, 1909-1-2, 1910-9999-1, 1910-9999-2, etc. The Case will be selected within the Claim so that detail will flow into the Claims list as Case ID.
I am guessing the "Claims" is a repeat of the "Case" one to add a new sequential number to another item.