Patch(
Assessments_3,
LookUp(
Assessments_3,
'CIA Document Number' = DocNum.Value
),
{'CEP/CER Update Required?':UpdateReq.Value,
'Rationale if "No"':Rationale.Value,
'CEP/CER update fall outside of PMS schedule':UpdatePMS.Value,
'Affected CEP/CER Document Numbers':ReportNumbers.Value,
'Owner of CEP/CER Update':UpdateOwner.Value,
'MasterControl Packet Numbers':PacketNumber.Value,
'Approved and Released in MasterControl':ApproveRelease.Value
}
);
ResetForm(Form1)
The specific error I am receiving: "Error when trying to retrieve data from the network: Syntax error at position 12 in 'CIA Document Number eq 'DCE-03-TEST". inner exception: Syntax error at position 12 in 'CIA Document number eq 'DCE-03-TEST". clientRequestId: fe220978-0e0d-473b-99db-5169a395b8da.
I've done several troubleshooting - Copilot, Google searches - but haven't come across a good solution. Eventually I would like to have 2 conditions to check which means I may have to use Filter but if I can get this code with Lookup() to work then in theory, I can apply the same thing to Filter().
Additional Info:
* CIA Document Number is the official column header (includes spaces)
* DocNum is an input text control
* I am using an = sign so unsure of why the error message states eq
* I've also checked my source file and the columns are "Text" for cell type.
* I've also refreshed my data a few times.
* Haven't been able debug the rest of the code because the lookup control isn't working.
Main Pain Point: 'CIA Document Number' (column header, unsure of data type) = DocNum.Value (data type: text)
Please help!
