Forum Discussion

Copper Contributor

Oct 02, 2020

Unable to add existing list to Lists in Teams channel

I am having an issue adding an existing list to Lists in Teams. I can add all other lists from this group/site to the desired Teams channel, except this one. I am getting an error: "That link did not...

microsoft teams

NHarzic
Mar 15, 2021
That rings a bell. We created the SharePoint list by exporting from an Excel table. I am sure this is a similar problem, because if I create a new SharePoint list from scratch it is available in Teams Lists. I have found the workaround is to simply use the Website tab and paste in the list URL there. This seems to do exactly the same thing.
Thank you for your reply, Natalie

joeledvina

NHarzic

Iron Contributor

Mar 15, 2021

I just tried to show a member of staff how to do this and very frustratingly, it would not let me add an existing list. Unfortunately the user lost confidence and now wants to just use an Excel spreadsheet. I have been able to use the feature in other SharePoint Sites/Teams, so it is not clear why it suddenly doesn't work. Is there any update or any way to get this working? Thank you.

joeledvina
Copper Contributor
Mar 15, 2021
I think my problem was that I had created the list by exporting a query in Access directly to SharePoint. I got a simple reply somewhere else that adding such a list to Teams was not supported. The only workaround was to download the list to Excel and then upload to SharePoint as a new list, but that meant I had to re-create all of my views.
- NHarzic
  Iron Contributor
  Mar 15, 2021
  That rings a bell. We created the SharePoint list by exporting from an Excel table. I am sure this is a similar problem, because if I create a new SharePoint list from scratch it is available in Teams Lists. I have found the workaround is to simply use the Website tab and paste in the list URL there. This seems to do exactly the same thing.
  Thank you for your reply, Natalie
  
  joeledvina
  - pwintert
    Copper Contributor
    Dec 21, 2021
    This did work for me as well, its simple enough to do. Really strange the share link the site generates doesn't do the same thing. One concern I had is I wanted to change the permission to read only on the shared team. Anyway to adjust this so its read only while sharing it this way?