Formatting column in sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-911663%22%20slang%3D%22en-US%22%3EFormatting%20column%20in%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911663%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'm%20building%20an%20applications%20where%20I%20want%20to%20add%20stuff%20to%20a%20sharepoint%20list.%20In%20one%20of%20the%20columns%20it%20will%20have%20information%20that%20ends%20with%20a%20%23%20and%20a%20code.%20Like%20%23ABD.%20This%20code%20Represents%20a%20country%20or%20rather%20a%20keyboard%20language%20setting.%20In%20this%20case%20German.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20translate%20this%20code%20into%20a%20language%20setting.%20Is%20this%20possible%20with%20column%20formulas%20in%20a%20sharepoint%20list%20to%20do%20this%3F%20I%20need%20Two%20columns.%20One%20where%20the%20code%20resides%20and%20one%20that%20show%20the%20language%20setting.%20Like%20the%20table%20below.%20I%20only%20get%20the%20language%20code%20from%20the%20application.%20It's%20through%20a%20barcode%20scanner.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CSTRONG%3ELanguage%20code%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3ELanguage%20Setting%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23ABD%3C%2FTD%3E%3CTD%3EGerman%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23ABA%3C%2FTD%3E%3CTD%3EUS%20(English)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%23ABY%3C%2FTD%3E%3CTD%3EDanish%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-911663%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911687%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20column%20in%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911687%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425468%22%20target%3D%22_blank%22%3E%40PeterMattsson%3C%2FA%3E%26nbsp%3Bhave%20you%20looked%20at%20this%20samples%3F%20I%20cannot%20think%20of%20a%20exact%20solution%20but%20check%20references%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fcolumn-samples%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fcolumn-samples%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911688%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20column%20in%20sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410289%22%20target%3D%22_blank%22%3E%40SinhaKislay%3C%2FA%3E%2C%20wow!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%20I%20will%20look%20into%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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, wow!

 

Thank you very much. I will look into that.

 

Cheers,

Peter