Forum Discussion
vanme55
Oct 23, 2022Copper Contributor
Import Excel to Sharepoint List *with choices*
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 th...
fredmeissner
Aug 23, 2024Copper Contributor
If you separate the values like this, "Value1;#Value2;#Value3" it will automatically format them as choices in a "Choice" column. I only figured this out because when you select the values the "normal" way, this delimiter format shows up in the field for a split second!
k_312ce
Sep 19, 2024Copper Contributor
Can you provide an example of what you mean. Where are you putting those values?