Recent Discussions
Get-PnPSiteTemplate: The remote server returned an error: (403) Forbidden
I want to copy one site collection from one tenant to another, so on the source tenant, I created this App Registering and I grant it full control on SharePoint:- And I define to use secret for the authentication:- Then I run this command:- Connect-PnPOnline -Url "https://****.sharepoint.com/sites/****Integration" -ClientId "***" -ClientSecret "ptv**" Connecting with Client Secret uses legacy authentication and provides limited functionality. We can for instance not execute requests towards the Microsoft Graph, which limits cmdlets related to Microsoft Teams, Microsoft Planner, Microsoft Flow and Microsoft 365 Groups. You can hide this warning by using Connect-PnPOnline [your parameters] -WarningAction Ignore then i got this error, when i tried to Get the site template:- Get-PnPSiteTemplate -Out "Integration.xml" Get-PnPSiteTemplate : The remote server returned an error: (403) Forbidden. Any advice? i remember i did this operation 1 year ago and it worked well. Thanks17Views0likes0CommentsAdding an 'Events List' as a List Webpart
Possible at all/is there a workaround? I am trying to put an Events List and a List on one page. The idea is to let users view/add to both on one page. The problem: when adding a list webpart, the events list I need doesn't appear as an option. I searched the forums and did not find a clear solution. Is this possible at all? If I run an automate flow to push entries and changes back and forth to a duplicate list and an events list that would be recursive. Currently have a 'Webpart Tabs' webpart with a placeholder standard list on the top: Titled 'Events List A'. I want to put the actual events list in its place. Happy holidays and thanks!12Views0likes0CommentsNews Pages and Sharing
Hello! We have a few employees who have been trying to share news article pages from our News Hub using the 'Share' button. Since all employees have 'read only' access to the site, it's triggering an email to the site owner to approve the employee can share. Has anyone else experienced this as well. Wondering if this feature is not working properly. For now, I'm having employees just copy the URL and send it to other employees via email to share.4Views0likes0CommentsList of members of SharePoint sites
Hello, We have a client who wants a generated list of SharePoint site members. I have a powershell script that gets the sites and users within the Membership groups but not users just listed under Members. Is there a reason why the users under members aren't seen and if there's anything that I can do to the script to get it to see the users? The script is in the word document as I tried the embeded code and it went mad. Any help will be greatly appreciated.14Views0likes0CommentsCreating an exported report of members
# Define the tenant $tenant = "testing" # Ensure the output directory exists $outputDir = "C:\temp" if (-Not (Test-Path -Path $outputDir)) { New-Item -Path $outputDir -ItemType Directory } # Connect to SharePoint Online try { Connect-SPOService -Url "https://$tenant-admin.sharepoint.com" Write-Host "Connected to SharePoint Online." } catch { Write-Host "Failed to connect to SharePoint Online: $_" exit } # Get all site collections try { $sites = Get-SPOSite -Limit All Write-Host "Retrieved site collections." } catch { Write-Host "Failed to retrieve site collections: $_" exit } # Loop through each site foreach ($site in $sites) { try { # Get the current date and time $dateTime = Get-Date -Format "yyyyMMdd_HHmmss" # Define the site URL $siteUrl = $site.Url # Get the users and export to CSV $users = Get-SPOUser -Site $siteUrl if ($users) { $filePath = "$outputDir\$($site.Title)-$dateTime.csv" $users | Select-Object * | Export-Csv -Path $filePath -NoTypeInformation Write-Host "Exported users for site $($site.Title) to $filePath." } else { Write-Host "No users found for site $($site.Title)." } } catch { Write-Host "Failed to process site $($site.Url): $_" } } Write-Host "Export completed for all sites."6Views0likes0CommentsSharePoint List Flow - Displaying Unique ID
I have create a flow to populate a word document and email the user. It is working great, except certain fields the word document populates with the Sharepoint unique ID string. How can I get this formatted to use just the text in that field?34Views0likes3CommentsSPO "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.33Views0likes1CommentSharePoint Permissions
I've been using SharePoint online for about a year now. I have found everything I have needed to do to be pretty straightforward except for permissions. My admin gave me a team site to store my documents. I have since created some lists and use Power Automate for workflows. I have three members who have edit access more for back up purposes than anything else. Now, I would like to give access to everyone in the company so that they may contribute by filling out forms and viewing their own items but not able to edit or delete anything. All the online videos are for communication site permissions. Is this not possible for a team site?Solved57Views0likes8CommentsSPO vs Google Analytics Discrepancies
I've created a GA report filtered by site (path begins with /sites/sitename) and see drastically different numbers in SPO and GA. Both filters are 7 days One page has 29 unique viewers in SPO, 14 in GA Some pages are omitted in GA Pages from other sites have 1 hit (is GA counting exit pages?)8Views0likes0CommentsFilter Google Analytics Reports per Site
Does anyone know how to filter Google Analytics Reports per Site on SharePoint Online? I figured out how filter by path, but that is limited to one page. I need to "wildcard" it per site. Also, does anyone know how to exclude system pages like site/_layouts/...? How about site owner activity? Thanks for your help.Solved539Views0likes3CommentsColumn 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.12Views1like0CommentsConditional 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.12Views0likes0CommentsConfiguring SharePoint SE to trust third party OIDC authentication.
I am following this article to configure SharePoint SE to trust Login.gov OIDC 1.0 authentication. https://learn.microsoft.com/en-us/sharepoint/security-for-sharepoint-server/set-up-oidc-auth-in-sharepoint-server-with-msaad Following Step 3 to configure using metadata endpoint failed with the error: New-SPTrustedIdentityTokenIssuer : The security token service metadata document could not be parsed. Can SPSE work with third-party Idp other than Microsoft Entra ID to use metadata endpoint? The public key of login.gov will be rotated annually, so configuring it manually by hard coding the public key is not a viable solution.69Views0likes2CommentsHow to stop SharePoint list custom column formatting affecting form display?
Hello, I am trying to apply custom formatting to a multi-select 'Choices' column in a SharePoint list. The custom formatting applies consistent capitalisation to choices, and joins them with a delimiter (required as just applying the style removes spaces between choice items). The custom formatting JSON is as below: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "=join(@currentField,', ')", "style": { "text-transform": "capitalize" } } However, when I apply this style to the column through the JSON editor it affects the display of the corresponding field in the form, adding line breaks where they are not wanted, as below. I have tried adding "word-wrap": "nowrap" in the style element of the column format, which works to stop the new lines being added where they are not wanted but prevents logical new lines being added to show all selected elements. I've also tried variations of the "width" property in the style element to try and force the form to use all available space, but to no avail. Interestingly, this only affects 'edit' and 'view' forms (where you are interacting with an existing item) and is not affecting the 'new' form when creating new items. I have custom JSON formatting in the 'Head' section of the form itself, but nothing in the 'Body' or 'Footer' sections. I've tried removing the customisation in the 'Head' but this doesn't resolve the issue. If anyone has any solutions they can offer they would be very much appreciated.4Views0likes0CommentsRetrieving information about the SiteUserInfoList using REST API results in a 403 error
I tried to send the following GET request, authenticated as an administrator: https://<tenant-domain>.sharepoint.com/<site_path>/_api/web/lists?$select=Author,BaseTemplate,BaseType,Created,DefaultViewUrl,Id,LastItemModifiedDate,Title,DefaultView/ServerRelativeUrl,HasUniqueRoleAssignments,RootFolder/ServerRelativeUrl,RoleAssignments/Member/Id,RoleAssignments/Member/LoginName,RoleAssignments/RoleDefinitionBindings&$expand=Author,DefaultView,RootFolder,RoleAssignments/Member,RoleAssignments/RoleDefinitionBindings I got a 403 status code, with the error: "Due to organizational policies, you can't access this resource." To investigate the source of the problem, I tested the following request, which returned a valid output: https://<tenant-domain>.sharepoint.com/<site_path>/_api/web/lists I then iterated over the lists in the response, and for each such list I sent a request to get its data. All the requests returned a valid response, except one: SiteUserInfoList. When I tried to get information about this list, I got the same error mentioned above. I Googled it up and discovered this is a hidden list, maintained by SharePoint to store and manage user information profiles for authenticated users at the site collection level. I have a few questions: As administrator, does it make sense that I am forbidden from retrieving information about the SiteUserInfoList? Was the SiteUserInfoList always part of the lists shown in the _api/web/lists response? Or was it added recently? Is there a workaround I can apply to make this request work? https://<tenant-domain>.sharepoint.com/<site_path>/_api/web/lists?$select=Author,BaseTemplate,BaseType,Created,DefaultViewUrl,Id,LastItemModifiedDate,Title,DefaultView/ServerRelativeUrl,HasUniqueRoleAssignments,RootFolder/ServerRelativeUrl,RoleAssignments/Member/Id,RoleAssignments/Member/LoginName,RoleAssignments/RoleDefinitionBindings&$expand=Author,DefaultView,RootFolder,RoleAssignments/Member,RoleAssignments/RoleDefinitionBindings32Views0likes2CommentsLookup Column content disappears with conditional formatting
Hi all, SharePoint and it pointless limitations (or bugs) drive me crazy again... I have a list, that is used by different people. As it´s still not possible to color headers or similar, I got used to insert lines left or right of a column via conditional formatting. With such, I create "blocks" of columns for each user. Better that nothing... But now comes the kicker. It worked fine so far, but now with a lookup column, the content just disappears. This is my list without the border, numbers visible to the left. Now with formatting applied to the left lookup column, the content is just gone. I start with "no style" at formatting, as I only want to have the border. The teaser clearly shows, that text should be visible: The json code has some "hidden" attributes in there, but no matter what I change, the content does not reappear. { "$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": "sp-field-borderRightBold sp-field-borderRightSolid sp-field-fontSizeMedium" }, "children": [ { "elmType": "span", "style": { "overflow": "hidden", "text-overflow": "ellipsis", "padding": "0 3px" }, "txtContent": "[$PA_x0020_Nr_x002e__x003a__x0020_.lookupValue]", "attributes": { "class": "sp-field-fontSizeMedium" } } ] } Please help... How do I get the border AND my content? Thanks!36Views0likes2CommentsPersistent Browser Session
Hello, I can understand the concerns of the definition that saving the Session Cookie in the browser is problematic. Which brings me to define :"Persistent Browser Session" as "Never Persistent". It follows that every time you close and open a browser (login to SharePoint) the user is required to perform a renewed identification. which includes a name, password and MFA. frustrates the employees. What can be done about it, to make it easier for the users?17Views0likes1Comment
Events
Recent Blogs
- 4 MIN READSimultaneous multi-language document translation As the daylight hours grow shorter and the temperatures drop lower, we’re here to brighten your spirits with exciting news: SharePoint and OneDrive...Dec 19, 2024800Views4likes0Comments
- Join in the "SharePoint: From Concept to Creation to Impact + Live AMA" event to shine a light on the latest SharePoint capabilities and share glimpses of what some of our customers are doing wi...Dec 19, 20241.6KViews4likes0Comments