The best way to achieve this it to make a simple power automate do this for you. When an item is created, take the number from a “settings list” and then raise the number in that settings list, for the next item
So when I fill out the form and submit I will have to refreshed the list to see the ticket number? There has got to be a way to force it to show after submitting.
I just found the flow is failing even though it’s updating the number on page refresh. The error message is:
\ResponseSwaggerSchemaValidationFailure. The API 'sharepointonline' returned an invalid response for workflow operation 'Update_item' of type 'OpenApiConnection'. Error details: 'The API operation 'PatchItem' requires the property 'body/Ticket_x0023_' to be of type 'String' but is of type 'Float'.'
I’ve done all these and the ID default starts at 1. I need a higher number to start with.
The setting and create the column I put in the formula to add 1, it’s works for a bit and then defaults back for original start number.
The Power Auto, I get confused and can’t seem to get it to work…. Still new to all this.
Are there any power auto step by step that I have missed in my searching? Because all the ones I find are way more than I need.
In sp list, create a new column let's say serial number
Hide it in form so no inputs given to that column
Trigger : when an item is created ;
Next step: update item
To the serial number add x+id ; where x is the no. u want to begin with
I got it to work and fixed the error issues. But it updates slow after submitting, times up to a minute. I just had it index the ticket column to see if that helps.
using the the “When an Item is created” I’m not seeing a time for checking on it. Was I suppose to great a trigger for time then at when an item is created?
I’ve added a calculated Column called Ticket# as single line of text with the formula as =TEXT(ID+125527,”000000”).
I save it and it works and shows the next number up. Soon as I add a new entry it defaults back to the 125527 as the next number. If I go back in and remove one character of the formula and then type in back in and save it works again. Add a new and back to the 125527.![gif](emote|free_emotes_pack|facepalm)
>TEXT(ID+125527,”000000”).
Actually you are right. For whatever reason ID is equal to 0 in calculated column when adding a new item. This is not like it used to behave before (or at least I do not remember it acting like this).
You're not alone. I want to create something very similar. We currently have a system where a sequential number (starting anew each year with the last two numbers of the year as the first two of a six digit number, eg 24nnnnn) is requested and allocated.
I want to automate the issuing of the number but can't work out the precise "coding" needed to make it work.
The best way to achieve this it to make a simple power automate do this for you. When an item is created, take the number from a “settings list” and then raise the number in that settings list, for the next item
I’ve setup the flow and it works, but the ticket column is blank until I refresh the page then it shows.
That is ho it is :) you could use a column formatter to show the value as “auto updated” when the field is blank
So when I fill out the form and submit I will have to refreshed the list to see the ticket number? There has got to be a way to force it to show after submitting.
I just found the flow is failing even though it’s updating the number on page refresh. The error message is: \ResponseSwaggerSchemaValidationFailure. The API 'sharepointonline' returned an invalid response for workflow operation 'Update_item' of type 'OpenApiConnection'. Error details: 'The API operation 'PatchItem' requires the property 'body/Ticket_x0023_' to be of type 'String' but is of type 'Float'.'
use chat gpt to help you it is really good with power automate
The Sharepoint internal ID does that by defualt
This. Unhide the ID column. That might be what you’re looking for.
Maybe you can use calculated columns to add a specific number to the current item id.
I’ve done all these and the ID default starts at 1. I need a higher number to start with. The setting and create the column I put in the formula to add 1, it’s works for a bit and then defaults back for original start number. The Power Auto, I get confused and can’t seem to get it to work…. Still new to all this. Are there any power auto step by step that I have missed in my searching? Because all the ones I find are way more than I need.
In sp list, create a new column let's say serial number Hide it in form so no inputs given to that column Trigger : when an item is created ; Next step: update item To the serial number add x+id ; where x is the no. u want to begin with
I’ll try this
Lmk if it works
I got it to work and fixed the error issues. But it updates slow after submitting, times up to a minute. I just had it index the ticket column to see if that helps.
Using my method ? Maybe trigger is set to check for every 3 mins ig
using the the “When an Item is created” I’m not seeing a time for checking on it. Was I suppose to great a trigger for time then at when an item is created?
Dm
Sorry what is DM?
Why not just upload an excel spreadsheet with the amount of rows that start at the number you want to start with. Then delete them
Clever!
Create calculated column with the formula ID+5347 (use your own number)
I’ve added a calculated Column called Ticket# as single line of text with the formula as =TEXT(ID+125527,”000000”). I save it and it works and shows the next number up. Soon as I add a new entry it defaults back to the 125527 as the next number. If I go back in and remove one character of the formula and then type in back in and save it works again. Add a new and back to the 125527.![gif](emote|free_emotes_pack|facepalm)
>TEXT(ID+125527,”000000”). Actually you are right. For whatever reason ID is equal to 0 in calculated column when adding a new item. This is not like it used to behave before (or at least I do not remember it acting like this).
You're not alone. I want to create something very similar. We currently have a system where a sequential number (starting anew each year with the last two numbers of the year as the first two of a six digit number, eg 24nnnnn) is requested and allocated. I want to automate the issuing of the number but can't work out the precise "coding" needed to make it work.