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
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.
