Forum Discussion

_J-K_'s avatar
_J-K_
Copper Contributor
May 26, 2023
Solved

SharePoint JSON Formatting using split and the resulting array

Hello, at https://learn.microsoft.com/de-de/sharepoint/dev/declarative-customization/formatting-syntax-reference I did find this for the split operator:   split: divides the given string into a...
Array
JSON formatting
SharePoint Online
split
  • Cedricbob's avatar
    Cedricbob
    Jan 11, 2024

    _J-K_ 

     

    I couldn't find a way to access the resulting array either.

     

    Like @suvi-15 pointed you can use the substring instead. But in this case, accessing another field requires this markup [$ColumnName] and not the @ColumnName

     

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "=substring([$Supervisor.email], 0, indexOf([$Supervisor.email],'@'))"
}

     

    Additional note: I couldn't access a field that has a space in it.
    ex.:
    [$Supervisor Info.email] doesn't work.
    [$SupervisorInfo.email] works.

suvi-15's avatar
suvi-15
Brass Contributor
May 26, 2023

_J-K_  try to use 

"=substring(@currentField.email, 0, indexOf(@currentField.email,'@'))" and subsequently for other part and instead of putting textContent you can add as much as elemType in children attribute something like this :

"children": [
{
"elmType": "span",
"txtContent": "=substring(@currentField.email, 0, indexOf(@currentField.email,'@'))"
},
{
"elmType": "span",
"txtContent": "=substring(@currentField.email, indexOf(@currentField.email,'@'), length(@currentField.email))"

}
]

 

I haven't tested but you get more info from this link https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-syntax-reference

 

 

Br,

Suvi

 

Please free to ask question, if this solves your purpose mark this as answered. 

 

Resources