Automatic uppercase formula and empty values


Sometimes, I use the shortcut via right click to generate the modify to UPPERCASE formula. This formula does not account for empty values since it converts empty values to empty strings. Is it possible to change this behavior (also for related automatically generated functions) to account for empty values and keep them empty?


Hi Nikolaas,

you can use the below expression to keep empty values intact:

when(not isempty([Column 1]), upper([Column 1]))

We are not considering changing the behavior of upper() as it would be a) a breaking change, and b) would require changing many other text functions to ensure uniform behavior.