Forum Discussion
Solved
Formatting Issue
Can someone tell me why the data entered in a field in Forms that looks like this: Is showing in the Sharepoint list like this: April 16, 2024 - 9:00 am - 5:00 pm April 17, 2024 -...
- I ended up fixing this myself. If anyone is interested in the fix, this json worked after switching the column list setting to Plain Text:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=join(@currentField, '\n')",
"style": {
"background-color": {
"operator": "?",
"operands": [
{
"operator": "==",
"operands": [
"@currentField",
"SessionSchedule"
]
},
"",
"#FFF399"
]
}
}
}
I ended up fixing this myself. If anyone is interested in the fix, this json worked after switching the column list setting to Plain Text:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=join(@currentField, '\n')",
"style": {
"background-color": {
"operator": "?",
"operands": [
{
"operator": "==",
"operands": [
"@currentField",
"SessionSchedule"
]
},
"",
"#FFF399"
]
}
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=join(@currentField, '\n')",
"style": {
"background-color": {
"operator": "?",
"operands": [
{
"operator": "==",
"operands": [
"@currentField",
"SessionSchedule"
]
},
"",
"#FFF399"
]
}
}
}