Issue Description:

  • I use JSON to format a lookup column in a SharePoint Online list.
  • I click 'Edit in Grid View'.
  • The column value and formatting are appropriately displayed in grid view.
  • UNTIL I try to change a value in that column!
  • When I click the field to edit it, neither the current value or the lookup values are visible.
  • If I blindly click one of the invisible values on the lookup list, and then click another row, the new value does appear in the field I just left - so the functionality is not affected - just how the data is displayed (or in this case, not displayed).
  • Does not impact ability to edit single items in the edit form.

Other things I've tried: I've tried using a number of different JSON formats, including nothing more than font-weight bold (no table display-type) - and it doesn't seem to matter. The behavior is the same. The formatting is applied until I click in the field to edit it, and then the values all become invisible.

I've spent over an hour Googling, and only came up with one thing: Albini's Cat posted a similar question a year or so ago, but doesn't appear to have received an answer.

Help, anyone? Thanks!

Issue Illustrated

Here's my current JSON:

Current JSON Column formatting for the above

And another example - same issue:

enter image description here

1 Answer 1


I can see the exact same behavior in our SharePoint tenant:

enter image description here

I have used basic JSON like:

  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField.lookupValue"

This seems like issue from Microsoft end. Requesting you to create a new issue/bug on PnP List formatting repository on GitHub. This is maintained by Microsoft employees as well as community contributors.

Also, you can raise a support ticket with Microsoft, check Get Online support.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.