Hi @Phillips, Keith
Lookup fields in SharePoint allow users to select a value from another list, which is then linked to the current list item. Lookup fields are used to create a relationship between two lists. CAML (Collaborative Application Markup Language) is an XML-based query language used in SharePoint to query data from lists and libraries.
Let’s filter projects by parent project lookup field value “Address Book”. Here is the SharePoint CAML for a lookup field.
<View Scope='RecursiveAll'>
<Query>
<Where>
<Eq>
<FieldRef Name='ParentProject'/><Value Type='Lookup'>Address Book</Value>
</Eq>
</Where>
</Query>
</View>
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.