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:
- why 'PrimitiveValue' or 'StartObject' node was expected error
- Upload file to SharePoint using REST API
- Best way to resolve file path too long exception
- Optimal/preferred way to call 'SP.ClientContext.executeQueryAsync' in SharePoint
- Trouble/How to get the Document Library of my SharePoint Site using GRAPH API
- Sign in as different user in SharePoint 2013
- obtain item-id for microsoft graph api
- Power apps - Multiple Sharepoint lists combine as collection and display in one gallery
- SharePoint REST API getFolderByServerRelativeUrl Returns Nothing
- System.IdentityModel.Tokens.Jwt not found
- Microsoft Graph API and SharePoint files permissions
- How to programmatically download a file from a synced SharePoint directory in Windows?
- Using R to connect to a sharepoint list
- Sharepoint permissions to folders using powershell pnp
- Add additional site page library to SharePoint
- Attaching files from SharePoint uses %20 for spaces in filenames
- Accessing SharePoint Files via API Results in 'AudienceUriValidationFailedException'
- Granting permissions to upload a file to sharepoint using PnP Powershell - 401 Unauthorized
- I can't get the folders from my sharepoint site, how can i resolve this?
- How can I detect if a document is successfully rendered in Office Online Server using PowerShell?
- How to upload files from Jenkins to SharePoint: REST API or OneDrive sync?
- 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