private void GetParts( string searchSku) { Parts.Clear(); List partsList = clientContext.Web.Lists.GetByTitle( "Parts" ); List inventoryLocationsList = clientContext.Web.Lists.GetByTitle( "Inventory Locations" ); CamlQuery camlQueryPartsList = new CamlQuery(); camlQueryPartsList.ViewXml = @"<View> <Query> <Where> <BeginsWith> <FieldRef Name='SKU' /> <Value Type='Text'>" + searchSku + @"</Value> </BeginsWith> </Where> </Query> </View>" ; CamlQuery camlQueryInvLocationList = new CamlQuery(); camlQueryInvLocationList.ViewXml = @"<View> <Query> <Where> <BeginsWith> <FieldRef Name='PartLookupSKU' /> <Value Type='Lookup'>" +...