Forum Discussion
List; conditional formatting; null value
JosephNierenbergMaybe depends on the column type
, if there is no option (Empty) then leave it blank. Always you can do workaroud and if the item is created by the flow just insert - (dash) and the you can use it as a filter in you column formatting. Dash can be changed later on once the item is edited.
JosephNierenbergon modern sites you are able to use column formatting option.
https://www.youtube.com/watch?v=oKb-KZl8Myw
Also steps which you may takes are to highlight whole row :
Click column header >Column settings>Format this column
then choose Format view>Conditional formatting
Then you can define your rules where under the Values filed there is an option (Empty)
This way you can format you column without any JSON
- There is no option (Empty).
JosephNierenbergMaybe depends on the column type
, if there is no option (Empty) then leave it blank. Always you can do workaroud and if the item is created by the flow just insert - (dash) and the you can use it as a filter in you column formatting. Dash can be changed later on once the item is edited.
- "if the item is created by the flow just insert - (dash) and the you can use it as a filter"
MarekSkalinski Of course! Thank you. Works well.
