Column formatting forEach property does not support spaces

[jensotto]

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

Declarative list formatting

Developer environment

Windows

What browser(s) / client(s) have you tested

• 💥 Internet Explorer
• 💥 Microsoft Edge
• 💥 Google Chrome
• 💥 FireFox
• 💥 Safari
• mobile (iOS/iPadOS)
• mobile (Android)
• not applicable
• other (enter in the "Additional environment details" area below)

Additional environment details

• Edge 112.0.1722.39

Describe the bug / error

Its not possible to use operators in the forEach property of column formatting.
The following definition fails with the error message:Failure: split(replaceAll(@currentField,'; is not an array, array expected in the expression value in split(replaceAll(@currentField,'; ',';'),';')

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "debugMode": true,
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "forEach": "value in split(replaceAll(@currentField,'; ',';'),';')",
      "txtContent": "='*'+[$value]"
    }
  ]
}

Content in the field is a semicolon separated list: 1; 2; 3; 4

Spaces can be used in other properties like for example txtContent.

Steps to reproduce

1. Add a new list to SharePoint
2. Add the content "1; 2; 3; 4" to the title field (note the spaces after each semicolon)
3. Add the column formatting from the bug description above.
4. Rendering fails.
5. Remove the space in the second replaceAll argument.
6. Rendering works, but there is a space in front of every item except the first one.

Expected behavior

It should be possible to use spaces in operators in the forEach porperty

Thank you for reporting this issue. We will be triaging your incoming issue as soon as possible.

[waholayo]

Please add support of line break (\n, \r) and tab (\t) characters to the operator of forEach.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "debugMode": true,
  "elmType": "div",
  "__txtContent": "=replaceAll(@currentField,'\n',';')",
  "__txtContent": "=split(replaceAll(@currentField,'\n',';'),';')",
  "children": [
    {
      "elmType": "div",
      "forEach": "__INTERNAL__ in split(replaceAll(@currentField,'\n',';'),';')",
      "txtContent": "[$__INTERNAL__]"
    }
  ]
}

@currentField is a multiple line of text column, where each line represents a list item, e.g.:

item 1
item 2
item 3
item 4

The above code also gives error:
Failure: split(replaceAll(@currentField,' is not an array, array expected in the expression __INTERNAL__ in split(replaceAll(@currentField,' ',';'),';')

[djbrum]

we have the same issue

[adriangoszczynski]

I got info from Microsoft CSA, that foreach expect array and it can be passed by expression, but split and other methods they are not actually expressions but functions, that is why it is not working.

[waholayo]

There is a workaround if \s, \n, \r, \t is needed in the forEach expression:

1. Create a Calculated Column [varSpace], [varCRLF], [varTab] with formula

=" "

="
"

="	"

2. Then use these Calculated Columns as a variable in the List or View formatting JSON:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "forEach": "__INTERNAL__ in split(@currentField,[$varSpace])",
      "txtContent": "[$__INTERNAL__]"
    }
  ]
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "div",
      "forEach": "__INTERNAL__ in split(@currentField,substring([$varCRLF],1,2)",
      "txtContent": "[$__INTERNAL__]"
    }
  ]
}

[jensotto]

I got info from Microsoft CSA, that foreach expect array and it can be passed by expression, but split and other methods they are not actually expressions but functions, that is why it is not working.

This sounds like a made up diversion. Functions (and more) are used in expressions.

The expression in my example works just fine as long as there are no spaces in it (the space can be anywhere in the expression). Split retuns an array, and an expression using Split will therefore satisfy Microsoft's documented requirement for using foreach.

I would not take Microsoft's claim in this matter as a valid reason for this to not work.

[adriangoszczynski]

He explained, that expressions are processed based runtime and functions calculate something during processing, this is difference. That is why forEach allows expressions only. More about expressions see here https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-syntax-reference#expressions.

And he also said, that the fact it works without spaces it is rather coincidance than prove that something is wrong with processing.

This topic was reported to the MS Support and they (supposedly a product group) didn't want to take it.

[jensotto]

He explained, that expressions are processed based runtime and functions calculate something during processing, this is difference. That is why forEach allows expressions only. More about expressions see here https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-syntax-reference#expressions.

And he also said, that the fact it works without spaces it is rather coincidance than prove that something is wrong with processing.

This topic was reported to the MS Support and they (supposedly a product group) didn't want to take it.

What are expressions If they are not made up by functions? Microsoft states in the documentation that you refer too that split and other operators are supported in foreach as operators are the building blocks of expressions.
My theory is that the value of the forEach property internally is processed by splitting on spaces. First section is the iterator variable, second is the mandatory word 'in', and the third is the expression or fieldname. This fits with the issue reported where if the expression contains a space it fails, because only part of the expression is considered.

Do you have an example of a "valid" expression according to Microsoft?

[adriangoszczynski]

I didn't find statement that forEach's value can be split or other function but can be multi-value field or an expression that returns an array. They states that function and expression are not the same and split and other operators are functions not expressions.

I was only directed to the article above where you will find examples of expressions.

[jensotto]

The article does not mention the word function one single time. I never said functions and expression are the same. Expressions contains functions. Split is a function/operator, and is used in an expression. Split returns an array. Therefore (in my example) the expression returns an array. This then satisfies the documented requirement of an forEach property value since the expression returns a value.
Unless I have missed something I'm pretty sure Microsoft's reply to you is wrong.

In addition the workaround provided by @waholayo further strengthen my case as it removes the spaces from the expression written in the forEach property value. It proves that split is working just fine in the expression as long as it does not contain any spaces.

@adriangoszczynski Please provide an expression that you believe is valid for use in forEach. I'm pretty sure that if you can write that expression functionally equivalent with and without a space, then it will fail when you use the one with a space in it.