cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Z_Lukowski
Resolver II
Resolver II

Problem with Lookup from Guid - instead of value it;s giving "Object object" in Data table

Hello,

Like in the title, I have GUID number in the table which I want to display value of.

I made text property in column of my datatablein canvas app:

LookUp(RandomtabletoDeletes, (cr437_randomtabletodeleteid=ThisItem.SubTitle2.RandomtabletoDelete),Name)

No errors detected, and sometimes It even give good results, but when I filtered the results or refresh datatable it produced -"Object object" instead of value. And last time I've edited app it had value of "Object object" by default but when I've refreshed table value was correct.

 

Z_Lukowski_0-1611789999373.png

 

Appreciate all the help 🙂

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

Hi @Z_Lukowski 

What is your data source? A CDS or a Excel file?

What is your "GUID number" column? A text string?

Since I don't have your data, you can try to user AddColumns() to add another column to keep the value from SubTitle2 into your table(replace the TableDataSource of your table in below formula):

AddColumns(TableDataSource,"newcolumn",SubTitle2)

Then Edit the fields of your table to add this “newcolumn”, check if this new added column works well:

v-albai-msft_0-1611890549597.png

If above still cannot work, as a workaround, I suggest you use Gallery instead of  DataTable. Sometimes I will also get "Object object" results in DataTable, maybe displayed values inside DataTable have some limits.

Best Regards,

Allen

View solution in original post

2 REPLIES 2
v-albai-msft
Community Support
Community Support

Hi @Z_Lukowski 

What is your data source? A CDS or a Excel file?

What is your "GUID number" column? A text string?

Since I don't have your data, you can try to user AddColumns() to add another column to keep the value from SubTitle2 into your table(replace the TableDataSource of your table in below formula):

AddColumns(TableDataSource,"newcolumn",SubTitle2)

Then Edit the fields of your table to add this “newcolumn”, check if this new added column works well:

v-albai-msft_0-1611890549597.png

If above still cannot work, as a workaround, I suggest you use Gallery instead of  DataTable. Sometimes I will also get "Object object" results in DataTable, maybe displayed values inside DataTable have some limits.

Best Regards,

Allen

Nothing worked properly, Ive switched to gallery, no problems there. 

Thank you

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,788)