Customer experience | Sales, Customer Insights,...

N:N Relationship XRM ToolBox Importing multiple values from a picklist field

(0) Share

Report

Posted on by terrylynnd

Hi All.

I have been able to successfully import single values to a N:N relationship field.

However, the field is a picklist, and I can't figure out how to represent the data in my file to import multiple values. Does anyone have any suggestions? I tried putting spaces between the values and also tried semicolons, but I get an error indicating "no record was found with the value specified".

Thank you,

TerryLynn

All responses (3)

Answers (0)

Suggested answer

Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report

RE: N:N Relationship XRM ToolBox Importing multiple values from a picklist field

Hi terrylynnd,

You are welcome.
terrylynnd 5 on at

Like (0)

Report

RE: N:N Relationship XRM ToolBox Importing multiple values from a picklist field

Thank you for your response. I was able to figure out a work around. Since I have maximum four options selected from the picklist, I just created four columns with one selection in each, then I ran the progam for each column and they populated separately. Didn't take much time at all.
Suggested answer

Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report

RE: N:N Relationship XRM ToolBox Importing multiple values from a picklist field

Hi terrylynnd,

As per the link the Choices (multi-select) data type is currently unsupported. You need to enhance the feature by writing Power Automate, workflow extension, or plugin