Forum Discussion

PeterMattsson's avatar
PeterMattsson
Copper Contributor
Oct 14, 2019

Formatting column in sharepoint list

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 codeLanguage Setting
#ABDGerman
#ABAUS (English)
#ABYDanish

 

Thank you,

Peter

2 Replies

  • SinhaKislay's avatar
    SinhaKislay
    Iron Contributor

    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

Resources