SharePoint topics

SharePoint List Migration to new Tenant

JakeGolden — Mon, 20 Apr 2026 17:11:32 GMT

Hi All,

I am preparing for a tenant-to-tenant migration of 60+ SharePoint lists that function as the back-end for various PowerApps. Since we are doing a staggered cutover, I need to perform an initial migration now and then run 'Delta' syncs over the next few weeks to catch new records, updates, and deletes.

My primary challenge is that SharePoint's native ID column is not preserved during manual migrations (PowerShell/CSV), which will break our App logic and Lookups. How have others handled cross-tenant list synchronization at this scale? Specifically:

How do you maintain record relationships and deep links when the system IDs change?
What is the most efficient way to handle deltas across 60 lists without buying expensive 3rd-party migration tools?

thanks,

Jake

Automated emails from SharePoint when new file added to sites document library

JonPAH — Mon, 20 Apr 2026 10:41:33 GMT

I have noticed in the last few months that I have been receiving emails from SharePoint Online when a new file has been added to a sites document library, these files specifically come from attachment questions on MS Forms we have in place. I have been trying to find out where these alerts are managed but to no avail.

I first thought to check the old soon to be deprecated alerts area, no rules set up. I then check the new rules section....nothing. Also ran an audit from that site to see what actions were taking place at the time of the email....no results. Finally tried to run a mail trace but "SharepointOnline" isn't a user object/mailbox in our database so no result would come back.

Has anyone else had any experience with this or luck managing it?

Can not delete page from search results

hst_de — Mon, 20 Apr 2026 09:46:28 GMT

I need help deleting a page from search. This is a translated page. I have already deleted the page, the page is deleted from all recycle bins. Same for the original page. The translated page is still showing up in the search results (this happened on friday).

What else I tried:

- Reindexed the SitePages library => didn't help

- Reindexed the entire SiteCollection => didn't help either

