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.

     

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

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

      smajic175 

      From your list click the gear icon (left upper right in the header bar) and select "List settings".
      You will see the list of your columns. Below the list you see "Create column"; click that.
      Now enter the name of your new column and check "Calculated".

      Then find the "Formula" box and enter your string and attach "&[ID]" to it.

       

      Let me know if that works.

       

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

        reinerknudsen 

        Hi I tried and put in following ="2100"+ID

        and it works partially, since when I add a new Item to the List it shows following, see the last Item added, it shows then 2100 instead of 2342

Resources