r/sharepoint

Can't create list in Sharepoint

Apologies if this is a stupid question, how can I replicate this HTML behavior in Sharepoint for Office 365?

<ul>

<li><a href="www.google.com">Document 1</a></li>

<li><a href="www.google.com">Document 2</a></li>

<li><a href="www.google.com">Document 3</a></li>

</ul>

I'm not a trained sharepoint admin, but I got voluntold for the role since I have some basic web admin experience from back in the late 90's.

Here are the Web Parts I tried:

  1. "Link" - this doesn't work because it adds a web preview to the link instead of plain text. This clutters up the screen and takes up too much real estate, especially with all of the top and left menu bars that I have to inherent from the parent site, none of which I control.

  2. "Quick links" - Closest to what I'm looking for. Unfortunately, it forces things into 2 columns, even when I click the "List" layout option. Text also gets truncated very quickly to ... suffixes and I can't find the settings to set the number of columns, nor how many characters I truncate.

  3. "List" - I get all of Sharepoint's overhead space to add and remove and edit stuff. But I can't duplicate the <a href> behavior with a clean LINK TEXT, with the URL itself hidden. I have 2 columns: title, URL, and the URL is really long and ugly.

Am I insane for thinking this is supposed to be an easy problem to solve?

reddit.com
u/jyliu86 — 9 hours ago

False positive audit marks in SharePoint - what's actually causing them and how do you dig in

Been seeing FileMalwareDetected events pop up in Purview audit logs lately for files that are clearly clean, and, it got me thinking about how many people actually know how to investigate these properly vs just dismissing them. Worth flagging upfront: if you're seeing a spike in these right now, it may not be purely noise. CVE-2026-32201, a SharePoint spoofing vuln that was actively exploited and patched on April 14, was causing improper input validation issues that triggered false audit flags. CISA added it to the KEV catalog, so if you haven't patched yet, that's the first thing to do. Some of what looks like a false positive wave in your logs could be related, to that or to the RCE activity that's been generating audit noise since earlier this year. That said, the usual culprits are still very much a thing. OneDrive sync clients triggering scan activity that looks suspicious, third-party apps accessing content in patterns that, set off the detection engine, and signature-based scanning flagging benign files with embedded macros or unusual compression. All still common. When I dig into these, the first stop is always Purview Audit. Filter for FileMalwareDetected and pull the AuditData field. You'll get VirusVendor, VirusInfo, the file path, and site URL, which is usually enough to figure out whether it's a real hit or noise. VirusVendor showing "Default" means signature-based detection, "Advanced Threat Protection" means Safe Attachments caught it, and those I take more seriously. You can also run Get-SPOMalwareFile in PowerShell if you want to pull this programmatically rather than clicking through the portal. One thing to keep in mind: audit log retention in Purview varies by license, so, confirm your tenant settings before assuming you have the full 180 days to work with. If it does look like a false positive, submit through aka.ms/wdsi so Microsoft can update their detection. Cross-referencing timestamps and IPs in Defender for Cloud Apps also helps figure out whether the access pattern makes sense for a real user vs automated tooling. The thing that frustrates me is that with tool sprawl across multiple DLP policies and third-party scanners, the noise compounds fast, especially during a period like right now

reddit.com
u/jaivibi — 6 hours ago
▲ 3 r/sharepoint+1 crossposts

Creating a SharePoint list system with power automation

Hello I have been playing with copilot to create a new tax client tracker for my job. I am having issues with the directions. I am not seeing the same thing that copilot and other tutorials are describing. I am using the online SharePoint and Power Automation. Am I missing something?

reddit.com
u/Fire_badger_93 — 17 hours ago

ShareGate Page Migration from SharePoint 2013 to SharePoint Online Error

I am running into an error when trying to migrate pages from my old SharePoint 2013 site to SPO using ShareGate. ShareGate says the page was migrated successfully, and it is appearing in my site pages library, but when I click on the page it is giving a "Sorry, Something went wrong" error. I migrated about 5 pages, and it is happening on each one. Has anyone ran into this before?

