Unanswered

Datatable showing [object object] for sharepoint lookup column

(0) Share

Report

Posted on by jamerishi

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

v-jefferni on at

Like (0)

Report

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,

Was this reply helpful? Yes No
jamerishi 9 on at

Like (0)

Report

Hi Jeffer,

By manual method also it is still the same.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @jamerishi ,

Then this should relate to SharePoint column formatting. Could you please share the settings of the column in your list?

Best regards,

Was this reply helpful? Yes No
jamerishi 9 on at

Like (0)

Report

Hi @v-jefferni ,

Find the requested screenshots.
Regards,
Jame Rishi

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @jamerishi ,

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" }

Best regards,

Was this reply helpful? Yes No
jamerishi 9 on at

Like (0)

Report

Hi @v-jefferni ,

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')"
}
}

Regards,
Jame Rishi

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @jamerishi ,

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.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" }

Best regards,

Was this reply helpful? Yes No
jamerishi 9 on at

Like (0)

Report

Hi @v-jefferni ,

It didnt helped. Its still the same.

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @jamerishi ,

I suggest you ask a question in SharePoint community. There may be other settings for this column that I don't know.

Best regards,

Was this reply helpful? Yes No