Announcements
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
Hi terrylynnd,
You are welcome.
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.
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
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156