Hello,
on my onPrem SharePoint SE Farm, I have two lists.
List 1 contains a lookup column with multiple entries that refer to List 2, “Other seminars.”
List 2 contains seminars with the field “Seminar title.”
For example, one entry in List 2 has “IT Workshop” as the seminar title.
List 2 has the lookup value “IT Workshop” and others in the “Other seminars” field.
I would like to use Query List to obtain only the IDs of the entries in List 1 that contain “IT Workshop” in the “Other seminars” column.
My CAML is:
<Query>
<Lists>
<List ID="{75EBDC1E-BBDF-4383-BBAF-C61C019E8948}" />
</Lists>
<ViewFields>
<FieldRef Name="ID" />
</ViewFields>
<Where>
<Contains>
<FieldRef Name="otherSeminars" />
<Value Type="Lookup">IT-Workshop</Value>
</Contains>
</Where>
</Query>
I also tried only the ID “13” of the IT Workshop and this: 13;#IT-Workshop. But anytime the same error.
I receive the following error message: Error retrieving list data. Exception from HRESULT: 0x80131904
How can I resolve this problem?
Thank you so much for your help.
Sabine