reddit.com
u/Sufficient_Leg1315 — 11 hours ago

How to deliver Microsoft Tools (SharePoint, Forms, Power Automate) as an external party?

Hopefully this is the right place - I saw similar posts under this r/ but it didn't quite give me the answer I needed and I promise I've done a lot of research before posting, I just have a headache and need help.

I’m thinking of starting a consulting business delivering solutions using Microsoft 365 (SharePoint, Forms, Power Automate) to SMEs, and I’m trying to figure out the best practice for setting these up in a client’s tenant. I'm self taught and have done some cool automations and sites at my current company, so just wanted to build my knowledge and make some money from it, but probably didn't appreciate how much knowledge I still need to gain.

From the research so far I understand, there are a few ways to approach access:

Option 1 – Guest access:

Client invites me as a guest and I build everything inside their tenant.

Option 2 – Internal user account:

Client creates me as a licensed user (like a temporary employee) and I build everything as if I work there.

Option 3 – Build in my own tenant and deploy:

Using things like templates / scripts, I saw some information about .zip packages and PowerShell but honestly this one seems the most difficult / makes the least sense to me.

From what I’ve gathered, the best approach is:

Ask for two things - guest account with my business email, and a service account which would be generic client email.

Build SharePoint + Forms inside a Microsoft 365 Group (so ownership stays with the client). Using a service account for Power Automate flows (so they don’t break when I leave).

After all that, my question is really, does any of the above makes sense (i.e. if I were to go to a company and say set me up as a guest in your tenant and create a service account would they laugh me out of the building)?

What do consultants / external businesses do typically which is efficient and less effort?

Any help is much appreciated, I know I have a good business idea but unfortunately technical execution is a bit beyond me at the moment but always willing to learn. Thanks!

reddit.com
u/errmonth404 — 1 day ago

Powerplatform or M365 administration (Entra, SharePoint, Exchange, purview and intune). Which path has better scope in future ?

Hi I'm working as a sharepoint admin for the past 1.5 years in India and I'm looking for a field with good opportunities in the future despite the ai wave. Im confused whether should I learn powerplatform with Copilot studio or M365 administration with more depth in learning all tech stacks like IAM(Entra) , exchange, intune and purview. Can someone pls help to clear my confusion in choosing the right path 🙏.

reddit.com
u/LeaderSpare1075 — 23 hours ago

Microsoft Community Conference 2026

So only a few talks all week about SharePoint at the Microsoft Community Conference 2026. Mostly focused on Governance, and underpinning Copilot discussions.

Will be interesting to hear how folks are leveraging, and planning there long term maturity models for SharePoint. Most from what I hear are still treating it like an online fileshare.

reddit.com
u/digitalmacgyver — 1 day ago

PnP Site Template not transferring modern page WebParts. Is it actually possible?

Hey everyone,

I'm migrating our company's SharePoint Classic project site (~120 client sub-sites) to a modern SharePoint architecture. The plan is a Hub Site with one Team Site per client, provisioned automatically via Power Automate + PnP PowerShell.

What I've built:

  • A Hub Site "Projets PCI"
  • A template site (PCI-TemplateClient) with a custom home page including WebParts (document libraries, quick links, activity), a logo placeholder, custom navigation, and branded theme

The problem: No matter what flags I use when exporting, the home page WebParts never transfer properly to the new site. The structure (libraries, columns, navigation) comes through fine, but the page itself is either blank, duplicated, or missing the branding entirely.

Commands I've tried:

powershell

Get-PnPSiteTemplate -Out "gabarit-client.pnp"
Get-PnPSiteTemplate -Out "gabarit-client.pnp" -Handlers PageContents, Navigation, Lists, Fields
Get-PnPSiteTemplate -Out "gabarit-client.pnp" -IncludeAllClientSidePages

All result in either broken navigation (duplicated items), missing logo, wrong theme colors, or blank page content.

My questions:

  1. Is it actually possible to faithfully reproduce a modern SharePoint home page with WebParts using PnP provisioning in 2025/2026?
  2. Is there a reliable flag combination or approach that works?
  3. Would the -IncludeAllClientSidePages flag combined with something else solve this?
  4. Is the only real solution to build the page programmatically with Add-PnPPageWebPart in the provisioning script?

