question

David-1742 avatar image
0 Votes"
David-1742 asked JoyZ commented

Convert from decimal(base-10) to alphanumeric(base-36) in Sharepoint 365

I have a need to convert a 6 digit decimal to base36 in SharePoint 365. In my list I have two columns ("Decimal" and "Base"). The column "Decimal" contains two various alphanumeric values and a dash (VG-, KL-, NH-, LO-) with 6 digits following. I need to convert the last 6 digits to base36 will keeping the beginning two alphanumeric digits and dash. This converted value would need to be displayed in column "Base".

I have access to Power Apps, Power Automate, Power BI, Excel.

125782-result.png


office-sharepoint-online
result.png (3.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered JoyZ commented

@David-1742,

Per my research, currently there is no such way to convert number from base-10 to base-36 in SharePoint online list column.

Base function is only available in excel, and there is no similar available function in PowerApps, Calculated column or flow.


If an Answer is helpful, please click "Accept Answer" and upvote it.

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@David-1742,

I’m checking how the things are going on about this issue.

Please feel free to reply if there is any update.

0 Votes 0 ·