Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Bug: LookUp for a CDS URL field failing - characters not escaped?

My app is saving photos to Azure Blob Storage, setting a secure token then patching that token to a URL field in a CDS table named 'Azure Documents'.

After the save I want to do a LookUp on the URL field to confirm that the record really has saved (yes, I should be able to rely on the return value of the Patch, but that does not appear to be reliable - i.e. the patch will sometimes return true but the record has not been saved). The scenario is that users are often working on the edge Wi-Fi range and when connectivity drops, things can be left in an inconsistent state.

If I try to do a LookUp comparing the URL columns to the value I have just attempted to set for the record, I get the following runtime error:




Looks to me like the : character is making the OData query barf.

This is the code that causes the failure:


LookUp('Azure Documents', URL = conWebURL, 'Azure Document')




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,621)