How to create a number field with prefix (ex: 00001) that increments whenever a document is added in SharePoint Online?
I created a calculated column and concatenated the id with a prefix, but it didn't work as expected. The reason was that whenever i upload a file, the formula in calculated field that contains the ID with the prefix is executed, then SharePoint creates the ID. So, the ID is being calculated as empty and only the prefix is showing.
- What I used:
=CONCATENATE(REPT("0",MAX(0,5-LEN(ID))),ID)
What i would like to create is a number field with a prefix (ex: 00001) that increments whenever a document is added in SharePoint Online. In other words, it's like the ID column in a list but with a prefix of five digits.
Therefore, is there any solution for this problem?
Thank you 😁.
Using the calculate column formula, when creating an new item, the ID column and the calculate column are created at the same time, so the value of the ID column cannot be obtained, so the calculate column will be displayed as 0.
But you can solve this problem by creating a flow.
Please refer to the screenshot below:
- Unable to authenticate SharePoint REST or CSOM calls from .NET Core
- How to setup a connection to Sharepoint with enterprise app and client secret
- Power Automate Send an HTTP request to SharePoint returns BadGateway error when creating a Lookup field
- Word file from SharePoint corrupted when sent via Outlook
- Copy “latest files” from source to Sharepoint using KNIME
- Why does SharePoint JavaScript define a function named “ULSTYE” and a label for an empty statement with the same name?
- File upload to SharePoint is not working and is not throwing any errors
- Loading ETag property when retrieve items as a stream in SharePoint
- How to subscribe to updates to the root drive of a SharePoint Site using Microsoft Graph
- Powerapps Form does not map correctly fields
- Attempting to set DisableCustomAppAuthentication to false for Azure not working from Powershell
- troubleshoot display SharePoint columns from Infopath calculated fields
- can't display error messages with customErrors=Off in SharePoint 2010
- Accessing Excel file from Sharepoint with R
- SharePoint REST API returns invalidRequest apiNotFound when registering Container Type
- Getting two acces tokens using single login prompt for sharpoint api and graph api
- How to Download file from Sharepoint to local drive using VBA in an Excel Macro
- Azure Event Grid Graph API SharePoint Event info useful?
- obtain item-id for microsoft graph api
- Calling azure function from spfx webpart result 401 Unauthorized
- How to use .HTMLBody to hyperlink a cell value?
- How do I interpret error codes from FrontPage Extensions?
- APIs and Data storage - Microsoft / Server
- How to write the first 4 letters of the company name of the person who created a new item in a Sharepoint list using PowerAutomate
- ASP.net page without a code behind
- Using Power Automate to save emails in SharePoint location based on List Entries
- sharepoint powershell - Exception calling "ExecuteQuery" with "0" argument(s): "The underlying connection was closed:"
- Upload a file in C# Asp.Net Core to Sharepoint/OneDrive using Microsoft Graph without user interaction
- In Power Automate Parse JSON step I get the errors "missing required properties"
- SharePoint2013 - Javascript - Pagination in client side- Using listitemcollectionposition