Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by 5

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

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: N:N Relationship XRM ToolBox Importing multiple values from a picklist field

    Hi terrylynnd,

    You are welcome.

  • terrylynnd Profile Picture
    terrylynnd 5 on at
    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 Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    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

    pastedimage1670913330768v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans