SharePoint online column update

Question

I have a SP list, one of the columns contains different numbers. I need to replace these numbers with text.

For instance, if column color contains:

1 -> replace it with the text white

2 -> replace it with the text black

And so on, is there a simple PowerApp that can be manually triggered to do that?

I tried using the following JSON for the column:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField == 1, 'white', if(@currentField == 2, 'Black', ''))"
}

but when filtering the column, it will show the numbers 1,2,etc instead of the text (white, black, etc..).

Answer 1

This is the expected behavior in SharePoint while using JSON Formatting as JSON formatting only customizes the "display" of the list column and does not store/modify the actual value of column.

So while filtering on column you will see the actual values instead of JSON formatted values.

---

For your requirements, you can use calculated columns in SharePoint.

Use below formula in calculated column:

=IF([Column1] = 1, "White", IF([Column1] = 2, "Black", ""))

Where [Column1] is the name of your number column.