@EdevaldoCNH - you cannot import text fields into a Multi-Choice column or any other complex column type.
A common scenario is wanting import People display names from Excel into a Dataverse LookUp column to the AAD table (a people column). Even though a Dataverse AAD column displays the person’s Display Name, you cannot import the Display Names from Excel into a Dataverse AAD column because the Dataverse AAD column expects the AAD user ID.
In the example below, I want to update a Dataverse people column called “cr37a_employee_name_aad” with user display names. To do this, I need to enter the AAD user ID for each user into the Excel file instead of the Display Name, and then run the import.
Obviously, we need to identify what those AAD user IDs are. We need to go into the AAD table to identify what the AAD user ID value is for each person. To do this, export the AAD table into another Excel file. The only columns you care about are the Display Name column and the AAD user ID column.
Perform a lookup of this file in your Excel import file against each display name to return their associated AAD user id, and then run your import.
For Choices fields - single column choice columns only require the Label value in the import, whereas Multi Choice columns require the Choice Value. E.g.:
Hopefully the two examples above will give you an understanding of the concept and what you will need to do in your scenario.
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
