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 can fix this for future records by populating the column via custom form, but how do I populate the column so that the email shows up in the export to excel?
2 Replies
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"
}
?
