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

(0) Share

Report

Posted on by Z_Lukowski

216

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 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-albai-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
Z_Lukowski 216 on at

Like (0)

Report

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

Was this reply helpful? Yes No