Oct 22 2022 07:10 PM
Oct 22 2022 07:10 PM
I have a large table I want to import from an Excel table. Most of the columns should be "Choice" types with Yes/No/NA options. I can import the table successfully, but it appears I have to change the column type for each column manually to "Choice" and also manually edit the options. Is there a way to import this information from the Excel table or is there a way to automate the input of the choice options?
Oct 23 2022 03:23 AM - edited Oct 23 2022 03:24 AM
@vanme55 when you select New list and From Excel, once you upload your list you will presented with a "preview" where you confirm the data type. By default it is Single line of text, so for each of your choice columns just change it to Choice and it will preserve the choice options from the Excel column for existing items and will allow you to select the choice for new items.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Apr 25 2023 03:01 PM
Jul 12 2023 12:06 AM
Jul 12 2023 02:27 AM
This is a known limitation/issue with the SharePoint lists while creating a new list by importing an excel file.
Choices/Options in the choice column settings will not be added automatically. Also, choices will not be shown in Grid view (quick edit view) even when those are shown while creating new lists.
You have to get the unique values from excel column and add those manually to your choice column settings. Follow: Excel - filter for unique values or remove duplicate values
You can raise a support ticket with Microsoft directly and report this behavior at: Get M365 Support - Online Support
And add new feedback/idea on SharePoint feedback portal to save choices in choice column as well so that Microsoft will implement it in near future: SharePoint Feedback Portal
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Jul 12 2023 05:14 AM