Dynamics Community Forum Thread Details

Is there a way to filter multiple Client IDs/WCIS IDs using comma-separated values in Dynamics 365?

Hi Team,

I am working with the Clients entity in Dynamics 365 and frequently need to search for multiple Client IDs (or WCIS IDs) at the same time.

Currently, when I use a filter such as:

Field: WCIS ID
Operator: Contains
Value: 2347000001,2347000002

Dynamics 365 appears to treat the entire value (234718897,250137937) as a single string rather than recognizing it as two separate values. As a result, no records are returned unless a record contains the exact combined text.

The current workaround seems to be creating multiple filter conditions and joining them with OR, such as:

WCIS ID Contains 2347000001
OR WCIS ID Contains 2347000002
OR WCIS ID Contains

While this works, it becomes cumbersome when searching for a large list of IDs copied from Excel or another source.

My Questions
Is there any out-of-the-box feature in Dynamics 365 that allows users to search/filter multiple values in a single filter field?
Is there an operator similar to SQL's IN clause that accepts a list of values?
Are there any advanced filtering options, FetchXML approaches, personal view configurations, or other workarounds that support comma-separated input values?
Has anyone implemented a custom solution to support multi-value filtering for Client IDs or similar identifier fields?
Expected Behavior

Ideally, entering:

2347000001,2347000002

in a filter field would automatically be interpreted as:

WCIS ID Contains 2347000001
OR
WCIS ID Contains 2347000002

or through an operator such as "Contains Any Of" or "In List".

Has anyone encountered this requirement, and is there an existing solution available?

Thanks in advance for your insights.