Forum Discussion

Copper Contributor

Dec 14, 2021

Autofill columns in List

Hi how can I make that when I create a new Item in a List, the OrderingNr. field is automatically filled with the number that comes after the last entry? Many thanks in advance for your help

Microsoft Flow

PowerApps

SharePoint

reinerknudsen
Dec 16, 2021
smajic175
Ok, let me see if I get that right.
You created a column "Bestell-Nr." to hold the combined String "BN210-1". Correct?
Do I get it right that you renamed the "ID" column into "Bestellnummer"?
I setup a list as I suppose you did. Here is what I noticed:
I currently entered item 3. You see the formula doesn't work. Even after reloading the list it won't change.

Now I go back into the list settings, open the settings for the column and do nothign else but save it again:
And then this happens:
Don't ask me why. It is really weird.
Tried it again and it won't work again. So I changed the formular, saved the column;changed the formula again and saved it again. And it would work again. That is all but satisfying.

Have you thought of replacing the standard edit form with a PowerApp (Integrate | PowerApps | Integrate Forms). You could add a field there which does the calculation for you with even more options of formating the string. Just a thought.

smajic175

Copper Contributor

reinerknudsen

Hi now I did what you said,

and put in ="BN.210-"&[ID]

still shows this

the brackets [] get lost every time I save and close the settings

reinerknudsen

Copper Contributor

Dec 15, 2021

You realize that you are trying to create a column for type "single line of text", don't you? That'S not what I was talking about. I think you still try to create a column from the fancy UI view which doesn't work for "calculated" columns because they aren't offered as an option here.
Okay, let's try another approach:
From your list select "Add column" and then select "More...". You are now taken to the column creation. (See my screen shot above)
Give your column a name and select "Calculated" and add the formula to the "Formula" field.
Save the column (save button is at the very end of the screen; you might have to scroll.

reinerknudsen
Copper Contributor
Dec 16, 2021
smajic175
Ok, let me see if I get that right.
You created a column "Bestell-Nr." to hold the combined String "BN210-1". Correct?
Do I get it right that you renamed the "ID" column into "Bestellnummer"?
I setup a list as I suppose you did. Here is what I noticed:
I currently entered item 3. You see the formula doesn't work. Even after reloading the list it won't change.

Now I go back into the list settings, open the settings for the column and do nothign else but save it again:
And then this happens:
Don't ask me why. It is really weird.
Tried it again and it won't work again. So I changed the formular, saved the column;changed the formula again and saved it again. And it would work again. That is all but satisfying.

Have you thought of replacing the standard edit form with a PowerApp (Integrate | PowerApps | Integrate Forms). You could add a field there which does the calculation for you with even more options of formating the string. Just a thought.
smajic175
Copper Contributor
Dec 15, 2021
reinerknudsen
I thik you did not get me I did create a new column as Calculated.