Forum Widgets
Latest Discussions
Nested formula not working
I have been using the below formula in a SharePoint Column, to find the most recent year column that 'comprehensive' is mentioned and have that year value returned to the calculated column - it is suddenly not working - or if I reset it, it works for less than a minute and then converts to only one year '2024'. If I reduce the number of years/columns in the formula to only two it works properly and the results stay. Any ideas what the problem is? =IF(NOT(ISERROR(FIND("comprehensive",[2024]))),"2024",IF(NOT(ISERROR(FIND("comprehensive",[2023]))),"2023",IF(NOT(ISERROR(FIND("comprehensive",[2022]))),"2022",IF(NOT(ISERROR(FIND("comprehensive",[2021]))),"2021","No Review")))) Thanks in advance and I am not an expert in anything IT but I am trying to use this to track work in my team. Cheers Karen
Documents uploading to Sharepoint althoughI didn't set it up
Yesterday I began receiving email updates telling me that the Word documents I was working on have been uploaded to Sharepoint. This happens every time I insert a comment into the file. This only began to happen yesterday. I have never used Sharepoint, and only learned about the "Share" option when I searched Help to find ways to turn it off. I didn't turn it on deliberately. So I googled for instructions on how to stop this, and none of the instructions I found matched what I saw when I tried to turn it off in either the document or FIle Explorer. I just went into Word and clicked Help to identify the version I'm using, but they removed "About Word" from the Help menu, so the version isn't where it belongs anymore. I don't know where they put it, and it might not matter anyway. It's probably the latest version, in fact, this might have happened with a recent upgrade, I don't know. If my documents upload to Sharepoint, they're private, right? I'm a writer and I don't want my stuff going out there without me controlling things. Where does Sharepoint keep my files? I no longer have access to OneDrive because I was shut out one day when when my internet carrier switched my signal to another city, and I clicked "No" when Microsoft asked me if I was the one signing in from that city. They immediately locked me out of everything. I can't even get codes by text anymore. I got Outlook and microsoft.com back by signing in with my thumbprint on my phone, but it didn't help me with OneDrive, and I couldn't get support, so I've been unable to access it for months. If Sharepoint is happening on OneDrive, I might be in trouble. How do I stop uploading files to Sharepoint, and stop these annoying emails whenever I add a comment to a file? Thanks!
SharePoint Online Subsite Feature - Is it going to deprecate
Hi Team, When will MS deprecate subsite feature from SPO? and what will happen to the existing subsites if deprecated? Also, could you please share SPO roadmap for subsite. Note that we are aware of flat structure and its recommendation from MS. Thanks & Regards, Shanthi.
Issue with Moving Data Between SharePoint Sites Using Synced Document Libraries
Hi everyone, I work at an MSP IT company, and over the past 14 days, I’ve encountered the same issue with two different users from separate customers. Both users have synchronized document libraries on their local machines. Here’s what happens: When they cut a large set of files from one SharePoint site to another, the data doesn’t seem to move correctly. On the user’s computer, everything looks fine, but when I check online, the files are still in the original location. If I then cut the data from the new location to a temporary folder (e.g., C:\#temp), the files disappear from the old location both locally and online. After that, if I move the data back into the new location, it synchronizes perfectly. Has anyone experienced this behavior before or can explain if the users are doing something wrong? Any insights would be greatly appreciated! :) Best regards, Michael Boye
Property Demotion leads to infinite import cycles when integrating with SharePoint
Hi, we have built an integration with SharePoint that imports watches and imports files from connected SharePoint sites into our product for further processing. After that process is complete, we push some of the processing results back to a SharePoint list as metadata. In order to keep the extracted data up to date, even when file content changes after the initial upload/import, we subscribe to changes in the SharePoint site and re-import the file if its hash has changed since the last import. This process worked really well until we started processing some of the Microsoft file types (e.g. .docx, .msg, etc.). Apparently SharePoint Online will include metadata from list columns into these files in a process called "Property Demotion". Since this changes the file content, it triggers a re-import of the file. Due to the non-deterministic (AI-generated) nature of some of the metadata we extract, this re-import will likely result in different metadata values that are exported back to SharePoint - which of course triggers property demotion again, leading to an infinite cycle. What we have tried so far: Disable property demotion -> Not possible in SharePoint online as far as we know. Only export metadata if anything actually changed -> Only solves the issue if metadata is stable w.r.t. document content, which does not hold for our use-case. Skip re-imports occurring X minutes after the last metadata export -> While this works most of the time, it is fragile (what if the property demotion is delayed?) and worsens user-experience (what if a user edits the file within the X minute window?) Has anyone encountered the same issue before? How did you end up handling it? Thanks, JohannesNot able to recreate Teams Sharepoint site after perm deleting.
I'm trying to rename a Sharepoint site to a site that I permananetly deleted but I keep getting Write-Locked. {"odata.error":{"code":"-105","message":{"lang":"en-US","value":"This site address can't be changed.\r\nThis | site is write | locked.\r\n"},"MultiGeoService.ExceptionType":"MultiGeoServiceException","MultiGeoService.ExceptionContext":"{\"Errors\":[{\"ErrorCode\":-105,\"ErrorMessage\":\"This site is write locked.\"}],\"Warnings\":[]}"}} I'm using this command to rename the site Rename-PnPTenantSite -Identity $teamsURL -NewSiteUrl $updatedteamsUrl -WaitGet FileName from ServerRedirectedEmbedUrl in Excel
Greetings - I have a client requirement where we are using SharePoint as a datasource to excel - connecting to a library. Is there any way to get the filename in the output? Looks like I get a UniqueID - can I trace that back to the filename? Spreadsheet has 52,000 rows .... Thanks in advance!
Classic SharePoint list view redirecting to home page
Hello! I have an old Classic SharePoint site that I need to create a new view in a list for. I have created this view but whenever I go to open that view it redirects me to the homepage. This site was build by someone else and I believe this is by design to stop users from using admin only views....but how do I stop this for my new view? I need some users to be able to use it. When I create a personal view it does not do this redirect. Any ideas how I can stop it happening on a public view? Or will I need each of my users who need a new view to set up personal views of their own?How to grant access to SharePoint subsite with no Owners
Hello! Can someone advise how I can add a user to a SharePoint site with no Owners/Members or Admins? It is a Classic SharePoint subsite so I cannot modify any settings using the SharePoint Admin Centre so I need to find a script or a method of some sort to allow me to add a user account to the site to then be able to review it/decommission it etc.? TIA!
Microsoft 365 Purview Logs not showing Export List Events
We recently conducted an audit on our system - as we are part of a regulated industry - and had to clarify exactly which user events are captured in the Unified Audit Log. We did the usual confirmations and provided evidence of events where users add, update, delete items in SharePoint Lists and Libraries, however, we were asked specifically if events for exporting List Items to CSV or Excel were captured in the Log. We performed the usual test and waited for the events to appear in Purview, but to our suprise, there was nothing in the Log to indicate a user exporting to CSV or Excel. Can anyone confirm whether Export to CSV or Excel from a SharePoint List should be captured and is reportable in the Audit Log? This seems to be a massive oversight if these events are not auditable?
