I am pulling results from a SharePoint Online list without problem with this...

<View><Query><Where><Eq><FieldRef Name='department'></FieldRef><Value Type='Text'>HR</Value></Eq></Where></Query></View>

but this gives me no results (even though there are)

<View><Query><Where><And><Eq><FieldRef Name='department'></FieldRef><Value Type='Text'>HR</Value></Eq><Eq><FieldRef Name='licenses'></FieldRef><Value Type='Text'>yes</Value></Eq></And></Where></Query></View>

Is my syntax wrong?

Thanks P

  • Is licences actually a boolean field? Mar 3 at 12:56
  • What is the data type of licenses column? Mar 3 at 13:00
  • Single line of text Mar 3 at 13:00
  • Use case sensitive values - check if you are using correct values. Also, verify name of columns just in case Mar 3 at 13:03
  • Thanks. Value will always either be blank or yes. I am using the same case. The column name is correct. Totally at a lose with this one! Mar 3 at 13:08


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.