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

reinerknudsen 

I thik you did not get me I did create a new column as Calculated.

 

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

 

Resources