0

How to filter "Yes/No (check box)" field from lookup list using PnP/REST API?

I can filter other columns with different types but not able to filter "Yes/No (check box)" field.

It is showing below error message:

The query to field 'LookupList/LookupField' is not valid.

2

Extending Yes/No field using lookup columns is not supported in SharePoint. So, you will not be able fetch or add the filter on Yes/No field from lookup list.

Supported Column Types:

  • Single line of text
  • Number
  • Date and Time

Unsupported Column Types:

  • Multiple lines of text
  • Currency
  • Person or Group
  • Calculated
  • Hyperlink or Picture
  • Custom Columns
  • Yes/No
  • Choice
  • Lookup

Microsoft official documentation: Create list relationships by using unique and lookup columns

1
  • Please Upvote(^) and accept as an Answer if it helped you & it will help others with similar question in future to find the correct answer easily. It also removes this question from "Unanswered questions" list. Jul 28 at 4:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.