Forum Discussion
Formatted column with JSON not exporting text to excel
I have a SP list that I added a formatted column to a view. This column, using JSON, is extracting the email address from the Author object. When you export the view, the email is blank. I know I ...
Using [$Title] internal name directly in JSON can make Excel export with text.
I'm curious what that would look like. Right now, the code is:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "[$Author.email]"
}
So it should be something like:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "Created By.Email"
}
?