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.