For context: we're using PnP PowerShell 3.x on PowerShell 7, Team Sites connected to M365 Groups, tenant is SharePoint Online.

Any help appreciated — this has been a week-long battle!

reddit.com
u/Stonk-Monkey69 — 1 day ago

Outlook Desktop + SharePoint Excel links -&gt; open in Excel as blank file (query params issue?) + WebView/Auth angle

Hey all,

we’re troubleshooting an issue that started ~2–3 weeks ago across our org and I’m trying to connect a few dots. Would appreciate any confirmation / workarounds.

🧾 Environment

  • Office: Microsoft Office Home & Business 2021
  • Apps: Outlook Desktop, Excel Desktop
  • Source: SharePoint / OneDrive links (.xlsx)
  • Auth: ADFS (on-prem)
  • OS: Windows 10/11

🔴 Main issue

When clicking a SharePoint Excel link from Outlook Desktop:

  • Outlook forces opening in Excel Desktop
  • Excel opens → blank (white) workbook
  • No error, no content

✅ Expected behavior

  • Link opens in browser (Edge/Chrome)
  • File loads correctly in SharePoint / Excel Online

🧪 Key observation (VERY important)

If we strip query parameters from the URL, it works:

❌ Broken:

https://tenant.sharepoint.com/.../file.xlsx?d=xxx&amp;e=xxx&amp;sharingv2=true&amp;fromShare=true&amp;at=9

✅ Working:

https://tenant.sharepoint.com/.../file.xlsx

🔎 What Outlook seems to do

Outlook Desktop appears to convert the link into something like:

ms-excel:ofe|u|https://...

or directly invokes:

excel.exe "https://..."

Which forces Excel Desktop instead of browser.

🧠 Hypothesis

This looks like a mix of:

  1. Excel not handling query params correctly
  2. Auth (ADFS) breaking inside Excel embedded WebView
  3. Outlook forcing desktop handler instead of browser

🔍 What we found (Process Monitor)

From ProcMon:

  • Excel accesses:%localappdata%\Microsoft\Office\16.0\Wef %localappdata%\Microsoft\Office\16.0\OfficeFileCache %localappdata%\Microsoft\OneAuth %localappdata%\Microsoft\IdentityCache
  • Heavy activity around:
    • WebView / embedded browser components
    • identity/token cache
    • SharePoint URL parsing

👉 Looks like Excel is trying to:

  • authenticate via embedded WebView
  • resolve the SharePoint URL with params
  • failing silently → resulting in blank screen

🧹 What we tested

Clearing caches:

%localappdata%\Microsoft\Office\16.0\OfficeFileCache
%localappdata%\Microsoft\Office\16.0\Wef
%localappdata%\Microsoft\OneAuth
%localappdata%\Microsoft\IdentityCache

👉 Result:

  • temporarily improved behavior
  • links sometimes started opening in browser

Re-registering Excel:

excel.exe /unregserver
excel.exe /regserver

👉 Result:

  • reset protocol handler
  • Excel launched “first-run”
  • behavior changed temporarily, then reverted

SharePoint setting:

Library → Advanced Settings → Opening Documents

  • set to:
    • “Use server default (open in browser)”
    • also tested “Open in browser”

👉 Outlook still forces Excel Desktop

Security finding

We also hit:

>

👉 SharePoint was being treated as:

  • Restricted Sites (zone issue / GPO?)

📱 Related issue (maybe same root cause?)

On mobile:

  • Microsoft Teams / Microsoft Outlook
  • login → white screen during auth
  • tied to ADFS

👉 suggests:
WebView + ADFS compatibility issue across platforms

❓ Questions

  1. Has anyone seen Excel Desktop fail specifically on SharePoint URLs with query params?
  2. Is Outlook Desktop known to incorrectly force ms-excel: handler in Office 2021?
  3. Any way to force browser-first behavior (without O365 policy)?
  4. Could this be a regression in:
    • Excel WebView handling
    • ADFS auth flow
  5. Any registry/GPO workaround for Office 2021?

