SOLVED

SP list lookup column show blank for read only user

%3CLINGO-SUB%20id%3D%22lingo-sub-2500573%22%20slang%3D%22en-US%22%3ESP%20list%20lookup%20column%20show%20blank%20for%20read%20only%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2500573%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20SP%20list%20shared%20with%20read%20only%20group.%3C%2FP%3E%3CP%3EIn%20this%20list%20there%20is%20lookup%20column%20sourced%20from%20another%20list.%3C%2FP%3E%3CP%3EColumn%20value%20showing%20normal%20for%20me%20(List%20owner)%2C%20but%20for%20read-only%20users%20it%20shows%20blank.%3C%2FP%3E%3CP%3EI%20tried%20column%20formatting%20to%20convert%20lookup%20value%20into%20basic%20text%2C%20but%20still%20no%20difference.%3C%2FP%3E%3CP%3EAny%20solution%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%7B%3CBR%20%2F%3E%22%24schema%22%3A%20%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fv2%2Fcolumn-formatting.schema.json%26nbsp%3B%22%2C%3CBR%20%2F%3E%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%22txtContent%22%3A%20%22%40currentField.lookupValue%22%3CBR%20%2F%3E%7D%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2500573%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2501324%22%20slang%3D%22en-US%22%3ERe%3A%20SP%20list%20lookup%20column%20show%20blank%20for%20read%20only%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501324%22%20slang%3D%22en-US%22%3EI%20figured%20out%20that%20need%20to%20grant%20permission%20to%20users%20for%20sourced%20list%20also.%3C%2FLINGO-BODY%3E
New Contributor

I have SP list shared with read only group.

In this list there is lookup column sourced from another list.

Column value showing normal for me (List owner), but for read-only users it shows blank.

I tried column formatting to convert lookup value into basic text, but still no difference.

Any solution please?

 

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

1 Reply
best response confirmed by ankhbileg01 (New Contributor)
Solution
I figured out that need to grant permission to users for sourced list also.