Formatting column in sharepoint list

[PeterMattsson]

Hello,

I'm building an applications where I want to add stuff to a sharepoint list. In one of the columns it will have information that ends with a # and a code. Like #ABD. This code Represents a country or rather a keyboard language setting. In this case German.

I need to be able to translate this code into a language setting. Is this possible with column formulas in a sharepoint list to do this? I need Two columns. One where the code resides and one that show the language setting. Like the table below. I only get the language code from the application. It's through a barcode scanner.

Language code	Language Setting
#ABD	German
#ABA	US (English)
#ABY	Danish

Thank you,

Peter

[#2]

@PeterMattsson have you looked at this samples? I cannot think of a exact solution but check references

https://github.com/SharePoint/sp-dev-list-formatting/tree/master/column-samples

https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

[#3]

@SinhaKislay, wow!

Thank you very much. I will look into that.

Cheers,

Peter