LookUp using GUID comparison not returning values, despite match

(1) Share

Report

Posted on by grandepaci

Hi all,

I’ve been working with a canvas app embedded inside a model-driven app. I’m trying to retrieve a record from my Dataverse table 'MDA Approvals' using the GUID of the current record from ModelDrivenFormIntegration.

This code works correctly and returns the expected record, but throws a delegation warning:

To avoid the delegation warning, I tried switching to a pure GUID comparison:

But strangely, this version does not return any record — even though the values should match.

To verify this, I tested in a label:

This returns true, which confirms that both IDs match.

So my question is:

Why does the LookUp() using GUID(...) not return a record?
Is there a reliable way to write this that avoids delegation warnings and actually returns results?

Thanks in advance for any insights!
GP

Categories:

Microsoft Dataverse

All responses (8)

Answers (0)

stampcoin 3,126 on at

Like (0)

Report
LookUp using GUID comparison not returning values, despite match

@grandepaci Hi,

try this one.

With( { MyID: First(ModelDrivenFormIntegration.Data).ItemId }, Set( varApprovalRecord, LookUp( 'MDA Approvals', Text(Approvals) = MyID ) ) )
grandepaci 58 on at

Like (0)

Report

LookUp using GUID comparison not returning values, despite match

Hi @Aishish Mishra

I tried your suggestion and put your code inside the OnVisible property of my Screen.

When loading the GUID prior to a variable:
[Set(varApprovalGUID, GUID("12345678-1234-1234-1234-1234567890ab"));]

It wont store data inside the variable varApprovalGUID.

I dont know if this is some special behavior of the Embedded Page or something else.

I also tried putting it at the OnStart property of the App, but that didnt work either.

Kind regards

GP
Suggested answer

Ashish Mishra 6 on at

Like (0)

Report

LookUp using GUID comparison not returning values, despite match

Hi GP,

Since GUID() is non-delegable in Dataverse queries in PowerApps. Static GUID values or variables are fine — Dataverse can evaluate them server-side.

Avoid runtime GUID() in queries. Store GUId as string or variable. Convert it explicitly :

Set(varApprovalGUID, GUID("12345678-1234-1234-1234-1234567890ab"));
Filter(YourTable, Approvals = varApprovalGUID)

hope this answers your question.

thanks

Ashish
grandepaci 58 on at

Like (0)

Report

LookUp using GUID comparison not returning values, despite match

Hi @stampcoin,
Thank for the suggestion.

It didnt throw an error, but also didnt load any data into my varApprovalRecords.

Do you have another suggestion?

Kind regards

GP
Suggested answer

stampcoin 3,126 on at

Like (0)

Report
LookUp using GUID comparison not returning values, despite match

@grandepaci Hi,

I see... 😊

try this one.

With( { MyID: GUID( First(ModelDrivenFormIntegration.Data).ItemId ) }, Set( varApprovalRecord, LookUp( 'MDA Approvals', Approvals = MyID ) ) )
grandepaci 58 on at

Like (0)

Report

LookUp using GUID comparison not returning values, despite match

Hi everyone, thanks for your suggestions.

I tried both your suggestions, but it wouldnt find any Approvals.Id.
The 'Approvals' column alone gives the GUID.

The column 'Approvals' is the Identifier and not a Lookup column.
It is named Approvals, because the List previously had that name.

Writing GUID() before 'Approvals' works, but also triggers the Delegation Warning.
Is the problem then, that Power Apps needs a diffrent comparison for Dataverse GUID's?

Thanks in advance.

GP

Screenshot 2025-0...
Suggested answer

Ashish Mishra 6 on at

Like (0)

Report
LookUp using GUID comparison not returning values, despite match

Hi GP,

The root cause is that Canvas Apps treat GUID comparisons differently from Dataverse behind the scenes. Specifically:

The Approvals column in Dataverse is likely a lookup or a GUID-type column, but Canvas Apps interprets it differently depending on how the record is referenced.

When you use GUID(First(ModelDrivenFormIntegration.Data).ItemId), Canvas Apps treats this as a GUID type, but in Dataverse, lookup fields are objects, not just GUIDs.

So this query: LookUp('MDA Approvals', Approvals = GUID(...)) - doesn't match because Dataverse internally treats lookup columns as records, not plain GUIDs.

Correct way:

Set(
varApprovalRecord,
LookUp(
'MDA Approvals',
Approvals.Id = GUID(First(ModelDrivenFormIntegration.Data).ItemId)
)
)
Suggested answer

stampcoin 3,126 on at

Like (0)

Report
LookUp using GUID comparison not returning values, despite match

@grandepaci Hi,

How to use GUID () function, please check this link GUID function

You can use With to ignore the warning. but it doesn't mean eliminate the delegation problem.😊

for example.

With( { MyID: GUID( First( YourDatasource ).ItemId ) }, Set( myVar, LookUp( 'MDA Approvals', Approvals.Id = MyID ) ) )