You’re offline. This is a read only version of the page.
Announcements
16
Hello everyone,
I've formatted a column in a SharePoint list, using json, to display different text.
But now I cannot use the "Filter by".
Is there any way I could convert the json info, into text?
Hope my explanation makes sense.
Thank you.
Hi @smsmc,
SharePoint Online Column formatting will only display a colour or a show a txtcontent label. It will not change the value of the actual column.
https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
There is an option for that with the setValue property. But afaik that can only be triggered by pressing a button which is not useful for your scenario/use case, https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-advanced#set-multiple-field-values-of-an-item-using-customrowaction
In your case I would suggest to use an old-school calculated column instead.
1. A calculated column with a formula
2. The filter works fine with that type of column
Share
Report
All responses (
Answers (
