Forum Discussion
Diane Fligiel
Nov 11, 2020Copper Contributor
New SharePoint list choice column cannot add multiple values via copy paste
Is anyone else finding that this new 'feature' is giving their users the fits. I have had so many say to me I love the colors, but why can't I copy and paste my choices any more, this is taking me fo...
ganeshsanap
Dec 10, 2020MVP
Are you guys referring to copying choice column values from one item and pasting it to another list item in Edit in grid view?
This is working for me if I try to copy the complete cell and paste it in another item's cell. But I cannot copy individual choices (or selective like 3 out of 5 choices) from one cell to another cell.
This is not ideal solution for your question, But if you have multiple choices then you can copy the complete cell, paste it into another item's cell and remove unwanted choices from 2nd cell (I know this is not ideal for scenario where you have to remove more choices than you want to add ).
Hope it helps in some way!
Please click Mark as Best Response 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.
AndyOppelaar
Dec 10, 2020Copper Contributor
ganeshsanap No, for me it is that I cannot copy/paste a string of ';' delimited email addresses (for example from an excel file - via notepad) into a person/people column (with multiple entries allowed of course) in SharePoint Online. Both list and grid view.
I tried some Googled suggestions such as adding #1;#lastname1, firstname1;#2:@lastname2, firstname2;
Nothing works. Somehow SharePoint wants a TAB or ENTER after each name or email address to resolve it before accepting a second entry. Really annoying.