Dear Experts,
In my microsoft lists , i really want to format view and also using Json to hide command bar like image as bellow:
1. JSON using to hide Command bar :
2. JSON using format view
This is JSON by text :
1. JSON hide commanf bar
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"commandBarProps": {
"commands": [
{
"key": "automate",
"hide": true
},
{
"key": "export",
"hide": true
},
{
"key": "share",
"hide": true
},
{
"key": "integrate",
"hide": true
}
]
}
}
2. JSON format view
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"additionalEventClass": {
"operator": ":",
"operands": [
{
"operator": "==",
"operands": [
"[$Leave_x0020_type]",
"Annual leave"
]
},
"=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgGreen' , 'sp-css-backgroundColor-BgMintGreen sp-css-color-MintGreenFont')",
{
"operator": ":",
"operands": [
{
"operator": "==",
"operands": [
"[$Leave_x0020_type]",
"Other Leave"
]
},
"=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgOrange' , 'sp-css-backgroundColor-BgPeach sp-css-color-PeachFont')",
{
"operator": ":",
"operands": [
{
"operator": "==",
"operands": [
"[$Leave_x0020_type]",
"Business Trip"
]
},
"=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgTeal' , 'sp-css-backgroundColor-BgCyan sp-css-color-CyanFont')+' sp-field-fontSizeSmall'",
""
]
}
]
}
]
}
}
What i need to do is combined both into one JSON to format view and hide command bar as well.
Cause i don't have knowledge about coding 🙂
Please help me, thanks you all !
@CongDuong I run into these small-but-impactful issues sometimes when editing directly in the browser myself. When they happen, I copy and paste the view formatting into a code editor (VS Code in my case), which shows syntax errors where they occur rather than SharePoint's vague Please enter valid view-formatting JSON message. Here's a missing comma, for instance:
While you're at it, I see you're using the default SP interface, so I would also recommend this lovely Chrome/Edge extension:
https://github.com/pnp/sp-formatter
It doesn't highlight inline errors like VS Code, but it does update the formatting preview in real time, which can help identify trouble spots.
Dear @Expiscornovus ,
Thank you for helping soon,
I try to using your JSON, Unbelievable !!!!! It's working very well.
One again , thank you so much !
Hi @CongDuong,
This question is related to SharePoint Online list and column formatting, not really a Power Automate type of question.
That being said, I think you need to remove the closing curly bracket just before the additionalEventClass and add one missing comma character.
Try the json below:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"commandBarProps": {
"commands": [
{
"key": "automate",
"hide": true
},
{
"key": "export",
"hide": true
},
{
"key": "share",
"hide": true
},
{
"key": "integrate",
"hide": true
}
]
},
"additionalEventClass": {
"operator": ":",
"operands": [
{
"operator": "==",
"operands": [
"[$Leave_x0020_type]",
"Annual leave"
]
},
"=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgGreen' , 'sp-css-backgroundColor-BgMintGreen sp-css-color-MintGreenFont')",
{
"operator": ":",
"operands": [
{
"operator": "==",
"operands": [
"[$Leave_x0020_type]",
"Other Leave"
]
},
"=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgOrange' , 'sp-css-backgroundColor-BgPeach sp-css-color-PeachFont')",
{
"operator": ":",
"operands": [
{
"operator": "==",
"operands": [
"[$Leave_x0020_type]",
"Business Trip"
]
},
"=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgTeal' , 'sp-css-backgroundColor-BgCyan sp-css-color-CyanFont')+' sp-field-fontSizeSmall'",
""
]
}
]
}
]
}
}
WarrenBelz
146,786
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional