Forum Discussion
How to Stop SharePoint Lists from opening in Microsoft Lists?
Hi Kathryn Birstein,
By default, SharePoint lists will open in the Microsoft Lists app. According to the SharePoint admin message centre, Site owners can navigate to the Navigation Elements settings page and configure a new setting called “Lists in Sites”, which will enable lists to always open in their associated SharePoint site.
you can try to change this by using classic SharePoint setting, by navigating https://{tenantname}.sharepoint.com/sites/{sitename}/_layouts/15/navoptions.aspx
or going to the SharePoint Site classic settings and changing Navigation elements. Site owners can navigate to the Navigation Elements settings page and configure a new setting called “Lists in Sites”, which will enable lists to always open in their associated SharePoint site.
Please click Mark as Best Response & Like 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.
Kindest regards,
Leon Pavesic
Hi Kathryn Birstein,
By default, SharePoint lists will open in the Microsoft Lists app. According to the SharePoint admin message centre, Site owners can navigate to the Navigation Elements settings page and configure a new setting called “Lists in Sites”, which will enable lists to always open in their associated SharePoint site.
you can try to change this by using classic SharePoint setting, by navigating https://{tenantname}.sharepoint.com/sites/{sitename}/_layouts/15/navoptions.aspx
or going to the SharePoint Site classic settings and changing Navigation elements. Site owners can navigate to the Navigation Elements settings page and configure a new setting called “Lists in Sites”, which will enable lists to always open in their associated SharePoint site.
Please click Mark as Best Response & Like 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.
Kindest regards,
Leon Pavesic
LeonPavesic : morning, our Business Office demonstrated that their invoice list that is used to calculate the totals to bill specific departments is no longer functioning properly. The list has changed to the new list experience. The issues are such that the copying and pasting of cells, the dragging of a cell anchor to duplicate the contents across a range, and the refusal to select all rows consistently are disruptive to the point where they are losing confidence in the tool and moving back to Excel. I’m meeting with our 365 admin to investigate whether we can force the old style back on to staunch the bleeding, and unaware if this is even possible.
LeonPavesic Hi. I hace the same issue since yesterday, and so far it only happens to me, not anyone else. I have tried your solution but it didn't work out 😞 Any other tip? Thanks in advance.
- I am also suddenly having this problem starting last week. The fix mentioned here also did not work for me.
It doesn't seem to be switching to the LISTS environment so much as displaying within SharePoint as it would if opened in LISTS. Biggest problem being that this has caused all my multi-select lookup fields to stop recognizing each entry with unique links. Very frustrating.Hello,
One guy in our company has the same issue and the fix mentioned here is not working, there are a few things that I need to mention, I hope this will help.
1) I tried on different browsers, Edge and Chrome, the issue persists.
2) I tried on different computers, for example My account has no issues on my computer, or on his computer but his account has the issue on my computer and his.
3) The list is not opened in the MS List, is opened in SharePoint but it looks exactly like one opened in MS list, with the small list icon, the views in tabular form positioned horizontally and not vertically grouped like is the norm in SharePoint.
4) For the time being he is the only one with this issue in our company. (only tested this with 5 other people)
5) After I have applied the fix mentioned here I can see a difference in behavior when I (my account that has no issue) opens the list in MS List, is forcing the list to behave like in SharePoint even though is opened in MS List, and in SharePoint is behaving normal. But unfortunately for him this is doing nothing, the issue persists.
6) This does not affect all the lists, if a list was created from excel it does not have this issue, but if the list was created by any other means it will have the issue.
7) Other people with the same permission level do not experience this issue, only him.
😎All of us have the same Microsoft 365 E3 licence.
I came to the conclusion that this is a user issue.
But unfortunately I was not able to find any setting in the user account in regards to lists, either MS lists or SharePoint lists.
For us this is a big issue, because his SharePoint list is opened in MS list through SharePoint and some JSON formatting applied to the list is not functioning properly.
I really hope that a Microsoft employ will step in to come with a fix for this.LeonPavesic can you help us with this?
- OK, found the "Navigation Elements" setting. Any idea what the logic is for lists suddenly opening in Microsoft lists? This is causing CHAOS among my clients and there seems to be absolutely no reason for this change!
Hi Kathryn Birstein,
i can't givee you the answer why, but you can check the roadmap with more explanation about this change:
August 2023 - Microsoft 365 US Public Sector Roadmap Newsletter - Microsoft Community Hub
Please click Mark as Best Response & Like 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.
Kindest regards,
Leon Pavesic
LeonPavesic I just Googled for how to stop this. This is highly disruptive, confusing, and leaves us in IT scrambling to explain to our customers why the sudden change. Lists is great in itself, but forcing it onto users is unwanted, particularly with discarding the UI of the site you're on. 💢
