Forum Discussion

Copper Contributor

Mar 26, 2021

Teams - problem creating lists from excel file

Hi, I have one problem when I try to create a list inside Teams. When I choose to upload or select excel file already uploaded I get this message : "An error occurred while creating your items. Missi...

How-to

microsoft teams

PeterRising

MVP

Mar 29, 2021

Hi, i've not had this problem. Nor can I recreate it. However this thread https://answers.microsoft.com/en-us/msteams/forum/msteams_tfb-msteams_file-msteams_suboth/microsoft-lists/8b8697aa-da21-48df-b04b-cbe6594b3e90 may give you some ideas hopefully.

Drazimir
Copper Contributor
Mar 31, 2021
PeterRising thank you for you r answer 🙂

If anyone is having the same problem, I was able to get over it. I uploaded the excel file to the Channel and then opened the same file in Excel online. Then I created a new excel file and copied the content in it. After that, the file was saved to my One Drive, so I uploaded ti again to teams channel. When I used this file for list creation everything went fine. Then I realise what the problem might be. Namely, the whole time I had MS Excel 365 opened with other file. I think that somehow when you try to import excel into the list, those credentials from opened excel file (and they were mine) was somehow in collision with credentials of my demo tenant user. When i CLOSED EXCEL COMPLETELY everything work as expected.

I hope that helps.

Drazen