- Delete the page in the admin center (https://contonso-admin.sharepoint.com/_layouts/15/searchadmin/searchresultremoval.aspx) => Error message that the page cannot be found did not help

- New page created under the same URL (original + translation), published, deleted again => New page was in the search results, disappeared again, old page is still in the search results. So it didn't help either.

How can I really remove a search result from the search? I waited 4 days now and the page is still in the search results and everything I tried is not working properly.

Metadata being lost/corrupt

GaryS123 — Mon, 20 Apr 2026 08:29:04 GMT

Anyone seen this happen before ?

I have a metadata column called Business Area which has a choice column. Not too many files in the library, less than 100. We then group by Business Area.

The pic above shows a file that was in a Business Area called Regulation and Assurance - but the file for some reason loses the correct value in the column and pops out in its own 'unknown' business area. To fix it we have to change the column back to the correct value. This happens on a few different libraries that are setup like this.

Guest user invites other guest user

cristinapalomino — Fri, 17 Apr 2026 11:55:53 GMT

Hello,

I'm testing a scenario in SharePoint where I need guests to be able to invite other guests (not already existing in the directory).

Config applied:

Entra ID (external collab settings)

- “Anyone in the organization can invite guest users including guests and non-admins” is enabled

SharePoint online (tenant level)

- External sharing set to "new and existing guests" for both SharePoint and OneDrive

At site level

- Sharing set to “New and existing guests”

- Members with Edit permissions can share files and folders

No sensitivity label applied

Default sharing link type:

Set to “Specific people”

Test scenario

Internal user shares a file with Guest A - works

Guest A (with Edit permissions) tries to share the same file with:

Another existing guest - works

A new external email - fails

Error received:

“Your organization's policies don't allow you to share with these users. Please contact your IT department for help.”

Quick Launch missing from SharePoint subsite after deleting links

MeaganUTSW — Thu, 16 Apr 2026 14:25:28 GMT

The Quick Launch navigation has disappeared from one SharePoint subsite (Marketing) after I deleted some placeholder links on a Marketing page.

It was working previously, and still appears on other subsites in the same site collection. In Site Settings, Quick Launch is still enabled, but there is no option to add or edit navigation links anymore, and the left navigation is completely gone on this subsite.

Has anyone seen this before or know how to restore the Quick Launch for just one subsite?

Thank you!

Restirct user access to SPO Root SiteCollection

mobun — Thu, 16 Apr 2026 13:49:56 GMT

Hi everyone,

In a tenant, the SharePoint Online root site collection was deliberately locked down to a very small audience.

We are currently seeing some issues that could be related to this. While investigating, I noticed that some Microsoft documentation seems to imply that the root site collection plays a special role and should be accessible for the users, for example:

However, I couldn’t find any explicit or official recommendation stating whether restricting access to the root site collection is supported or discouraged.

So my question is:
Is it a best practice or implicit requirement that the root site collection remains broadly accessible for M365 / SharePoint Online to work reliably?

Thanks!

How best to apply extensive edits to a live page?

kimberly32 — Tue, 14 Apr 2026 20:32:05 GMT

What are best practices for extensive editing of a live page?
I've seen some cautions against working in a prolonged editing session of a live page without publishing it. Instead, some recommend making a working copy of the live page and then when the working copy is ready to publish, you would change the live page URL to something else, followed by changing the working page URL to the original live page's URL and then publishing. What are the pros and cons of this approach?

Is there a better way?

Users unable to determine who has access to document library due to security groups

TonyTech2026 — Tue, 14 Apr 2026 15:08:44 GMT

Greetings,

Maybe I went about this the wrong way. Looking for advice on either the proper way we should be moving forward on this or any other comments or insight we should be considering.

This is for SharePoint online via Microsoft 365 Business license.

Scenario:
1. SharePoint Document Library per department (Each Document Library exists in its own SharePoint site), essentially being used as a company drive.
2. Some users should only officially have access to specific folders in some of the document library.
3. If say a person in accounting has access to some specific folders, and either they are replaced or a new accounting user comes in.... should be able to reference the access the existing person has in order to give the same access to the new user.
4. Common Request: Give UserB the same folder access as UserA.
5. Some users should have access to the entire document libraries while other users only have access to specific subfolders.

Current Implementation:
1. In Entra, created Security Groups that tied to specific folders.
-- For Example for the accounting folder, only management has access to the entire folder but the accounting staff only have access to specific folders. So like there is a FiscalYear2024 folder, so I created a security group called sec-Accounting-FiscalYear2024 and assigned the members that should only have access to that folder and not the rest of the library.
-- My thought behind this was if a new user was replacing the existing user or joining the department, I can just reference the existing user security group membership and copy it to the new user.
2. In the SharePoint document Library, I create a shareLink that is assigned to the security group I made for that access. Then I give that link to the users I assigned the membership to.

Current Issue:
1. Aside from the official document sharing/access that is being done from the security groups above. There are occasions where users of a sharepoint need to share specific files or folders to other users.
2. However, they are all panicking and confused because aside from themselves they are unsure who has access to the existing folders/files in the document library.
3. When going to manage permissions of a file/folder, it only shows the group assigned to it but not the members of the group.
4. So since users can't see the members of the group assigned to a folder, they have no idea who has access to that folder and are getting confused.

If this was an NTFS drive, it would be super easy for users to see who has access and etc by looking at the properties but I'm stuck behind some limitations of sharepoint I didn't realize existed until I tried to implement certain workflows.

Any advice here would be greatly appreciated, as my implementation has turned into a point of frustration for end users.

Thank you in advance!

How do I make a main hubsite link available on every SharePoint page and site?

EvanSP_555 — Fri, 10 Apr 2026 16:41:27 GMT

We have multiple hub sites in SharePoint, but one central landing page, HUB SITE that should be accessible from everywhere. How can we provide a consistent global link or navigation to this page across all sites and pages, including system pages where the hub header is not visible?

PnP Template Error: "Invalid field name {guid}

IT_Bee — Fri, 10 Apr 2026 15:42:19 GMT

Hello,
I'm trying to apply a site template from one SharePoint Online site to another using PnP PowerShell. I have custom lists, some of them with a specific dependency chain:

List X has a lookup to List Y.

List Y has a lookup to List Z.

All libraries/lists have "Allow management of content types" enabled.

The cmdlets I run:

Export:

Get-PnPSiteTemplate -Out template.pnp -Handlers All -IncludeAllClientSidePages -PersistBrandingFiles

Import:

Invoke-PnPSiteTemplate -Path template.pnp

The Error:

During the Invoke process, I get:

Invoke-PnPSiteTemplate : Invalid field name {guid} targetsharepoint site

What I’ve tried:

I attempted to manually remove the ID="{guid}" attributes from the XML inside the .pnp package, but that just makes the template schema invalid.
Verified that I am connected to the target site with owner permissions.

How can this issue be fixed?

Any help would be greatly appreciated!

Thanks!

Add Flow to Automate Ribbon - List

ctedesco3307 — Tue, 07 Apr 2026 14:51:19 GMT

Is there a way to add additional flows to the Automate option in SharePoint lists? Just has Set a Reminder or Request Sign off as the defaults in my site.

Thank you

DeDup for SharePoint

pmarsh508 — Fri, 03 Apr 2026 15:12:17 GMT

Hi All:

I just spun up DeDup for SharePoint SaaS and it looks very straight forward. Wondering if there are any pinch points or gotchas folks have run into? I really want to fire off an auto clean up but I'm very apprehensive as this is my first run with the solution.

TIA

Upcoming change: Retirement of noise suppression capability for ODSP video

Dwyane George — Thu, 02 Apr 2026 00:36:53 GMT

We're writing to inform you of an upcoming change to video playback features in OneDrive and SharePoint.

What's changing:

Starting July 1, 2026, the noise suppression feature for video playback on OneDrive and SharePoint will be retired. This feature, which reduces background noise during video playback, will no longer be available in the web playback experience.

Based on usage data and our ongoing effort to streamline the video experience on OneDrive and SharePoint, we've made the decision to deprecate this capability.

Please share your feedback through Noise Suppression Feature Survey so we can continue to improve the video experience on OneDrive and SharePoint.

What this means for your content:

Your video content is not affected. No original files will be modified or re-encoded – this change only impacts the playback experience.
Noise suppression will no longer be available as a playback toggle option when viewing videos stored on OneDrive or SharePoint.
No changes to other video and audio playback features – including playback speed controls, captions, and transcripts – remain available and are unaffected by this change.

What administrators need to know:

No admin action is required. The noise suppression option will be removed automatically after the retirement date. There are no tenant-level settings to manage for this change.

Alternative options:

If noise suppression is important to your workflow, please consider these alternatives:

Pre-process your audio using a dedicated noise removal tool before uploading to OneDrive or SharePoint.
Record in a quieter environment or use a directional microphone to minimize background noise at the source.

We value your feedback:

We understand this change may affect some of your workflows, and we want to hear from you. Please share your feedback through Noise Suppression Feature Survey so we can continue to improve the video experience on OneDrive and SharePoint.

All other video playback capabilities on OneDrive and SharePoint remain fully available. We're committed to continuing to invest in features that help you get the most out of your video content.

Site header: overflows to navigation bar

JoeR — Wed, 01 Apr 2026 11:37:00 GMT

We use SharePoint for our intranet, and with a rebrand coming, we're building new headers for each of the sites that make up the intranet.

Since we first built our sites, the site header behaviour seems to have changed: it overflows vertically into the navigation bar, rather than constraining it to the height of the actual header (above the nav).

Not ideal, but I'd adjusted where the business logo sits in the height to work well.

However, when you scroll down and the header compresses, this chops the top half of the logo off.

Anyone have any similar experience/solutions? I don't want to deploy a CSS code, as that's likely to break later. Alternatively, if the lovely people at Microsoft could put it back to constrain it within the banner height, that'd be great. It's easier to create a super wide image (to avoid gaps) than it is to juggle the variables when height overflows differently on different screens.

Thanks in advance!

Connect to Outlook button greyed out for select users

JackFV — Fri, 27 Mar 2026 11:57:01 GMT

Hi All,

Some of our users are facing the issue where their Connect to Outlook button is greyed out on their SharePoint calendar. This is a classic list and they are on classic Outlook, with all the adequate permissions.

Myself and my colleagues are unable to replicate this, we are on both classic and new Outlook and the button is available. We have created accounts to mirror their permissions exactly and still can not replicate it.

Is Microsoft slowly removing this feature? It would be great to have some confirmation so we can confirm if this is an issue for us to resolve or if unfortunately there is nothing we can do about it.

Thanks!

Trying to use Lists as a very basic CRM but having search issues

Cynapse — Thu, 26 Mar 2026 22:26:41 GMT

Hey All,

I have a small business I'm considering using Lists to track some very basic client info and build a client database that is accessible to all employees on the company SharePoint site (we use MS 365). Workflow would be something like:

Client calls in
Receptionist(s) answer
- If new client, create an entry with first/last name, phone #, email address, their spouse's name (if any) and a Notes section to jot down notes from the call.
- If current client, receptionist can use search to find client, make new notes, read previous notes, etc

That is basically it. I have this set up in Lists right now as a test with just two clients, each with a spouse. When I do a search for the person's name (Bill or Franklin), it returns a result. When I search for their spouses name (Susan), it returns nothing. I've run through the settings, reindexed the list, etc, and I just can't get a simple search to work.

Am I attempting to use this correctly? Both name columns are single line fields. TYIA for any input!

Anyone having issues moving SharePoint web parts today?

JustDiggz — Thu, 26 Mar 2026 14:11:50 GMT

I have received several reports this morning regarding issues with moving web parts in both communication sites and Teams sites. I was able to reproduce, but am unsure if this is an internal issue or some larger issue. When trying to move web parts instead of moving between sections or around the flexible section it simply highlights all text boxes in the vicinity. This also occurs when attempting to move web parts using the "move section" button in the properties bar. Anyone else experiencing this issue this morning?

Automating SharePoint Site Status Reporting with PowerShell

SureshRamasamy1983 — Tue, 24 Mar 2026 13:44:02 GMT

Introduction

Migrating Microsoft 365 workloads is a critical step during organizational transitions such as mergers or de‑mergers. SharePoint site collections often contain business‑critical data, and ensuring visibility into their readiness is essential for a smooth migration.

To address this, I developed a PowerShell script that automatically generates a SharePoint Site Status Report, categorizing sites into Active, Read‑Only, and Offline. This report provides administrators and migration engineers with actionable insights to plan and execute migrations confidently.

Why This Matters

Visibility: Quickly assess site readiness across all web applications.
Governance: Ensure compliance and proper access controls.
Efficiency: Automate reporting to reduce manual effort.
Risk Mitigation: Identify offline or read‑only sites before migration.

How It Works

The script leverages the SharePoint Management Shell and runs under the Farm Account with elevated permissions. It performs the following steps:

Loads SharePoint cmdlets.
Iterates through all web applications.
Categorizes sites into Active, Read‑Only, and Offline.
Compiles results into a structured CSV/Excel/HTML report.
Sends the report via email to stakeholders.

Key PowerShell Cmdlets

Add-PSSnapin Microsoft.SharePoint.PowerShell
Get-SPWebApplication
Get-SPSite -WebApplication -Limit All
$site.ReadOnly / $site.Status
Export-Csv
Send-MailMessage

Parameters to Replace

Before running the script, update these placeholders:

SMTP Server → mail.company.com → replace with your mail server
Sender Address ($from) → email address removed for privacy reasons → replace with reporting account
Recipient Address ($to) → email address removed for privacy reasons → replace with stakeholder distribution list
Email Subject ($subject) → "SharePoint Site Status Report" → customize for clarity
Report File Path ($csvPath) → C:\Reports\SharePoint_SiteStatusReport.csv → replace with desired location
Web Application URLs → ensure correct farm references
Execution Context → must run under Farm Account

Conclusion

This automated reporting solution provides clarity, governance, and efficiency during SharePoint migrations. By categorizing sites and delivering structured reports, administrators can prioritize tasks, mitigate risks, and ensure a seamless transition to Microsoft 365.

Code:

#Adding Snapin for SharePoint

#Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue

$TodayDate =Get-Date

Write-Host $TodayDate

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

##My Connect

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

# WebSites

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

##Websites

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

## Websites

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

##FGC-SalesShareWebSites

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

##WebSites

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

##WebSites

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

##WebSites

$FileName = "C:\Results_Active_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_Readonly_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

$FileName = "C:\Results_NoAccess_WebSites.txt"

if (Test-Path $FileName) {

Remove-Item $FileName

}

Add-PSSnapin Microsoft.SharePoint.Powershell

[string[]]$WebapplicationList = ""

Foreach($Webapp in $WebapplicationList)

{

Write-Host $Webapp

$displaywebappname=Get-SPWebApplication $webapp

$webappname=$displaywebappname.name

Write-Host $webappname

$Sites = Get-SPWebApplication $webapp | Get-SPSite -limit all | foreach {

if ($_.ReadOnly -eq $false -and $_.ReadLocked -eq $false -and $_.WriteLocked -eq $false)

{

$Result =”Site is Active”

$save2= "Results_Active_${webappname}.txt"

#Write-Host $save2

$saveCSVactive="Results_Active_${webappname}.csv"

$_.RootWeb.Title +”`t” + $_.URL + “`t” + $Result | Out-File $save2 -append

#$_.RootWeb.Title +”`t” + $_.URL + “`t” + $Result | Out-File $saveCSVactive -Append

}

elseif ($_.ReadOnly -eq $true -and $_.ReadLocked -eq $false -and $_.WriteLocked -eq $true)

{

$Result = “Site is Read-Only”

$save1= "Results_Readonly_${webappname}.txt"

$_.RootWeb.Title +”`t” + $_.URL + “`t” + $Result | Out-File $save1 -Append

}

elseif ($_.ReadOnly -eq $null -and $_.ReadLocked -eq $null -and $_.WriteLocked -eq $null)

{

$Result=”Site status is No Access”

$save3= "Results_NoAccess_${webappname}.txt"

#$_.RootWeb.Title +”`t” + $_.URL + “`t” + $Result | Out-File $save3 -Append

$_.URL +”`t” + $_.RootWeb.Title + “`t” + $Result | Out-File $save3 -Append

}

$TodayDate =Get-Date

Write-Host $TodayDate

sleep -Seconds 100

#Active Sites WebSites

$ActiveSites_Websites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

Write-Host "Websites Active sites" $ActiveSites_Websites.count

$Websites_ActiveSitescount = $ActiveSites_Websites.count

#Read-only Sites WebSites

$ReadonlySites_Websites=Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

Write-Host "Websites Read-only Sites" $ReadonlySites_Websites.count

$Websites_Readonlysitescount=$ReadonlySites_Websites.count

#No-Access Sites WebSites

$NoaccessSies_Websites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

Write-Host "Websites No-Access Sites" $NoaccessSies_Websites.count

$Websites_NoAccessSitesCount=$NoaccessSies_Websites.count

#Active Sites WebSites

$ActiveSites_WebSites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

Write-Host "WebSites Active sites" $ActiveSites_WebSites.count

$WebSites_ActiveSitescount = $ActiveSites_WebSites.count

#Read-only Sites WebSites

#$Readonlysite_WebSites =Get-Content -Path C:\Results_Readonly_Websites.txt | Measure-Object

#If($Readonlysite_WebSites -eq $null)

#$WebSites_Readonlysitecount ="0"

#else{

$Readonlysite_WebSites =Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

Write-Host "WebSites Readonly Sites" $Readonlysite_WebSites.count

$WebSites_ReadonlySitesCount= $Readonlysite_WebSites.count

# Write-Host $WebSites_ReadonlySitesCount

#WebSites - No Access Sites

#$NoAccessSites_WebSites= Get-Content -Path "C:\Results_NoAccess_Websites.txt"

$NoAccessSites_WebSites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

Write-Host "WebSites NoAccess Sites" $NoAccessSites_WebSites.count

# #Write-Host "Site Count $($NoAccessSites_WebSites.Count)"

$WebSites_NoAccessSitesCount= $NoAccessSites_WebSites.count

##################################################################

# #Active Sites Websites

$ActiveSites_WebSites= Get-Content -Path "C:\Results_Active_Websites.txt" | Measure-Object

Write-Host "WebSites Active sites" $ActiveSites_WebSites.count

$WebSites_ActiveSitescount = $ActiveSites_WebSites.count

# #Read-only Sites WebSites

$ReadonlySites_WebSites=Get-Content -Path "C:\Results_Readonly_Websites.txt" | Measure-Object

Write-Host "WebSites Read-only Sites" $ReadonlySites_WebSites.count

$WebSites_Readonlysitescount=$ReadonlySites_WebSites.count

# #No-Access Sites WebSites

$NoaccessSies_WebSites= Get-Content -Path "C:\Results_NoAccess_Websites.txt" | Measure-Object

Write-Host "WebSites No-Access Sites" $NoaccessSies_WebSites.count

$WebSites_NoAccessSitesCount=$NoaccessSies_WebSites.count

# #Active Sites Websites

$ActiveSites_WebSites= Get-Content -Path "C:\Results_Active_Websites.txt" | Measure-Object

Write-Host "WebSites Active sites" $ActiveSites_WebSites.count

$WebSites_ActiveSitescount = $ActiveSites_WebSites.count

# #Read-only Sites WebSites

$ReadonlySites_WebSites=Get-Content -Path "C:\Results_Readonly_Websites.txt" | Measure-Object

Write-Host "WebSites Read-only Sites" $ReadonlySites_WebSites.count

$WebSites_Readonlysitescount=$ReadonlySites_WebSites.count

# #No-Access Sites WebSites

$NoaccessSies_WebSites= Get-Content -Path "C:\Prod\Results_NoAccess_Websites.txt" | Measure-Object

Write-Host "WebSites No-Access Sites" $NoaccessSies_WebSites.count

$WebSites_NoAccessSitesCount=$NoaccessSies_WebSites.count

# #WebSites

# #Active Sites WebSites

##$ActiveSites_WebSites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

##Write-Host "WebSites Active sites" $ActiveSites_WebSites.count

##$WebSites_ActiveSitescount = $ActiveSites_WebSites.count

# #Read-only Sites WebSites

##$ReadonlySites_WebSites=Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "WebSites Read-only Sites" $ReadonlySites_WebSites.count

##$WebSites_Readonlysitescount=$ReadonlySites_WebSites.count

# #No-Access Sites WebSites

##$NoaccessSies_WebSites= Get-Content -Path "C:\Results_NoAccess_WebSites" | Measure-Object

##Write-Host "WebSites No-Access Sites" $NoaccessSies_WebSites.count

##$WebSites_NoAccessSitesCount=$NoaccessSies_WebSites.count

# #WebSites

# #Active Sites WebSites

##$ActiveSites_WebSites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

##Write-Host "WebSites Active sites" $ActiveSites_WebSites.count

##$WebSites_ActiveSitescount = $ActiveSites_WebSites.count

# #Read-only Sites WebSites

##$ReadonlySites_WebSites=Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "WebSites Web Read-only Sites" $ReadonlySites_WebSites.count

##$WebSites_Readonlysitescount=$ReadonlySites_WebSites.count

# #No-Access Sites WebSites

##$NoaccessSies_WebSites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

##Write-Host "WebSites Web No-Access Sites" $NoaccessSies_WebSites.count

##$WebSites_NoAccessSitesCount=$NoaccessSies_WebSites.count

# #Websites

# #Active Sites Websites

##$ActiveSites_Websites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

##Write-Host "Websites Active sites" $ActiveSites_Websites.count

##$Websites_ActiveSitescount = $ActiveSites_Websites.count

# #Read-only Sites Websites

##$ReadonlySites_Websites=Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "Websites Read-only Sites" $ReadonlySites_Websites.count

##$Websites_Readonlysitescount=$ReadonlySites_Websites.count

# #No-Access Sites Websites

##$NoaccessSies_Websites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

##Write-Host "Websites No-Access Sites" $NoaccessSies_Websites.count

##$Websites_NoAccessSitesCount=$NoaccessSies_Websites.count

# #Websites

# #Active Sites Websites

##$ActiveSites_Websites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

##Write-Host "Websites Active sites" $ActiveSites_Websites.count

##$Websites_ActiveSitescount = $ActiveSites_Websites.count

# #Read-only Sites Websites

##$ReadonlySites_Websites=Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "Websites Read-only Sites" $ReadonlySites_Websites.count

##$Websites_Readonlysitescount= $ReadonlySites_Websites.count

# #No-Access Sites Websites

##$NoaccessSies_Websites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

##Write-Host "Websites No-Access Sites" $$NoaccessSies_Websites.count

##$Websites_NoAccessSitesCount=$NoaccessSies_Websites.count

# #Websites

# #Active Sites Websites

##$ActiveSites_Websites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

##Write-Host "Websites Active sites" $ActiveSites_Websites.count

##$Websites_ActiveSitescount = $ActiveSites_Websites.count

# #Read-only Sites Websites

##$ReadonlySites_Websites=Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "Websites Read-only Sites" $ReadonlySites_Websites.count

##$Websites_Readonlysitescount=$ReadonlySites_Websites.count

# #No-Access Sites Websites

##$NoaccessSies_Websites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

##Write-Host "Websites No-Access Sites" $NoaccessSies_Websites.count

##$Websites_NoAccessSitesCount=$NoaccessSies_Websites.count

# #WebSites

# #Active Sites Websites

##$ActiveSites_Websites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

##Write-Host "Websites Active sites" $ActiveSites_Websites.count

##$Websites_ActiveSitescount = $ActiveSites_Websites.count

# #Read-only Sites Websites

##$ReadonlySites_Websites= Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "Websites Read-only Sites" $ReadonlySites_Websites.count

##$Websites_Readonlysitescount=$ReadonlySites_Websites.count

# #No-Access Sites Websites

##$NoaccessSies_Websites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

##Write-Host "Websites No-Access Sites" $NoaccessSies_Websites.count

##$Websites_NoAccessSitesCount=$NoaccessSies_Websites.count

# #WebSites

# #Active Sites Websites

##$ActiveSites_Websites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

##Write-Host "Websites Active sites" $ActiveSites_Websites.count

##$Websites_ActiveSitescount = $ActiveSites_Websites.count

# #Read-only Sites Websites

##$ReadonlySites_Websites= Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "Websites Read-only Sites" $ReadonlySites_Websites.count

##$Websites_Readonlysitescount=$ReadonlySites_Websites.count

# #No-Access Sites Websites

##$NoaccessSies_Websites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

##Write-Host "Websites No-Access Sites" $NoaccessSies_Websites.count

##$Websites_NoAccessSitesCount=$NoaccessSies_Websites.count

# #WebSites

# #Active Sites Websites

##$ActiveSites_Websites= Get-Content -Path "C:\Results_Active_WebSites.txt" | Measure-Object

## Write-Host "Websites Active sites" $ActiveSites_Websites.count

##$Websites_ActiveSitescount = $ActiveSites_Websites.count

# #Read-only Sites Websites

## $ReadonlySites_Websites= Get-Content -Path "C:\Results_Readonly_WebSites.txt" | Measure-Object

##Write-Host "Websites Read-only Sites" $ReadonlySites_Websites.count

##$Websites_Readonlysitescount=$ReadonlySites_Websites.count

# #No-Access Sites Websites

##$NoaccessSies_Websites= Get-Content -Path "C:\Results_NoAccess_WebSites.txt" | Measure-Object

##Write-Host "Websites No-Access Sites" $NoaccessSies_Websites.count

##$Websites_NoAccessSitesCount=$NoaccessSies_Websites.count

$TotalActiveSite = ($Websites_ActiveSitescount + $WebSites_ActiveSitescount + $WebSites_ActiveSitescount + $WebSites_ActiveSitescount + $WebSites_ActiveSitescount + $WebSites_ActiveSitescount + $Websites_ActiveSitescount + $CTLQwest_ActiveSitescount + $RecordsCenter_ActiveSitescount + $Websites_ActiveSitescount + $Websites_ActiveSitescount + $Websites_ActiveSitescount + $Websites_ActiveSitescount + $Websites_ActiveSitescount)

$TotalReadonlySites = ($Websites_Readonlysitescount + $WebSites_ReadonlySitesCount + $WebSites_Readonlysitescount + $WebSites_Readonlysitescount + $WebSites_Readonlysitescount + $WebSites_Readonlysitescount + $Websites_Readonlysitescount + $Websites_Readonlysitescount + $Websites_Readonlysitescount + $Websites_Readonlysitescount + $Websites_Readonlysitescount + $Websites_Readonlysitescount)

$TotalNoAccessSite = ($Websites_NoAccessSitesCount + $WebSites_NoAccessSitesCount + $WebSites_NoAccessSitesCount + $WebSites_NoAccessSitesCount + $WebSites_NoAccessSitesCount + $WebSites_NoAccessSitesCount + $Websites_NoAccessSitesCount + $Websites_NoAccessSitesCount + $Websites_NoAccessSitesCount + $Websites_NoAccessSitesCount + $Websites_NoAccessSitesCount + $Websites_NoAccessSitesCount)

#Total Sites

$TotalWebSites = ($WebSites_ActiveSitescount + $WebSites_Readonlysitescount + $WebSites_NoAccessSitesCount)

$TotalWebSites = ($WebSites_ActiveSitescount + $WebSites_ReadonlySitesCount + $WebSites_NoAccessSitesCount)

$TotalWebSites = ($WebSites_ActiveSitescount + $WebSites_Readonlysitescount + $WebSites_NoAccessSitesCount)

$TotalWebSites = ($Websites_ActiveSitescount + $Websites_Readonlysitescount + $Websites_NoAccessSitesCount)

$TotalWebSites =($Websites_ActiveSitescount + $Websites_Readonlysitescount + $Websites_NoAccessSitesCount)

$TotalWebSites = ($Websites_ActiveSitescount + $Websites_Readonlysitescount + $Websites_NoAccessSitesCount)

#====== All Sites Count

$TotalSites =($TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites + $TotalWebSites)

#Sending Email

#================

#[string[]]$recipients = ""

$recipients11 = @("")

#[string[]]$recipients = ""

# ""

$smtp = "smtp"

#$to = $recipients11

$from = ""

#$from = ""

$subject = "SharePoint Sites Current Status"

$body = " Date -$todaydate "

#$attachment11="C:\Results_Active_Web.txt","C:\Results_Active_Web.txt"

#$body = " SP-Apps Read-only Sites Count - $Readonlysitecount "

#$body += " SP-Apps Active Sites Count - $ActiveSitescount "

#$body += " SP-Apps No-Access Sites Count - $NoAccessSiteCount "

#$body += "Click <a href=http://www.google.com>here</a> to open google "

#### Now send the email using \> Send-MailMessage

#=========

$report = "<html>

<style>

{font-family: Arial; font-size: 15pt;color: #F70707; }

{color:#F70707;}

TABLE{border: 1px solid black; border-collapse: collapse; font-size:15pt;}

#TH{border: 1px solid black; background: #F4D03F; padding: 5px; color: #000000;}

TR{color: #2E86C1;text-align: center;background: #13B5ED; padding: 5px; color: #0F0F0F;}

TH{border: 1px solid black; background: #F4D03F; padding: 5px; color: #F70707;}

TD{border: 1px solid black; padding: 5px; }

H2{color: #F70707;}

H1{Color: #0C0B0A;}

</style>

<h1> SharePoint Sites Current Status</h1>

<table>

<tr> <td> Web Application </td> <td> Active Sites </td> <td> Read-Only Sites </td> <td> No-Access (Locked) Sites </td> <td> Total Sites </td> <tr>

<tr> <td> Web Application </td> <td> $Web_ActiveSitescount </td> <td> $Web_Readonlysitescount</td> <td> $Web_NoAccessSitesCount </td> <td> $TotalWebSites </td> </tr>

<tr> <td> Web Application </td> <td> $Web_ActiveSitescount </td> <td> $Web_ReadonlySitesCount</td> <td> $Web_NoAccessSitesCount </td> <td> $TotalWebSites </td> </tr>

<tr> <td> Web Application </td> <td> $Web_ActiveSitescount </td> <td> $Web_Readonlysitescount </td> <td> $Web_NoAccessSitesCount </td> <td> $TotalWebSites </td> </tr>

</tr>

</table>

$report1 = "<html>

<style>

{font-family: Arial; font-size: 12pt;color: #0F0F0F; }

{color:#F70707;}

TABLE{border: 1px solid black; border-collapse: collapse; font-size:15pt;}

#TH{border: 1px solid black; background: #F4D03F; padding: 5px; color: #000000;}

TR{color: #F70707;text-align: center;background: #13B5ED; padding: 5px; color: #0F0F0F;}

TH{border: 1px solid black; background: #F4D03F; padding: 5px; color: #F70707;}

TD{border: 1px solid black; padding: 5px; }

H2{color: #F70707;}

H1{Color: #0C0B0A;}

</style>

<table>

<tr> <td> Total Active Sites Count </td> <td> Total Read-Only Sites Count </td> <td> Total NoAccess Sites Count </td> <td> Total Sites </td> </tr>

<tr> <td> $TotalActiveSite </td> <td> $TotalReadonlySites </td> <td> $TotalNoAccessSite </td> <td> $TotalSites </td> </tr>

</table>

#==========

$body += " $report< "

$body += " $report1 "

$attachment12="C:\Results_Active_Web.txt"

toadd=""

#$toadd= ""

#$toadd=""

#send-MailMessage -SmtpServer $smtp -To $to -From $from -Subject $subject -Body $body -BodyAsHtml -Attachments $attachment11 -Priority Low

#Send-MailMessage -SmtpServer "smtp" -To $toadd -From "email address removed for privacy reasons" -Subject $subject -Body $body -BodyAsHtml

#Send-MailMessage -SmtpServer "smtp" -To $toadd -From "email address removed for privacy reasons" -Subject $subject -Body $body -BodyAsHtml -Attachments $attachment12 -Priority Low

Send-MailMessage -SmtpServer "smtp" -To $toadd -From "email address removed for privacy reasons" -Subject $subject -Body $body -BodyAsHtml -Priority Low

#Send-MailMessage -SmtpServer "smtp" -To $toadd -From "email address removed for privacy reasons" -Subject $body -

ID Calculated Column Not Showing

CIManager_0102 — Mon, 23 Mar 2026 12:24:33 GMT

I have created a calculated column to show the ID in an opened List item. This is using =ID in the formula box.

However, in the actual List item, the vasty majority are showing ID as 0:

There does not seem to be a pattern for this,

Does anyone have an explanation for this?