/C#/Sharepoint c# get list item query by lookup

Sharepoint c# get list item query by lookup

CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='yourColumn' LookupId='TRUE'/><Value Type='Lookup'>123</Value></Eq></Where></Query></View>";
List listByTitle = clientContext.Web.Lists.GetByTitle("YourListName");
ListItemCollection yourListItem = listByTitle.GetItems(camlQuery);

clientContext.Load(yourListItem);
clientContext.ExecuteQuery();

Similar codes

6 votes116 views1 answer
How to make mouse invisible unity
C#
0 vote141 views2 answers
C# linq unique by property
C#
2 votes119 views1 answer
How to reset rotation in unity
C#
26 votes121 views1 answer
C# date formats custom
C#
0 vote109 views1 answer
C# Search in JSON without deserialization
C#
0 vote123 views1 answer
Como usar a função SelectToken em vb net
C#
0 vote123 views1 answer
How to save datagridview data to database in c# windows application
C#
5 votes124 views1 answer
C# write variable in string
C#
3 votes117 views1 answer
C# invert array
C#
1 vote111 views1 answer
C# separate string by a new line
C#