Forum Widgets
Latest 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. Thanks
SPO 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?)Audit of permission changes for SharePoint folder
Hi all, trying to find a way to audit who has added users internally to some critical sharepoint folders. Trying via MS Purview > Audit, but no luck so far. Anyone could advise what exactly do I need to search for? (particular friendly activity for example). I’ve tried with no activities selected (so assume all are included) and specified Folder and set Workloads > SharePoint. However, it does not seem to return any permission changes… only events like file/folder access, creation, etc… any idea? We use have M365 E3 and M365 E5 Security subscriptions
Sharepoint excel file wont stop loading
Hi guys. Is it just me or is everyone facing a problem with Sharepoint excel files constantly just loading and not opening? My company runs on the sharepoint excel file and we cant access it suddenly since yesterday. It just says loading and wont stop loading and then it says it cant be opened. Any solutions?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.
Event Calendar Start and end date
Hi I work in a hotel and we have a ballroom and outdoor space we rent for events and meetings for the customer I created a list to record all the event reservations in the hotel and it is working beautifully but I have only one problem I can't solve some of our clients need to reserve our venue for 4 or 5 days in a row to add these events to my list I have to add 4 events, one for each day. I can't assign a start date and end date In my list items columns so I add one event starting on 1/1/2025 and ending on 5/1/2025 for example and it will show in the calendar view the reservation on these days
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.
JSON Conditioning with multiple IF statements
Hello I am trying to format a date column. The date in the column is a date that someone completed a certification and that certification expires after one year. I am trying to using conditional formatting comparing the date in the column against the current date to show if the certification is still valid, getting close to expiring, or expired. I can't seem to get it to work. { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "attributes": { "class": "=if((@currentField >= @now – 31536000000 && @currentField <= @now – 5184000000), 'sp-field-severity--good', if((@currentField >= @now – 5183999999 && @currentField <= @now – 2592000000), 'sp-field-severity--warning', if(@currentField >= @now – 2591999999, 'sp-field-severity--severeWarning', 'sp-field-severity--blocked'))) + ' ms-fontColor-neutralSecondary'" }, "children": [ { "elmType": "span", "style": { "display": "inline-block", "padding": "0 4px" }, "attributes": { "iconName": "=if(@currentField >= @now – 31536000000 && @currentField <= @now – 5184000000), 'CheckMark', if(@currentField >= @now – 5183999999 && @currentField <= @now – 2592000000), 'Error', if(@currentField >= @now – 2591999999, 'Warning', 'ErrorBadge')))" } }, { "elmType": "span", "txtContent": "@currentField" } ] }
