SPO "Item not found"
Greetings! Our partner has a SPO modern team site. There is a document library with Document content type, which has an SPFx custom form. The documents are uploaded to the library in bulk, then they use the custom form to fill out the metadatas one by one. PnP JS list.items.getById(1).update() method is used to save the metadatas, but the document are not moved or renamed. After the successful save, the page is reloaded with the window.location.reload() method. But after reloading a page, sometimes they get an error message: "Item not found. It might have been deleted or renamed by another user". Then it takes some minutes or even hours, before they can once again open the form. Any help would be much appreciated.Column Validation Evaluation Changes
Hello! I'm wondering if I am going crazy, but I have seen breaking changes to a couple of client tenancies where column validation is now occurring for any item/file creation or modification event. This was not happening a month or so ago, and I've got evidence of that with files being able to be placed in a library previously, and not, now. This is because it is clearly trying to validate on column information that is not entered by the (flow) creation of the file. If I were to try to deal with this INSIDE the validation formula for all my lists, ever ... this could effectively cripple me! 😅 --- I'm not posting a problem that needs fixing, here, so please, I do not need to be asked what I have and haven't tried ... I'm simply asking if others have noted a similar thing happening.
Conditional Formatting using JSON
I have this code which is working great, however, every time I make a change to add in that if it is blank it should be light coral as well - here is the original - { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) == 0, 'LightGreen', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 10, 'LightGreen', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) >= 11 && (Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 20, 'LightYellow', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) > 20, 'LightCoral', '')))", "color": "black", "padding": "5px", "border-radius": "5px" } } Here is the new attempt at adding in a null value is also Light Coral. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(isBlank([$Emp_x0020_Returns_x0020_OF306]) || isBlank([$LP_x0020_Sends_x0020_OF306]), 'LightCoral', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 10, 'LightGreen', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) >= 11 && (Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 20, 'LightYellow', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) > 20 || isBlank([$Emp_x0020_Returns_x0020_OF306]) || isBlank([$LP_x0020_Sends_x0020_OF306]), 'LightCoral', '')))))", "color": "black", "padding": "5px", "border-radius": "5px" } } It just makes everything transparent. Any help would be highly appreciated! Too bad this isn't built in functionality.
Embedded list view - messed up columns
Sometimes, when I embed a list with a custom view, the columns are drastically different on a co-workers computer, while they look fine on mine. I fiddle with the JSON formatting, hiding/showing the column headers, adjust the column sizes, etc, but nothing seems to work. Is this a known issue? Any suggestions to deal with this? My screen (Edge browser): My co-worker's screen (Edge):How to resolve 'broken' unique permissions in a SPO library?
PROBLEM: I have many thousands of files and folders in multiple SharePoint Site libraries that somehow seem to have acquired unique Group permissions. Users with high-level permissions have lost visibility to many folders and files. DETAILS: There are five different permission groups that are given access to any new folder created in the library: Owner; Site Member; Library Manager; Library Contributor; Library Member. I'm using Teams to apply most user permissions. A Team is given a particular group permission and any user in that Team inherits that permission level (Library Member). For high-level permissions (Library Manager), I just manually put that person in that permission group. OBSERVATIONS: If I create a new folder, as the admin or someone with 'manage' permissions, the folder inherits the proper permissions. We also have a new folder workflow that creates these folders. I've confirmed that the items created with this process inherit the proper permissions. My only guess is that at some point the permission levels or groups were changed and folders did not inherit the proper updates. What I'm also struggling to track down is how some files in more recent folders are still hidden from users with Manage permissions. I think this has to do with the way sharing links are being created and shared. For instance, if "Jen" unintentionally creates a restrictive sharing link and shares that with "Bob", when Bob clicks on that link, the web browser is caching that permission even though he has full write access to all documents. When Bob clicks this link in his email, the files are showing as view only and he can not view any other contents of the library. There's a prompt that says something like you must be an authorized user, click here to sign in. When you click that, this restores all proper permissions. SOLUTIONS(?): I've found that there's a script to remove unique permissions and intend to give this a try. I'm hesitant to pull the trigger on this because it will kill any legit sharing links with our outside partners.I really don't want to kill links; I want to reset the Permission Groups for all contents of a library. # Set Variables $SiteURL = "https://yoursharepointsite.sharepoint.com" $LibraryName = "Documents" $BatchSize = 500 # Connect to SharePoint Online Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential) # Function to reset permissions for a batch of items function Reset-PermissionsForBatch { param ( [Parameter(Mandatory=$true)] [array]$Items ) foreach ($Item in $Items) { if ($Item.HasUniqueRoleAssignments) { Set-PnPListItemPermission -List $LibraryName -Identity $Item.Id -InheritPermissions Write-Host "Reset permissions for item ID: $($Item.Id)" } } } # Get all items in the library in batches $ListItems = Get-PnPListItem -List $LibraryName -PageSize $BatchSize -ScriptBlock { param($items) Reset-PermissionsForBatch -Items $items }
Is it possible to restrict what values a user sees in a lookup column in a Document Library
Hi Guys, Need inputs on a particular requirement that I am struggling with in SharePoint Online Document Library. Here is a Document library, where I have a column named "document department". This is a lookup column to a separate list called "Department" The list "Departments" is below. It has various departments (like Finance, Human Resources, Project Delivery etc). It has department name, department shortcode, etc. REQUIREMENT : --------------------- The requirement is that when a document is uploaded to the document library, the users would select the department from the list of departments. At present, if the user belongs to HR department, they can still see and select other departments in this column. This should NOT be the case. The user should only see the department in that dropdown list, which the user belongs to (Example, HR user should only see the HR in the dropdown, and other options should either be grayed out or not visible). How do I achieve this?Tracking Usage on SharePoint Communication Site
Hi, We have a SharePoint communication site and are looking for ways to track its usage beyond just the landing page. Specifically, we want to understand who is accessing not only the landing page but also the document libraries linked through the quick links on the page. Could you advise on how to conduct an audit that captures usage data for the entire site, including all libraries accessed via the quick links? What options should I consider when setting up the audit, or is there an alternative method to achieve this? Thank you!
