Announcements
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?
Have you tried with different sharepoint list? or even a CDS datasource with lookup column?
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.
What is the column type for the lookup column in your list ?
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.
That's great!let us know if you faced this issue again.
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.
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.
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?
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.
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.
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 432 Super User 2026 Season 2
Mohsin Ali 347
WarrenBelz 254 Most Valuable Professional
