cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zakiirjuman1
Frequent Visitor

GUID() not working with LookUp() in Item select

Hi all,

 

I have a table, InvLineItem, with a number of fields including the following:

 

ID UNIQUEIDENTIFIER,

PONumber NVARCHAR (50),

SupplierInvoiceNumber NVARCHAR (50) 

 

Why is it that I can populate my display form with the following command with this:

 

 

LookUp('[dbo].[InvInvoice]', PONumber = "20-00447" And SupplierInvoiceNumber = "0247640-IN")

 

 

But not this:

 

 

 

LookUp('[dbo].[InvInvoice]', ID = GUID("cb061452-a98f-4b16-ad9e-285fec71c6a7"))

 

 

 

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Please use filter. It looks like you aren't returning any column. Are you using it on a Gallery

Filter('[dbo].[InvInvoice]',Text( ID )= "cb061452-a98f-4b16-ad9e-285fec71c6a7")

 

Filter('[dbo].[InvInvoice]',ID = "cb061452-a98f-4b16-ad9e-285fec71c6a7")

 

Have you saved cb061452-a98f-4b16-ad9e-285fec71c6a7I In the ID column

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

5 REPLIES 5
eka24
Super User III
Super User III

Remove the word"Guid" from the lookup.

LookUp('[dbo].[InvInvoice]', ID = "cb061452-a98f-4b16-ad9e-285fec71c6a7")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

@eka24 I just tried this and I get an incompatible type error with this wording:
"Incompatible type. We can't evaluate your formula because the values being compared in the formula aren't the same type. The left value is a Guid type and the right value is a Text type. Location FormViewer2.Item"

Please use filter. It looks like you aren't returning any column. Are you using it on a Gallery

Filter('[dbo].[InvInvoice]',Text( ID )= "cb061452-a98f-4b16-ad9e-285fec71c6a7")

 

Filter('[dbo].[InvInvoice]',ID = "cb061452-a98f-4b16-ad9e-285fec71c6a7")

 

Have you saved cb061452-a98f-4b16-ad9e-285fec71c6a7I In the ID column

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

I apologize. Seems as if I had the wrong GUID all along from an older table readout.


Should the thread be deleted?

That's why I asked whether you have that number in the ID column.

You can mark it as a solution to close it. 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (57,953)