It is mentioned that we can specify odata filters in the --filter option, but it doesn't support contains, endsWith methods.. In that way, the use is very limited for the --filter switch

An unknown function with name 'contains' was found. This may also be a key lookup on a navigation property, which is not allowed.
PS C:\> az ad sp list --filter "endsWith(displayName,'ppe')"
')' or ',' expected at position 26 in 'endsWith(displayName,'ppe''.

---
#### Document Details

⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*

* ID: e99d25ff-03e2-e015-37f4-a29b59ec50d4
* Version Independent ID: 1a8e88ed-72c7-fbe7-b0ad-68f23b3946cd
* Content: [az ad sp](https://docs.microsoft.com/en-us/cli/azure/ad/sp?view=azure-cli-latest)
* Content Source: [latest/docs-ref-autogen/ad/sp.yml](https://github.com/MicrosoftDocs/azure-docs-cli/blob/master/latest/docs-ref-autogen/ad/sp.yml)
* Service: **active-directory**
* GitHub Login: @rloutlaw
* Microsoft Alias: **routlaw**