Unable to add existing list to Lists in Teams channel

[JWhiteFEI]

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 work because you either do not have access or it is unsupported."

The channel is private and the list is not hosted on the sub-site for the private channel; rather its hosted on the main site. However, I was able to add other Lists from other sites to this private channel with no issue.

I have verified that the permissions are standard; same as all the other lists. I am an owner with Full Control. I can access and edit the list through SharePoint no problem. Any ideas as to why this may be happening?

[#2]

@JWhiteFEI 

We have the exact same issues:

#Microsoft lists
#Microsoft Teams
#Microsoft SharePoint

[#3]

@JWhiteFEI 

We have the same issues, but it is every sharepoint site. Hopefully MS fixes soon so you can use existing from non-group based SP sites and not just ones created from the app or group based.

[#4]

Same problem here with some lists. I have no idea what causes the list to be unsupported.

[#5]

I have the same problem. Only 3 of the 5 lists in my Team site are visible in the "Add an existing list" dialog. If I try to add either of the other two using a SharePoint link, I get this error. I was able to add a list from my organization's SharePoint site, but not a list that exists within my own Team site.

[#6]

I noticed that the two lists I couldn't add to Teams were the two lists that I created by directly exporting from Access to SharePoint. As a test, I tried exporting one of them from Access to Excel, then adding a new list to SharePoint based on the Excel file. That list could indeed be added to a Teams tab in SharePoint. That's a positive step and a clue, but I would much, much rather be able to add the existing list to Teams instead of having to re-create my formatting and views from scratch with a new list from Excel.

There's no "created by" flag on the list itself that I can see, only on records in the list. I can't find anything in the list settings that would make it work. 

[#7]

@JWhiteFEI 

Same here... interestingly, I had added it to a previous Team, same process, worked fine, is still fine, but i cannot add it to this one ...and I created the Team.

...very frustrating...and no answer here yet :( 

[#8]

Figured it out ...DOH! I copied a web page URL and not the actual URL of the list. The correct URL worked perfectly :)

[#9]

How do you get the correct URL?  is it the address bar?  #confused @CM-Ontario 

[#10]

@NeelamD1075 

If your URL in the address bar is like

https://<yourdomain>.sharepoint.com/sites/<yoursite>/Lists/<yourlistname>

with either

/<viewname>.aspx

or

?viewid=<lotsofrandomcharacters>

at the end, it should work whether you include that ending view information or not.

I suspect that @CM-Ontario's problem was that they were on a page with the list in a web part. If you are viewing a page with the list in a web part and you see a link named "See all" at the upper right corner, that will be the link to your list.

[#11]

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.

[#12]

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.

[#13 · Accepted solution]

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 

[#14]

Thank you, Natalie, for that workaround! I had another list that I wanted to view in Teams and did not want to re-create. It doesn't follow my "dark" theme, but I'd rather have that only on conversations anyway, so if anything it's an improvement for me over the default list tab.

[#15]

I've just hit this too. Has anyone gotten this working? In my case, I have a List in Team A, and I want to display it read-only as a List tab in Team B. I've granted Team B's group "Read" permissions to the list but get the same error as others here.

[#16]

Did you try sharing it in a "Website" tab, as Natalie suggested? That's what worked for me, and it works almost exactly like a List tab. If you created the list by exporting it directly from MS Access or MS Excel to SharePoint, adding it to a "List" tab is not supported. If you are able to add it to a "List" tab for Team A but not Team B, then you might have a different problem.

[#17]

Yes, works using the workaround suggested, and also when adding a SharePoint tab. I'd prefer not to use a workaround so I was wondering whether this is truly documented someplace as "unsupported", or a confirmed bug?

Thanks for your help.

[#18]

A StackExchange user purporting to be from Microsoft ("Trinetra-MSFT") stated (without references) that this is unsupported: https://stackoverflow.com/questions/64599675/cannot-add-sharepoint-list-to-teams-tab-when-the-list-w.... These are the only two threads I know of about this topic.

[#19]

@JWhiteFEI 

Does anyone know what causes this error? Are there certain columns or column type created by the Excel/Access export that cause the error (and that I could delete or reamke instead of remaking the full list?)

Or any update from Microsoft on whether they're trying to fix this?

[#20]

I had this same issue with a List that was created under a co-worker's account. When I recreated the list in the SharePoint site for the team, I was then able to add it as a tab in the team channel. In fact, I created the tab after creating the list, chose lists, add an existing list, and it found the list on the team's SharePoint website. I had to copy and paste each item (thankfully very few for this one) into the new list from the coworker's list to move the data.
1. Create the list in SharePoint.
2. Add the list as a tab in the team channel.
3. Add data (copy and paste or recreate).