Forum Widgets
Latest Discussions
This List is Empty - but it isn't
Hey all, I have a bug that I've never encountered before. I have a sharepoint list that was working perfectly fine until around 3 PM today. My sharepoint list has about 14 items in it. When I tried to view my sharepoint list, it said "this list is empty". My first thought was that someone accidently deleted the records, so I checked the recycle bin and there was nothing in it related to the list. I checked the sharepoint list under "site contents" and it lists about 14 items in the list (which is what I expect), but when I open the list, it still says "this list is empty". I have a power automate flow that triggers when a Microsoft form is sent, it gathers the response details and makes a row in this list with the content from that form. Again, this process was perfect for a solid week and I've used the same process for dozens of forms over 4 years with no issue. Where this gets really odd is that when I make a new Microsoft form response, my power automate flow runs perfectly and It appears it makes a sharepoint list item. Indeed, in the site contents, after submitting a new form response, the item count goes up by 1 for the sharepoint list. However, the list still says "this list is empty". I even made a new view that only shows a single row (no filters applied), that all 14 records have filled out, my sharepoint list refuses to show any data. I also can't seem to add columns, edit columns, or do what I would normally do for a sharepoint list. I am an owner of the sharepoint list and the form has permission inheritance on. What's even more odd is that I can run powerbi desktop and use my same account credentials to use the sharepoint list as a data source and all 14 rows show up PowerBi desktop, which leads me to believe that the data does actually still exist in the sharepoint list. Every other sharepoint list, including other sharepoint lists on the site, do not have this problem. If possible, I don't want to have to make another list since it's used for other power platform items. However, this is baffling me.SharePoint : Your storage is almost full - one approach
I've been looking for low impact ways to minimize our storage usage across our SharePoint tenant. This post outlines the approach I took and the outcome, and who it might work for. My environment: Only 350GB remaining in Tenancy 8.7 TB used. 265 sharepoint sites in total (teams / communication etc) I decided to focus on sites with more than 100Gb of storage used. In my case this turned up 16 sites. Of these I had to exclude 2 sites. This left 14 sites using 5.194553 TB My goal was to have low/no impact on users while reducing the volume of content in our M365 tenant SharePoint environment. My approach was to do the following: - Get list of all SharePoint site collections, find out Size of each Those larger than 100Gb do the following: - delete all items in recycle bin deleted more than 30 days ago (current setting 93 days, unchanged) - delete all items from 2nd stage recycle bin (current setting 30 days, unchanged) - change all user libraries from 500 to 100 major versions In my environment the recycle bins are rarely used and when I ran a script to work out the average number of versions it was in the 10s at most and for most sites it was 3 or 4. NOTE no sites have minor versioning turned on. I wanted to measure the change so I exported a usage report pre and post doing the above. To achieve all this I used the following code, then the following day checked the SharePoint admin centre reported the same "Storage used" numbers. BE AWARE the code below DELETES data you cannot get back (file versions, and files in the recycle bin). DO NOT RUN THIS to try it out. Test it on one or two sites first. Even if you have backups getting version history back would be very challenging. <# goal is to reduce size sites take up 1 change version from 500 to 100 2 recycle bin deleted more than 30 days ago, move to 2nd stage recycling 3 empty second stage recycling #> #Get current stats #Connect to Admin Center $AdminCenterURL = "https://MyCompanyName-admin.sharepoint.com" Connect-PnPOnline -Url $AdminCenterURL -Interactive reportTenantSiteCollectioninfo function reportTenantSiteCollectioninfo { Try { #export file path $dateStamp = get-date -format "yyyyMMdd-hhmm" $CSVPath = "c:\Temp\SiteUsageRpt-"+$dateStamp+".csv" #Get all site usage details $Sites = Get-PnPTenantSite -Detailed | Select * $SiteUsageData = @() ForEach ($Site in $Sites) { #Collect site data $SiteUsageData += New-Object PSObject -Property ([ordered]@{ 'Title' = $Site.Title 'URL' = $Site.Url 'Description' = $Site.Description 'Owner' = $Site.OwnerName 'Storage Quota' = $Site.StorageQuota 'Storage MaximumLevel' = $Site.StorageMaximumLevel 'Storage Usage Current' = $Site.StorageUsageCurrent 'Resource Quota' = $Site.ResourceQuota 'Resource Quota Warning' = $Site.ResourceQuotaWarningLevel 'Resource Usage Average' = $Site.ResourceUsageAverage 'Resource Usage Current' = $Site.ResourceUsageCurrent 'Template' = $Site.Template 'Sharing Capability' = $Site.SharingCapability 'Lock Status' = $Site.LockState 'Last Modified Date' = $Site.LastContentModifiedDate 'Subsites Count' = $Site.WebsCount }) } $SiteUsageData #Export Site Usage Data to CSV $SiteUsageData | Export-Csv $CSVPath -NoTypeInformation Write-Host "Site Usage Report Generated Successfully!" -ForegroundColor Green } Catch { Write-Host -ForegroundColor Red "Error generating site usage report:" $_.Exception.Message } } Function Set-PnPVersionHistoryLimit { param ( [Parameter(Mandatory=$true)] $Web, [parameter(Mandatory=$false)][int]$VersioningLimit = 100 ) Try { Write-host "Processing Web:"$Web.URL -f Yellow Connect-PnPOnline -Url $Web.URL -Interactive #Array to exclude system libraries $SystemLibraries = @("Form Templates", "Pages", "Preservation Hold Library","Site Assets", "Site Pages", "Images", "Site Collection Documents", "Site Collection Images","Style Library","Teams Wiki Data") $Lists = Get-PnPList -Includes BaseType, Hidden, EnableVersioning #Get All document libraries $DocumentLibraries = $Lists | Where {$_.BaseType -eq "DocumentLibrary" -and $_.Hidden -eq $False -and $_.Title -notin $SystemLibraries} #Set Versioning Limits ForEach($Library in $DocumentLibraries) { #powershell to set limit on version history If($Library.EnableVersioning) { #Set versioning limit Set-PnPList -Identity $Library -MajorVersions $VersioningLimit Write-host -f Green "`tVersion History Settings has been Updated on '$($Library.Title)'" } Else { Write-host -f Yellow "`tVersion History is turned-off at '$($Library.Title)'" } } } Catch { Write-host -f Red "Error:" $_.Exception.Message } } <# Get a list of big sites #> $bigSites = $SiteUsageData | where "Storage Usage Current" -gt 100000 $bigSites = $bigSites | where title -notin ("excluded site 1","excluded site 2") $bigSites.count #loop through the big sites foreach($bigsite in $bigSites) { connect-pnponline -url $bigSite.URL -interactive ## get the deleted items that were deleteed more than 30 days ago $date30daysago = (get-date).adddays(-30) $DeletedItemsOlder = Get-PnPRecycleBinItem | Where { $_.DeletedDate -le $date30daysago} | Sort-Object -Property DeletedDate -Descending $DeletedItemsOlder.count #move all these to 2nd stage recycle bin $DeletedItemsOlder | Move-PnPRecycleBinItem -force #empty the second stage recycle bin Clear-PnPRecycleBinItem -SecondStageOnly -force #get all the libraries $Webs = Get-PnPSubWeb -Recurse -IncludeRootWeb ForEach($Web in $Webs) { Set-PnPVersionHistoryLimit -Web $Web } } #get site info again reportTenantSiteCollectioninfo Outcome [Updated 7 Aug 2023] On the day the outcome was spectacularly unsuccessful. I saved 24GB by doing this across 5.194553 Terra bytes or less than 0.5 % So worth trying, but not valuable in my environment, I thought. But when I looked at the SharePoint admin screen, Storage used, in August there is a big drop two days after running this script. From 8.8TB down to 8.6TB so approx 200GB saving. Unfortunately this may not have been all to do with this script (other things going on in my tenant) but a lot of it is, again not massive at 2% but useful. When would this be valuable for reducing storage volume ? I think the key thing isn't the removal of files from the recycle bins, but the removal of older versions of files. SO if you have an environment with most files having 100's of versions , and those versions are large changes to the file each time. (e.g. a daily report that has new images replace existing ones each day) then this could save a lot of space. What about you? How do you reduce SharePoint storage? What have you found that works?SharePoint Missing Authentication for _vti_bin
The issue with the vti_bin folder is that it is accessible without authentication. However, the remediation measures outlined below are not technically feasible for SharePoint Online (O365). I found few remediations for this issue which are as follows: Configuration Options: Administrators can configure authentication for _vti_bin through various methods, such as: Enabling anonymous access:This allows anyone to access the site and its resources, including _vti_bin URLs, without logging in. Restricting access in Web.config:The Web.config file can be modified to deny access to anonymous users for specific _vti_bin paths. Using the ViewFormPagesLockDown feature:This feature can help restrict access to certain SharePoint resources, including those within _vti_bin The below links are for reference: https://www.c-sharpcorner.com/uploadfile/Roji.Joy/how-to-secure-external-anonymous-access-to-sharepoint-2010-sites/#:~:text=Even%20when%20lockdown%20mode%20is, https://learn.microsoft.com/en-us/archive/blogs/fabdulwahab/security-protecting-sharepoint-server-applications https://sharepoint.stackexchange.com/questions/167264/restricting-access-to-contents-in-vti-bin-for-both-authenticated-as-well-as-a I would like to verify whether the provided fixes are applicable to O365 SharePoint. If they are not, could you please advise on alternative solutions that can be implemented to mitigate this issue?
Box as an Alternative to SharePoint/OneDrive
We’ve been running into ongoing performance and sync issues with SharePoint/OneDrive, mainly due to the size of our project libraries and the number of users syncing across multiple devices. Just one of our document library alone has hundreds of thousands of files, and it’s starting to cause major slowdowns especially for remote staff. We’re looking to understand if Box might be a more stable or scalable alternative for managing large file structures. To be clear, I’m not looking to be contacted by sales reps or companies. I’m only interested in hearing from actual users who are currently using OneDrive/SharePoint or Box for file management and collaboration. Would like to hear how it’s working for your organization, what’s gone well, and what hasn’t.
Copilot Studio - Access SharePoint List
Hi There, for a testing prupose, I want to create an agent with Copilot Studio. I want to access SharePoint List via action="Get items" from SharePoint. I selected/entered in "Inputs" section: Site Address = http:// .... List Name = Employee List Top Count = 5000 Filter Query = Dynamically The list has employee information, around 10 columns, and 150 rows. When I submit such "Who is Jasmin?" or any other similar question such "Who is Jasmin Tailor?" Overall: I am searching about existing employee and not existisng in the list, ... I get always this error message: Error Message: The connector 'SharePoint' returned an HTTP error with code 400. Error Code: ConnectorRequestFailure Conversation Id: 3c0377a0-83c1-412b-9d1a-761f8202203a Time (UTC): 2025-04-15T16:49:08.414Z First time I run this agent with this action, I was asked to connect, which worked fine. However I still get this error message. I am the creator of the agent and I am also the owner of this sharepoint list. Any idea, what am I doing wrong? Or can I somewhere check if this "Get itrems" action or other actions are temporarily not working? THANKS ! Regards, Aykut
SharePoint Template Copying
Hello Community! I am working to copy over a Site Page Template upon a list form request! Users will fill out the name of the item they're looking to create a Notice template for, and then power automate copy's the template and updates the metadata. When I update the metadata, it still shows with the name of the template page I originally copied. The following shows this happening with a template page created by copying 'CarrierNoticeTemplate' The first image shows the template titled "Test Notice", when being selected within the Page Gallery. Second image shows the template titled "Test Notice", within Site Pages. Any help would be very much appreciated.
Making Home Page a Template to Be Used Across Sites
Our team is looking for help with reusing a customized SharePoint page. I created a home page on a SharePoint Teams site (not a Communication site) and would like to save it as a template so we can apply it to other sites across the tenant. The page includes layout sections and various web parts, and ideally we want to replicate the same setup on other SharePoint sites. What’s the best and supported way to export or save this page as a reusable template and apply it to other modern SharePoint sites? We are open to using PnP PowerShell or other supported tools, but we’ve run into authentication issues when trying to connect via app registration. Would appreciate step-by-step guidance or a recommended approach. Thank you!SharePoint Form JSON Customize layout header - Managed metadata not working
I'm trying to add a managed metadata field titled Status to the header portion of a SharePoint form. Here is the JSON I am using: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/form-formatting.schema.json", "elmType": "div", "style": { "background-color": "#e8f5ee", "border": "1px solid rgba(0,0,0,0.1)", "border-radius": "8px", "padding": "12px 16px", "margin-bottom": "12px" }, "children": [ { "elmType": "div", "style": { "display": "grid", "grid-template-columns": "140px 1fr", "row-gap": "4px", "column-gap": "12px", "align-items": "center" }, "children": [ { "elmType": "div", "style": { "margin": "0", "line-height": "1.2", "font-weight": "600", "color": "#616161", "font-size": "32px" }, "txtContent": "=[$Title]" }, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='ID: ' + [$ID]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='Status: ' + [$Status]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='label: ' + [$Status.label]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='Label: ' + [$Status.Label]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='GUID: ' + [$Status.termGuid]"}, { "elmType": "div", "style": { "margin": "0", "line-height": "1.35", "font-size": "18px" }, "txtContent": "='Path: ' + [$Status.path]"} ] } ] } Here is the result: Only the Title and ID fields appear. All other attempts render blank. The Status field does have a Value which I do see on the Body of the form What is corret JSON syntax to display Managed metadata fields in the Header?
