web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Add Leading Zeros in S...

Power Apps

Answered

Add Leading Zeros in Sharepoint List Dynamically update

(0) Share

Report

Report

Posted on by jazz1

24

Hello ,

I want to update the SharePoint List column to contain 10 characters long number

for example : 123456 to be 0000123456

and a validation to contain only numbers.

I am willing to use any platform to convert the values.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@jazz1

You can never have leading zeros in a SharePoint number column BUT, you can create a SharePoint calculated field using the formula

=CONCATENATE(REPT("0",MAX(0,10-LEN(yourcolumn))),yourcolumn)

You can display a SharePoint numbers column with leading zeros using the Text() formula in PowerApps and saving it as a single line of text type field in SharePoint

Text(Value(ThisItem.yournumber), "0000000000")

Was this reply helpful? Yes No
LaiCBRE 72 on at

Like
a
(0)

Report
Copy link

Link copied!

this is the best answer vs the one I saw using Power Automate!

Was this reply helpful? Yes No

Join the conversation