Sharepoint Lists Concenate text and ID column

Question

Sharepoint Lists Concenate text and ID column

Steve Laird 20

I am creating a risk register on Sharepoint (MS List) and have created a calculated column which I have entered the following formula to put the text RA in front of the automatically generated ID "=CONCATENATE("RA",[ID])". The issue I am having is everytime I create a new item the "RA" text is inserted into the field but the ID number is not present. When I open the column settings the square brackets indicating that is should use the ID column are missing i.e. "=CONCATENATE("RA",ID)".

The data type return is "Single line of text".

I know I could just show the ID column on its own but it would be nice to add the text "RA" in front, is there a way to fix this?

The screenshot shows the column settings before I reinsert the square brackets.

User's image

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hello @Steve Laird

Based on my testing, I think using JSON formatting would be the simplest approach to achieve this.

SharePoint often uses a different internal name for columns behind the scenes, especially when the display name contains spaces. We need to identify the exact internal name for the formatting to work correctly.

Go to the Settings (gear icon) in the top-right corner and select List settings.
Scroll down to the Columns section and click the target column (for example, Risk ID or ID).
Look at the URL in your browser's address bar and press End on your keyboard to jump to the end of the URL.
Note the exact value immediately after Field=. For example, although the display name may be Risk ID, the internal name could be RiskID.

User's image

Next, navigate back to List settings > Risk Number and change the column type from Calculated to Single line of text.

Then apply the JSON formatting shown below. Please make sure to replace RiskID with the exact internal name you identified in the previous step. In your case, you may also want to try replacing it with [$ID] or the internal name that you see after FieldID and see whether that returns the expected result.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "='RA' + [$RiskID]"}

User's image

Please give this a try and let me know if you have any questions or need further assistance.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.