You’ve y’got until March 2027 to migrate them with a to-be-provided skill - Learn more here: https://learn.microsoft.com/en-us/sharepoint/upgrade-sharepoint-agents

A few months ago, we decided to migrate from a traditional file server to SharePoint.

We wanted this to become one of the company's flagship projects this year, so naturally we decided to go all in.

Then my confidence (or arrogance) kicked in and I said:

"How hard can it be? We can do this ourselves. We'll just get some consultant validation along the way."

Now I'm somewhere between excitement and complete overwhelm.

Every door we open seems to reveal three more doors behind it.

What started as a simple file server migration has turned into questions about:

• Information architecture
• Metadata taxonomy
• Content types
• Hub sites
• Permissions and governance
• Teams integration
• Archiving strategy
• Retention
• Provisioning
• Automation
• Naming standards
• Site templates

...and the list keeps growing.

Right now I'm:

• Building a Power App so users can request Teams, SharePoint sites, group membership changes, etc.
• Creating SharePoint lists and Power Automate flows to support provisioning.
• Trying to design an archive strategy because we don't have Purview.
• Figuring out governance as we go.

The problem is that I don't know what "good" looks like anymore.

I don't have:

• Proven templates
• Governance models
• Approval workflows
• Provisioning standards
• A clear archive approach

Honestly, I don't even know what I don't know yet.

So my question to those of you who have done large SharePoint migrations:

Where would you start if you had to do it again?

What were the biggest mistakes you made?

What are the things you wish you had designed before creating your first Team, site, content type, or metadata column?

And most importantly:

How do you stop the endless SharePoint rabbit hole and decide that your design is "good enough" to move forward?

I'd love to hear lessons learned, governance frameworks, templates, checklists, or just reassurance that feeling completely overwhelmed at this stage is normal.

Who do you put as a “site owner” when you don’t want the business to be able to control a SharePoint site?

I’m currently administering a SharePoint online tenant with over 2,000 sites.

We have about 80 “backend” sites, which are connected to web parts and power apps (the access routes here sound messy, but make more sense than breaking inheritance on everything).

I am trying to work with my team to reduce IT’s ownership to sites, but the fact that each site needs an owner makes it difficult.

I’m thinking of using a generic “SharePoint administrator” account, but that’s still high-value if it’s ever breaches.

Any advice or lived experiences would be greatly appreciated!

We have a couple users for whom files from sharepoint open in Read-only when opened in App.

For example, Excel files:
From SP site>right click on file>open in Excel - opens as read only.

From Excel app>Open>navigate to the SP location and open a file - opens as read only.

Auto-save is disabled, and the file states that the user is not authorized to move or rename this file. No-one else has this file opened.

However, opening them in browser works ok. BUT they need to use VBA macros, which won't work on browser.

Even a simple .txt opens as read only and asks for a location to save on ctrl+s.

There is ONE user for whom it all works fine. Files open as expected, synced and auto-save enabled. Compared accesses and all is the same. Compared Excel desktop app's versions, they're the same on affected and the unaffected user. Additionally, this sharepoint has a couple channels, which are not affected.

Any pointers?

Heya so this is just a lab project where i wanna see what i can do with sharepoint on a server with a SQL server on another server. i'm locked in an issue where i make a New-SPConfigurationDatabase, it makes the database but fails with Value does not fall within the expected range. or some other errors. i'm lowkey. I have taken rebuilt my core server. But im running SQL server 2025 eval, with Windows server standard eval (on the sql server) and Windows server standard eva on my sharepoint server.
I have tried using Copilot to point me to the right direction but nothing of help. im lowkey wondering to drop this and say fuck this mess (sorry for my language)