I hope you can help.

SharePoint Online:

Values on a Choice column appear colour formatted on QuickEdit view.  However values in a Lookup column (values taken from a lookup list) are invisible on QuickEdit.  The values are there, but are only visible when you click into the cell.  Both Choice & Lookup columns have the same formatting.

The screenshot below shows how the columns display in regular list view versus QuickEdit view.

Can anyone help please?  Thanks.

List view formatting comparisons

  • Please post your JSON so we can troubleshoot.
    – willman
    Commented Mar 4, 2020 at 22:33

1 Answer 1


In your JSON for the Lookup column, you need to reference the .lookupValue property. For example:

"txtContent": "[$yourlookupfield.lookupValue]"
  • Thanks for your reply willman. Yes - I have that in there. To confirm, the values are there in QuickEdit view, but the formatting is making them invisible until you select them. Commented Mar 5, 2020 at 9:57

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.