I have a screen that has a gallery list that is filtered, once you choose one of the items in the list I navigate to another screen where I use the following lookup call:
LookUp(Students, 'Student Full Name'=Upper(TemplateGalleryList2.Selected.Result), 'Student Full Name')
It is grabbing the correct value for TemplateGalleryList2.Selected.Result, but I get a syntax error from the server:
The requested operation is invalid. Server Response: Students failed: Syntax error at position 12 in 'Student Full Name eq 'DOE, JOHN''. inner exception: Syntax error at position 12 in 'Student Full Name eq 'DOE, JOHN''. clientRequestId: d6d61879-1866-4b2d-a708-35254c67465a
I don't get it.
Solved! Go to Solution.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.