Forum Widgets
Latest Discussions
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 }
Status Change tracker
#Sharepoint Hello, I have a list with a column " Status" . We have "open" " rejected" " sent to vendor" " closed" Can we track the status changes in Sharepoint and measure how long it takes for each case from the " open " to the "closed " status? We would like to measure performances if this is possible. Best Regards GD.How to add a library to GUI SharePoint
Hi SharePoint group Our company has a picture library which contains company pictures to use in SharePoint pages and communication. I want to add that library to SharePoint when you choose to add a picture to a SharePoint page/news. Above an example. Language is Dutch. I hope you can help me.
Microsoft Teams - Microsoft Lists Edit Multiple Items - Date Column Issue
Hello, After a recent update, date columns when multi editing items in Microsoft List inside of Microsoft teams are loading the date items from the first item selected. All items selected are sometimes accidently being overwritten with the same dates as end users don't expect the date fields to be auto populated. This issue does not occur in Microsoft Lists app or via web browser. I've advised users to remember to delete the Date values when multi editing a list via teams. It does appear to be a bug with a recent update.
Microsoft Lists form How to color different Sections to make it easy to fill out
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display different sections (areas) for the fields. which looks great when entering as a form. Is there a way to apply color to the different sections to distinguish the different sections to make it easier for the end user to enter. eg see screenshot example layout of Patients template form different sections in different colors How can this be achieved? TIAMicrosoft Lists format Section of related Columns as same color
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display sections for the fields. which looks great when entering as a form. In the web app, for the end user to make it easier to fill out, for each Section I would like to display the same color for the related columns. And for the next section of related columns apply a different colour etc Note some columns have Conditional formatting rules applied eg see screenshot of example done in Excel of Section column layout to achieve How can this be achieved. TIAMicrosoft Lists format Section of related Columns
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display sections for the fields. which looks great when entering as a form. In the web app, for the end user to make it easier to fill out, for each Section I would like to display the same color for the related columns. And for the next section of related columns apply a different colour etc Note some columns have Conditional formatting rules applied eg see screenshot of example done in Excel of Section column layout to achieve How can this be achieved. TIAMicrosoft Lists form How to color different Sections to make it easy to fill out
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display different sections (areas) for the fields. which looks great when entering as a form. Is there a way to add colour to the different sections to distinguish the sections. This makes it easier for the end user to fill out eg see screenshot of Patients list template form used with the different sections in different colors How can this be achieved? TIAMicrosoft Lists format Section of related Columns
I have a created a Microsoft List. There are sections of related questions ie column fields. In Configure Layout, Format Body, I have added JSON code to display sections for the fields. which looks great when entering as a form. In the web app to make it easier to fill out for the end user, for each Section I would like to display the same colour to the related columns. And for the next section of related columns apply a different colour. Note some columns have Conditional formatting rules applied. eg see screenshot of example done in Excel of Sections column layout wanting to achieve How can this be achieved. TIAChange SharePoint library column JSON to highlight dates in the last 24 hrs to a different colour
I have a SharePoint document library with a "Last Posted Date" column which is updated by a Power Automate flow. I have the "Last Posted Date" column formatted with the JSON below to highlight any files which have been published, but I am trying to figure out how to have files published in the last 24 hours highlighted in DarkGreen instead. I am still new to JSON, so any advice is appreciated. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "box-sizing": "border-box", "padding": "0 2px", "overflow": "hidden", "text-overflow": "ellipsis" }, "attributes": { "class": { "operator": ":", "operands": [ { "operator": "==", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Last_x0020_Posted_x0020_Date]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ null ] } ] } ] } ] }, "sp-field-fontSizeSmall", "sp-css-backgroundColor-BgMintGreen sp-css-borderColor-MintGreenFont sp-field-fontSizeSmall sp-css-color-MintGreenFont" ] } }, "children": [ { "elmType": "span", "style": { "overflow": "hidden", "text-overflow": "ellipsis", "padding": "0 3px" }, "txtContent": "[$Last_x0020_Posted_x0020_Date.displayValue]", "attributes": { "class": { "operator": ":", "operands": [ { "operator": "==", "operands": [ { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ "[$Last_x0020_Posted_x0020_Date]" ] } ] } ] }, { "operator": "Date()", "operands": [ { "operator": "toDateString()", "operands": [ { "operator": "Date()", "operands": [ null ] } ] } ] } ] }, "sp-field-fontSizeSmall", "sp-field-fontSizeSmall sp-css-color-MintGreenFont" ] } } } ] }
