How to Multi-Select in CRM with ADF?

Bala 181

There is a CRM table that is being upserted for a Multi-Select values (Choices) through ADF copy activity. Values are being sent as String such as "1,2". But CRM complains

Dynamics operation failed with error code: -2147220989, error message: Incorrect attribute value type System.String

Tried with Postman with a PUT request as below and it is working absolutely fine.

PUT https://me.crm11.dynamics.com/api/data/v9.1/products(3ABCC128-XYZA-470D-8DAC-EIRY6478288F)/category/  HTTP/1.1 

Content-Type: application/json  
OData-MaxVersion: 4.0  
OData-Version: 4.0  

{
"value": "1,2"
}

How do I mimic this value setting in Copy activity?

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-06-28T10:40:57.653+00:00
Hi @Bala ,

Thank you for posting query in Microsoft Q&A Platform.

Could you please help on below details. So that we can follow along to replicate scenario and help in detailed resolution.

What is your Source type?

If possible, could you please share sample source data? which helps us to replicate scenario.

When you say multi select values, you mean values with comma separated? If your source file is also comma separated values(csv) file?
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-07-01T05:59:33.33+00:00

Hi @Bala ,

Could you please share clarifications on above commented queries? That will help us to follow along issue and provide detailed resolution. Thank you.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-07-05T06:34:55.533+00:00

Hi @Bala ,

Did you get chance to share details on above requested clarifications? Details on clarifications will help us to follow along issue and provide detailed resolution. Thank you.