Announcements
Hello. I am trying to import data from an excel worksheet into an already existing Dataverse table. Data to the "text data type" columns was successfully imported but the columns with a "Choice data type" is not getting imported. Can someone help me with this please?
Hello, @Desta, as best practice, create the Dataverse Tables first with the Choice columns then use the Dataflows to load the data from excel.
I have this tutorial that coven the whole process:
https://powerplatformplace.com/f/excel-to-dataverse-migration---part-1
If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.
I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.
Visit my Blog: www.powerplatformplace.com
Hib @Desta,
How are you importing the data? Importing directly from Excel is super simple:
Ensure that the values in Excel matches the Label or the integer value of the Choices and it should work beautifully.
Hope this helps!
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314