Expected value between 1 and 1 inclusive. Dynamic CRM 365


Recently we had an issue while trying to Query Retrieve Multiple for (Audit Entity) ,

Error Message: ” Expected value between 1 and 1 inclusive”.

Root Cause: Microsoft has moved Audit table to Cosmo DB, due to which Distinct & Aggregate, Group by function are no more supported from retrieve multiple query.

Fix: Remove distinct , aggregate , group by in your retrieve multiple query will resolve your issue.

One thought on “Expected value between 1 and 1 inclusive. Dynamic CRM 365

Leave a comment