Aug 24 2022 06:32 AM - edited Aug 24 2022 06:33 AM
I have a column of type Single Line of Text. When entering data, sometimes the cell will contain data, other times it won't, and can stay empty.
If the cell doesn't contain data, on exit/save I would like to populate the cell with "n/a".
How could I achieve this? Is this only possible using Power Automate?
Aug 24 2022 06:48 AM
SolutionThis seems to work.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=if([$field_1] == '', 'n/a', '@currentField')"
}