SOLVED

How to format a list column to have the numbers in the format "0000"

Copper Contributor

Everything is in the question.


I would like to format a number title column of one of my list to have four digits.

For example "45" will be "0045".

 

Could you help me?

3 Replies
best response confirmed by EiC4733 (Copper Contributor)
Solution

@EiC4733 you can format the column with the following JSON to achieve this:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField <= 9, '000'+'@currentField', (if(@currentField >= 10 && @currentField <= 99,'00'+'@currentField', (if(@currentField >= 1000 ,'@currentField','0'+'@currentField'))"
}

 

1-SP.png

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

 

@EiC4733 You can also use the padStart function to simplify.

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=padStart(toString(@currentField),4,'0')"
}

 

Good Luck!

Don


Please click Mark as Best Response & Like if my post helped you to answer or resolve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

1 best response

Accepted Solutions
best response confirmed by EiC4733 (Copper Contributor)
Solution

@EiC4733 you can format the column with the following JSON to achieve this:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField <= 9, '000'+'@currentField', (if(@currentField >= 10 && @currentField <= 99,'00'+'@currentField', (if(@currentField >= 1000 ,'@currentField','0'+'@currentField'))"
}

 

1-SP.png

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

 

View solution in original post