Announcements
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.
@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")
this is the best answer vs the one I saw using Power Automate!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 296 Most Valuable Professional
11manish 224
Valantis 181
