Unable to display record in edit form

[dave8]

Hello,

I am redirecting to edit form on custom button click which has a value of "GUID" of the relevant record which I am passing to Edit form.

However, on edit form, the formula is not working as it's throwing following error:

Can you please share how can I resolve and display the selected item in edit form ?

Thanks,

[mdevaney]

@dave8 

The error says “values being compared in the formula are not of the same type.  This means the column you referenced is not text.

You are either using the wrong column name or you must change that column to text.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[v-siky-msft · Accepted solution]

Hi @dave8 ,

You need to use GUID() function to convert the text to GUID value. Please try this:

LookUp('Table Name', 'Column Name'= GUID("123-123-123")

Hope this helps.

Sik

[dave8]

Awesome @v-siky-msft You helped me saving lot of my time, Thank you!

Regards,