Unanswered

Issue with Datatable - Author/Editor became [object Object]

(0) Share

Report

Posted on by aprildunnam

704

I'm currently having an issue with something that was previously working but stopped working as of last week. In my PowerApp I have a DataTable that is using a SharePoint list as the data source. That list has a couple of Lookup fields that I'm surfacing in the data table. This previously worked just fine but now the lookup field values are displaying "object object" instead of the value. I'm on Version 2.0.783. is anyone else experiencing this behavior?

Categories:

Connectors

Connecting to Data

General Questions

All responses (11)

Answers (0)

Abirban 4 on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

Can anyone help me show the lookup filed value on the New Table Control? Item contains Dataverse Table directly not used any collection.
aroudaki on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

I would suggest to try it with the new DT (Preview)
Here is the blog post on how to use it
https://powerapps.microsoft.com/en-us/blog/improved-data-table-control-with-column-formulas/

Make sure to turn on "Enable improved data table control selection and value properties" flag in the app settings.

Usually we see this [object object] issue when the binded field to that column is a lookup or some complex type.
With the new DT you can have formulas (similar to gallery) using "ThisItem" to reference the correct field on the lookup field.

LMK if this helps.
apadill4 19 on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

The data source is sharepoint. I am using a data table, but I don't know if it's new. I've been using it since December. The text property one of the columns I'm seeing the issue in is: ReviewMethod.
aroudaki on at

Like (1)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

What kind of Data source are you using to connect Data table to?
Are you using the new Data table (preview) control? if so what is the formula in text property of the column with problem looks like?
apadill4 19 on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

I am having the same issue. I have tried refreshing the data source, removing the data source, and removing the table. None of them have worked. I've had the issue before and dont remember what I did to fix it.
anees on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

April glad to hear that you are not blocked anymore. If you are able to get the older version of the app that has the problem please send it our way so we can investigate and see if this was preventable. You might need to temporarily provide access to the SP list as well (if that is possible). Thanks.
aroudaki on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

That's great!
let us know if you faced this issue again.
aprildunnam 704 on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

Update: I was finally able to get it working again by removing, re-adding and re-configuring the data table. I had an issue the week prior where it had wiped my data table so I think this might have been a lingering bug from that.
vijayka on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

What is the column type for the lookup column in your list ?
anees on at

Like (0)

Report

Re: Issue with Datatable - Author/Editor became [object Object]

Hi April, I tried some scenarios to try and repro this at our end but not able to. Are you seeing this issue with all lookup fields? Have you tried a different control mapped to the same column to see what it shows? Thanks.