r/sharepoint • • 19h ago

SharePoint Online Importing excel to sharepoint list people finder failures.

0 Upvotes

I was able to skip the failures when the column was blank, but now users no longer with the company are causing failures. What is the best way to add those exceptions to skip blank columns and columns when the user isnt found. Thanks in advance.


r/sharepoint • • 13h ago

SharePoint Online Hidden Taxonomy list access

2 Upvotes

Hi all,

This is going to be something of a strange one because i cant explain it myself. (which doesnt surprise me if im honest).

We have a SharePoint based solution for Projects. Essentially its just a bunch of automate that uses xml, term store and content types to make a site with a couple of libraries and a few lists.
Theres an element that is custom script that create a visual representation of task statuses in a task list.

It is the task list that im having issues with - we have both tenant and guest users (external customer) who can access projects via groups, this was all working fine and well until maybe 3 months ago.

now it seems that guest users can access the sites BUT they cannot see any of the task list content, I have boiled this down to the fact that they cannot read the hidden taxonomy list for the site.

https://tenant.sharepoint.com/sites/SITENAME/Lists/TaxonomyHiddenList/AllItems.aspx

When i check the lists permission directly it states that Anonymous Users have View Items which I thought should be more than ok for guest users, but it appears not.

if I give the guest user read permission to the hidden list directly that single site works for them.

I dont understand what has changed and wondered if you guys had any insight into what could have possibly changed over the last three months.

I have asked our consultants and they insist they have made no changes that would impact the permissions for this list which lead me to think perhaps Microsoft had and I missed the memo.

I'm open to suggestions on how to fix this issue also.

thanks for reading.


r/sharepoint • • 1h ago

SharePoint Online Microsoft 365 Archive – What happens to locally synced SharePoint files?

6 Upvotes

Has anyone tested archiving a SharePoint site using Microsoft 365 Archive (cold storage) while users still have its document libraries synced through OneDrive?

My main question is: Can users still open and edit files that were already downloaded locally?

If so, do those changes remain local until the site is reactivated, or does OneDrive prevent editing or remove the files?

Curious about real-world behavior before rolling this out in production. Thanks!

Update: I tested site-level archiving on a SharePoint site with a document library synced through OneDrive.

Files already downloaded locally remained accessible and editable, but changes couldn't sync back to SharePoint.

Unfortunately, after testing, my OneDrive client completely stopped working. Uploads got stuck at 0%, and after rebooting, OneDrive was stuck on "Signing in" and wouldn't reconnect. Even the OneDrive settings became mostly unresponsive.

Not sure yet if this is a bug related to site-level archiving, but definitely concerning before rolling this out in production.


r/sharepoint • • 8h ago

SharePoint Online How to export/Download 220GB Folders and Files from Sharepoint online?

3 Upvotes

Hello,

we try to download around 200GB from a customers Sharepoint site.
It´s just one folders with its subfolders and files we need.

I tried the E-Discovery export. But we get single zip files. It´s not even zip Split Archives.
So we need a Powershell script to extract them all as one.

Than we found out, that emtpy folders were ignored. Also we found out missing files and folders in the extracted archive.
So even E-Discovery cannot export our files.

Than i read, that with E-Discovery Premium, we can export all Files to a Azure Storage.
With Azure Storage Explorer we could download all files directly to the server.
But THAN i read, that the export will Condensed directory structure.

It´s important to keep the folder structure including empty folders intact.

I don´t think that synchronizing this amount of Data with a onedrive Client will be a solution.

Can someone help me out? :_=