Microsoft.SharePoint.SPFileLockException
I am building a tool to upload the data to Microsoft Sharepoint excel file. There are many users who can use the file at the same time, but it is critical for me to be able to upload the data to the particular worksheet in that specific file all the time. However it seems that when the file is used by other users I cannot do the updates to the file and I am getting this error: '{"error":{"code":"-2147018894, Microsoft.SharePoint.SPFileLockException","message":{"lang":"en-US","value":"The file XXX.xlsx is locked for shared use by email address removed for privacy reasons [membership]."}}}' Is there a way for me to force an update to the file? To remove this Lock exception?
Delete the "Shared with us" link on navigation menu for modern sites
Hi everyone! I've tried to remove the lin on the navigation bar called "Shared with us". It appears whenever it wants and disappear... I've read many posts but it looks that no one have tried or want to remove this link. Why? Help!
Opening .msg files from sharepoint natively in Outlook
Hi I am wondering if there is a method of opening .msg files in a similar manner to .xls and .docx, where you can open them natively. The current way sharepoint opens .msg files does not allow access to the attachments in the emails, nor can the message be forwarded unless explicitly downloaded. Classic sharepoint immediately downloads the file, so it does not mitigate the issue experienced here.File Type Version Limits
Hi all, In trying to solve an old issue I stumbled across this new feature currently in preview and am wondering if the file type arrays will be editable or if new arrays could be or will be added? I have a handful of file types which do not need 100 versions, let alone a version every 2-5 minutes, requiring frequent culling... Ling. https://learn.microsoft.com/en-us/sharepoint/file-type-version-limits
Renaming a folder with too many files
One of our teams has a Team/SharePoint site with an archive folder. Everything in there is old files, and they'd like to rename the folder. However, we get the error that it exceeds the list view threshold. I've spent the afternoon trying to find out how to get this folder renamed and so far nothing has worked. The general consensus is to create a filtered view, but I'm not sure what to filter it based on, as all of the files have been there and untouched for some time, causing most of the columns I could index be fairly similar (they were moved to SharePoint 3 years ago from an on-prem fileshare). One of the options I'd seen was to sync it using OneDrive and rename it locally but that still gave me the same error. I also tried renaming the folder from within Teams without success. If someone could provide some guidance for how to get this done, I'd appreciate it. Right now, I'm thinking I'll just have to move a bunch of stuff out of some of the folders to temporary locations, but even that is challenging as I'm not aware of a good way to get a count of items in folders and subfolders in SharePoint to know which are the best ones to move out.Trimming SharePoint Version History - Minor Versions
Hello, I am a SharePoint Admin at my organization and I have been asked to reduce our total storage usage by reducing the number of versions and minor versions in our environment on all SharePoint sites. I have written a simple PowerShell script that loops through a csv file with site addresses, and runs this command per site -> New-SPOSiteFileVersionBatchDeleteJob -Identity $site.siteURL -MajorVersionLimit 100 -MajorWithMinorVersionsLimit 5 It was my understanding that for all sites in the csv file, for all document libraries on the site, and for all files in the libraries this command will reduce the file to the last 100 Major versions, and the last 5 minor versions of each major version. Unfortunately, this command is not actually reducing the minor versions. It is working with the Major versions just fine, but all minor versions are being retained for each major version retained. Is my understanding of this command wrong, or is it not working? Are there other factors to consider? Does anyone know of an alternative that can fit my needs? The overall plan is to trim the current version history, then apply the automatic version setting to each library in our tenant. Here is the MS guide I referenced, maybe I missed something -> https://learn.microsoft.com/en-us/sharepoint/tutorial-queue-a-trim-job Any help is greatly appreciated, CamMultiple Page Libraries on site
Hi everyone I have a strange issue that I haven't come across before. A customer has got an old subsite on SharePoint Online that was created with the STS#0 template (classic Team Site with no group) and they want to modernise their old wiki pages. This should have been straightforward as I was planning on using the https://learn.microsoft.com/en-us/sharepoint/dev/transform/modernize-userinterface-site-pages-powershell. However, on this site they have two page libraries - the standard Site Pages library and then what looks like a custom page library (I've blanked out the name of the custom library as it contains the company name): All of the pages they want to modernize are in the custom library but the issue with this is that the only content type available is Wiki Page: This means that although the PnP PowerShell runs successfully against pages in this library, the new versions don't actually appear in the library. I assume this is because the modern Site Page content type isn't available in the library. I was under the impression that a site could only have one page library so I'm not sure how this site has the two. On a more urgent note I need to work out the best way of modernizing these pages. Currently the only way I can see is using Power Automate to copy the pages to the Site Pages library and then convert them there. The only issue with that is that there are links within the pages to other pages so I'd need to go through them and fix these once they've been moved. here are over 300 pages so I don't really want to do this. Does anyone have any ideas on the best way forward with this. Also, if you know how there are multiple page libraries I'd be keen to hear it as I haven't come across this before. Thanks in advance for your help.
Sharepoint/Teams linked folder loop
Good Morning, I have an issue with a folder loop within our sharepoint site. I'll try to describe it as best I can. We have a SharePoint page: https://site.sharepoint.com/sites/Teams-Channel/Shared%20Documents/Forms/AllItems.aspx On this page we click on Documents and we go to the Documents page where there are two collapsed tabs; In Channels and In Library. If we expand the In Channels part there is an entry for a Page1. When we click on Page1 it takes us to a page with folders on it, when we click on the folder is brings us back to the same page, albeit with a much longer URL. https://site.sharepoint.com/sites/Teams-Channel/Shared%20Documents/Project%20Team?id=%2Fsites%2FTeams-Channel%2FShared%20Documents%2FProject%20Team&viewid=a16dd475%2Dc62f%2D40c5%2Db27f%2Dcbbc3514d170&newTargetListUrl=https%3A%2F%2Fsite%2Esharepoint%2Ecom%2Fsites%2FTeams-Channel%2FShared%20Documents%2FProject%20Team I know the problem is the newTargetListUrl, but i want to know if I can fix this? Some things to note as far as i can tell: This is a sharepoint page created by a teams channel, the files were uploaded via Teams. if you have any questions or need anything cleared up, please ask and I'll do my best to elucidate. DK
PnP Search Results Handlebars template saves but does not reflect on UI
Hi everyone, I am working with the PnP Search Results web part in SharePoint Online and facing an issue where a custom Handlebars result template saves successfully but does not reflect on the UI. I created a table-style Handlebars template with columns Document, Region, Country, Language, Status and Validation Date, one row per document. Documents are returned correctly and filters based on the same refinable properties work as expected. Debug output using JSONstringify(item) confirms that all refinable values are present. The same if-condition logic using item.RefinableStringXX works in a list-style layout, but in a table layout the template saves without errors and either does not reflect on the UI or renders rows with empty metadata columns. Inline bindings do not render unless wrapped in if blocks and even after fixing this the UI sometimes continues to show the previous layout. Managed property mappings, selected properties, indexing and library reindexing have already been verified. Has anyone experienced this behavior with PnP Search Results templates or knows if this is related to caching, result types overriding templates or a known limitation with table-style Handlebars layouts?
