Good Morning All,
I'm hoping someone may be able to help me, I have a simple list:
All of my jobs for 2023 will eventually be on this list. The job number needs to be in the format of YY-00000 as above.
When I add an item, if the list is empty I would like the unique job number to have a 1 at the end automatically.
Then for each item added, I would like it to somehow increment the new job number +1.
So the next item in this list would be 23-00002.
I don't want to rely on the system ID column as I may end up deleting items.
I'm still getting to grips with Power Automate, is there a way I can achieve this?
Many Thanks,
Pete
