SOLVED

List; conditional formatting; null value

%3CLINGO-SUB%20id%3D%22lingo-sub-1813803%22%20slang%3D%22en-US%22%3EList%3B%20conditional%20formatting%3B%20null%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1813803%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20in%20an%20SPO%20subsite.%20It%20was%20created%20from%20the%20Microsoft%20Lists%20page%20on%20a%20task%20list%20template%2C%20and%20customized.%20Items%20are%20added%20in%20three%20ways%3A%20manually%3B%20a%20Flow%20from%20Exchange%20e-mail%3B%20and%20a%20Flow%20from%20Exchange%20tasks.%20When%20items%20are%20added%20by%20either%20Flow%2C%20certain%20fields%20in%20the%20list%20are%20left%20blank%2C%20because%20the%20source%20data%20does%20not%20contain%20the%20necessary%20information.%20I%20would%20like%20to%20apply%20conditional%20formatting%20to%20those%20items%20to%20make%20it%20quicker%20to%20find%20them%20and%20complete%20the%20information%20manually.%20I%20can't%20find%20any%20way%20to%20complete%20a%20condition%20for%20a%20null%20value.%20I%20don't%20know%20JSON%2C%20so%20I'm%20trying%20to%20use%20the%20natural%20language%20dialog.%20I've%20tried%20two%20single%20quote%20marks%20without%20a%20space%20between%20them%3B%20I've%20tried%20the%20word%20'empty'%20inside%20parentheses%3B%20neither%20works.%20(It%20doesn't%20matter%20whether%20the%20entire%20line%20or%20just%20the%20one%20field%20is%20conditionally%20formatted.)%20Is%20it%20possible%20to%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1813803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1822804%22%20slang%3D%22en-US%22%3ERe%3A%20List%3B%20conditional%20formatting%3B%20null%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1822804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F243160%22%20target%3D%22_blank%22%3E%40Joseph%20Nierenberg%3C%2FA%3Eon%20modern%20sites%20you%20are%20able%20to%20use%20column%20formatting%20option.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DoKb-KZl8Myw%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DoKb-KZl8Myw%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20steps%20which%20you%20may%20takes%20are%20to%20highlight%20whole%20row%20%3A%3CBR%20%2F%3EClick%20column%20header%20%26gt%3BColumn%20settings%26gt%3BFormat%20this%20column%3C%2FP%3E%3CP%3Ethen%20choose%20Format%20view%26gt%3BConditional%20formatting%3CBR%20%2F%3EThen%20you%20can%20define%20your%20rules%20where%20under%20the%20Values%20filed%20there%20is%20an%20option%20(Empty)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20way%20you%20can%20format%20you%20column%20without%20any%20JSON%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1823076%22%20slang%3D%22en-US%22%3ERe%3A%20List%3B%20conditional%20formatting%3B%20null%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1823076%22%20slang%3D%22en-US%22%3EThere%20is%20no%20option%20(Empty).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1826453%22%20slang%3D%22en-US%22%3ERe%3A%20List%3B%20conditional%20formatting%3B%20null%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1826453%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F243160%22%20target%3D%22_blank%22%3E%40Joseph%20Nierenberg%3C%2FA%3EMaybe%20depends%20on%20the%20column%20type%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MarekSkalinski_0-1603874936400.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229772i46281D10C935B82D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MarekSkalinski_0-1603874936400.png%22%20alt%3D%22MarekSkalinski_0-1603874936400.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2C%20if%20there%20is%20no%20option%20(Empty)%20then%20leave%20it%20blank.%20Always%20you%20can%20do%20workaroud%20and%20if%20the%20item%20is%20created%20by%20the%20flow%20just%20insert%20-%20(dash)%20and%20the%20you%20can%20use%20it%20as%20a%20filter%20in%20you%20column%20formatting.%20Dash%20can%20be%20changed%20later%20on%20once%20the%20item%20is%20edited.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

I have a list in an SPO subsite. It was created from the Microsoft Lists page on a task list template, and customized. Items are added in three ways: manually; a Flow from Exchange e-mail; and a Flow from Exchange tasks. When items are added by either Flow, certain fields in the list are left blank, because the source data does not contain the necessary information. I would like to apply conditional formatting to those items to make it quicker to find them and complete the information manually. I can't find any way to complete a condition for a null value. I don't know JSON, so I'm trying to use the natural language dialog. I've tried two single quote marks without a space between them; I've tried the word 'empty' inside parentheses; neither works. (It doesn't matter whether the entire line or just the one field is conditionally formatted.) Is it possible to do?

4 Replies

@Joseph Nierenbergon 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).
best response confirmed by Joseph Nierenberg (Frequent Contributor)
Solution

@Joseph NierenbergMaybe depends on the column type 

MarekSkalinski_0-1603874936400.png

 

, 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.