Announcements
Hi All,
We are facing a issue in SharePoint, one table lookup column showing [object object] instead of numeric value. Rest of the columns are fine.
Column Type - Lookup
Any help on this?
Hi @jamerishi ,
How did you add these items into the list? If you manually create new items using default SharePoint functionality, will it act the same?
Best regards,
Hi Jeffer,
By manual method also it is still the same.
Then this should relate to SharePoint column formatting. Could you please share the settings of the column in your list?
Hi @v-jefferni ,
Find the requested screenshots.
Regards,
Jame Rishi
You can check it with following steps:
1. Format this column
2. Advanced mode
3.
If you see different schema, you may try mine first, it's the default schema that I've never changed:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" }
Below is the schema:
{"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json","elmType": "a","txtContent": "@currentField","attributes": {"target": "_blank","href": "=if(indexOf([$ContentTypeId], '0x0120') >= 0, '?id=' + [$FileRef], @currentWeb + '/_layouts/15/Doc.aspx?sourcedoc='+ [$UniqueId] + '&action=View')"}}
Yes, this is exactly the problem. If you just want to see the default value setting in column settings
just copy my schema and paste into yours, then save the change.
It didnt helped. Its still the same.
I suggest you ask a question in SharePoint community. There may be other settings for this column that I don't know.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