💡 Current theory

This is NOT just one issue, but a combo of:

  • Outlook link handling (forcing Excel)
  • Excel WebView rendering/auth
  • ADFS compatibility
  • URL query param handling
  • possibly recent update/regression

Any insights, confirmations, or workarounds would be hugely appreciated 🙏

u/Decent-Ad-4 — 1 day ago

Was wondering if anyone’s looking for a SharePoint metadata analytics tool?

Hi all, quick intro to myself - currently a Systems Executive at a non profit, overseeing infrastructure, systems & projects.

Recent we rolled out a metadata for our SharePoint environment (term stored, managed metadata columns, mapped through content types & etc). But understanding how well adoption of these metadata tags are being applied across each site & libraries seems to be a huge oversight and no native solution available. So I was looking at building my own tool, to truly understand where the gaps are and overall usage of term sets and its individual terms.

Is this something other SharePoint admins have faced or how have you tackled it? I guess the thing I wanted to know is there any appetite for a SharePoint metadata analytics tool?

reddit.com
u/wwliul — 3 days ago

Duplicate Files in Sharepoint

We've inherited a lot of data duplication from migrating data as is from Shared Drives directly to Sharepoint, no data cleansing was done so there are in some cases vase swathes of duplicated data.

I'm running a powershell Script that is retrieving file lists from all Sites, retrieving modified/created date, owner, file size and version info.

Each site has its own File and there's also a separate file for files over 100MB

the 100MB file has already highlighted duplicated work under 100MB in the same area which is a good start, I don't know however how I'm going to present this to Data Owners.

Has anyone done something like this before? How did you present the data to Site Owners. I'm very cautious of sending them a report with thousands of lines in due to information overload.

reddit.com
u/temporaldoom — 5 days ago

I hate this platform

I hate sharepoint. I don’t know what else to say. The interface is insufferable, the permission settings are ridiculous. Every single day I have to beg IT support to make it functional. I can’t find any official documentation or explanation. I miss Google and I hate my work life. Does anyone have a glimmer of hope? Anything to help? I truly want to beat my head in.

reddit.com
u/flwrpwrweeewoooo — 4 days ago

Macbook for an M365/SharePoint Engineer?

Not strictly "SharePoint" but closely related and struggling to find other tech's to ask!

I'm strongly considering a Macbook Air based largely on the price/performance and general quality; I've dabbled with MacOS a few times over the years and always found it fine for my general use.

Nowadays though I work largely with M365, Azure, CoPilot, etc as a Digital Workplace Consultant (M365 Engineer essentially) - I guess I'm worried that a MacBook might give me some grief with elements of that even though about 99% of what I do is cloud based anyway, I know I can use Parallels to run Windows 11 Apps so I guess that would be a possible workaround; just wondered if anyone else on here is an IT "Techy" and could chip in!

reddit.com
u/Chrismscotland — 6 days ago

Good SharePoint permission resources

The 2025 Zscaler ThreatLabz VPN Risk Report got some attention in security circles, but one thing, it quietly reinforces is how much overprovisioned remote access compounds the risk once someone is in. VPN gets you through the door, but what's sitting exposed on SharePoint after that is often the real story.

Anyway, that sent me back through a bunch of resources I've collected over the past year specifically around SharePoint permissions auditing. Sharing here because I've never seen a good consolidated list for this sub.

What's in the list:

Microsoft's own effective permissions checker (buried in site settings, most people miss it) The SharePoint PnP PowerShell module, specifically Get-PnPPermissions, which can dump site/list/item level permissions recursively AvePoint's free permissions audit report tool (generates a readable export, useful for showing data owners what they actually own) Microsoft Purview's data access, reports if you're on E5, not perfect but covers a lot of ground for OneDrive and SharePoint For orgs with hybrid file server and SharePoint sprawl, tools like Netwrix Data Access Governance can resolve effective permissions across both environments including broken inheritance chains, which is where things usually get ugly

