Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

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

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

Categories:
  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Moderator 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 Moderator 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans