Power Platform Community Forum Thread Details

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