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

[Z_Lukowski]

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.

Appreciate all the help 🙂

[v-albai-msft · Accepted solution]

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:

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

[Z_Lukowski]

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

Thank you