The broken inheritance problem specifically is what makes SharePoint so painful. Someone shares a folder with unique permissions in 2021, the site gets reorganized, and three years later nobody, knows that subfolder is still wide open to a group that includes former contractors who left long ago. The PnP script above surfaces most of that if you run it at item level, but it takes time to process on large libraries.

If anyone has other scripts or tools they've actually used in production I'd add them to my notes. The more the better for this kind of thing.

reddit.com
u/jaivibi — 5 days ago

Audit marks "FileDownloaded" but pretty sure I didn't

Hey there!

So, a while ago I was trying to change privacy settings on some PDFs we have on sharepoint; i poked around but, I wasnt able so I had to get IT involved. A few days ago, they ran an audit and it appeared like I downloaded the files; in the "operation" column of the audit it appeared as "FileDownloaded" so IT is asking now why I did so BUT as I said, I'm pretty sure I didnt.

Is there a chance of false positives or something that could've provoked that operation when I never downloaded anything to my disk?

Thanks!

reddit.com
u/Franz_McN — 4 days ago

Folders vs Document Libraries vs Sites

Hi all!

Working on building a clean setup for my admin team. They handle several categories of documents/data, e.g. personnel files, budget, facilities, etc. each category may have its own lists/pages as well. Wondering about the pros/cons of having individual folders for these categories in one doc library in one site vs. a separate doc library for each in one site vs. a separate site for each category.

Any thoughts? Trying to keep my architecture as flat as possible so the less nesting, the better, but also want it to be user friendly and not overdone. TIA!

reddit.com
u/Sufficient-Cap-6067 — 7 days ago

SharePoint ACS Retirement: How to handle Graph Sites.Selected for a Subsite?

Hey guys,

We’re hitting a wall with the SharePoint ACS retirement. We have a 10-year-old legacy site collection with multiple subsites. Our data team uses SSIS for automation on one specific subsite, and now that ACS is dead, the automation is failing.

We tried moving to a Registered App with Graph Sites.Selected, but we’re struggling to scope it. It seems Graph really wants to play at the root/Site Collection level.

The hurdles:

No App Passwords: We use a 3rd-party auth provider, so they are disabled tenant-wide.

Granular Access only: Security won't let us grant access to the entire parent/root site; we need to map the app specifically to that subsite's data.

Has anyone successfully mapped Sites.Selected to a subsite specifically, or found a modern workaround for legacy sites that doesn't involve over-provisioning permissions?

reddit.com
u/Ricky_Loops — 6 days ago

Using SharePoint libraries as a knowledge source for Copilot agents - how secure is it really

Been setting this up in our tenant lately and it's actually pretty solid once you understand what's happening under the hood. When you add a SharePoint library as a knowledge source in Copilot Studio, the agent, queries on behalf of the signed-in user, so it respects whatever permissions that person already has. Someone without access to a restricted library won't get content surfaced from it. That part works as advertised. Where it gets tricky is with oversharing. If your library permissions are already a mess (and honestly whose aren't), the agent will just inherit that mess. It doesn't clean anything up. So if half your org has read access to something they probably shouldn't, the agent will happily surface that content to them. Sensitivity labels and DLP through Purview help here but only if you've actually set those up properly beforehand. Also worth knowing there's a 20 source limit per agent and file size caps depending on your license tier, so for bigger setups you'll hit walls pretty fast. The other thing I've run into is restricted lists being a pain. Direct access sometimes throws errors with private content so there's a workaround floating around using, Power Automate to generate filtered PDFs dynamically instead of pointing the agent straight at the list. Bit clunky but it works. Curious if anyone else has found a cleaner way to handle that, or if you've run, into the indexing lag issue with larger libraries where the agent is pulling slightly stale content.

reddit.com
u/jaivibi — 6 days ago

Unable to remove a subsite

Hello,

I have a Sharepoint online subsite that’s no longer accessible (broken).

I need to delete it. But I could not because I cannot access to site information any longer.

Is there any way?

Thank you in advance.

reddit.com
u/ibteea — 6 days ago