Forum Discussion

smajic175's avatar
smajic175
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's avatar
    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.

     

reinerknudsen's avatar
reinerknudsen
Copper Contributor
Dec 14, 2021
In SharePoint I use the ID column which comes with every new list and automatically generates an increment by 1 when you create a new entry. You could either use the ID value as is or go and generate a calculated value based on the ID.
The nice thing about the ID column is that the ID stays unique even when you delete items.
  • smajic175's avatar
    smajic175
    Copper Contributor
    Dec 14, 2021
    That I know, but I need the first number to be 2001 and every other should be increased by 1.
    If there is no solution with sharepoint, can you make that with PowerAutomate?
    • reinerknudsen's avatar
      reinerknudsen
      Copper Contributor
      Dec 15, 2021

      smajic175 

      In your SharePoint list create a new column. Choose the "Calculated" as column type.

      In the "Formula" box put 

      ="2001 "&ID

      You could enter basically anything as the string. "&ID" will just attch the value in the ID-column to that string. Hope that helps. 

      • smajic175's avatar
        smajic175
        Copper Contributor
        Dec 15, 2021

        reinerknudsen 

        Thanks I tried and get the following message.

Resources