I am creating a form in power apps, where some of the fields are populated by using lookup to return values from an excel table saved in Sharepoint. I'd like the criteria to be dynamic based on the answer to order number, but for now I've made it simple by using a single order number I knw exists in my data set. After writing the formula I get this error which I have attached as a screenshot, any ideas how I can resolve this error?
This is my formula:
LookUp(WO_Data,'Order Number'="3007956",'Line')
I've also pasted the error message below
Error when trying to retrieve data from the network: Syntax error at position 12 in 'Order Number eq '3007956''. inner exception: Syntax error at position 12 in 'Order Number eq '3007956''. clientRequestId: ad4c53e7-3194-4222-aa27-186cdcbf40b2
Try replacing the double quotes in the formula with single quotes. JSON doesn't like the use of Single quotes directly in a formula. Also check to make sure Order Number is a Single line of text and not a number.
LookUp(WO_Data,'Order Number'='3007956','Line')
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
Paul Papanek Stork, MVP Blog: https://www.dontpapanic.com/blog
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
8
Share
Report
All responses (
Answers (
