“Value does not fall with in the expected range” error in Crow Canyon Report Center app

Issue: "Value does not fall with in the expected range" error message  while creating a report.

Cause: Lookup threshold limit in the list.

In SharePoint online, the lookup threshold limit is 12. It allows us to create more lookup columns, however it doesn’t allow to read information beyond 12 lookups through program. This error will not happen while reading data from the first 12 lookup columns (lookup/Person or group columns) in the list.

The work around to avoid this error message is to remove unused lookup and Person/group columns from the list.

Leave a Reply