How to generate a sample data test file using PowerShell

5gb sharepoint drag and drop

Using PowerShell, you can quickly create a test file on your computer. I use these for testing SharePoint attachment upload sizes. You can generate files in mb, gb, etc. easily. This example generates a 5gb test file in  C:\Users\MyUserName\AppData\Local\Temp called testfile.txt $path = "$env:temp\testfile.txt" $file = [io.file]::Create($path) $file.SetLength(5gb) $file.Close() Get-Item $path Example of the above … Continue reading How to generate a sample data test file using PowerShell

SharePoint Online- Bad service principal breaks SharePoint Admin API Access “Global Service Principal ID Error: Error: {}” Resolved

Could not retrieve Global Service Principal ID Error

We recently ran into an issue when creating SPFX Azure Active Directory App registrations using an O-Auth Implicit flow that our SharePoint Admin Center API Access page then gave an error: Could not retrieve Global Service Principal ID Error: Error: {} And when using O365 CLI, I was getting the same error trying to add … Continue reading SharePoint Online- Bad service principal breaks SharePoint Admin API Access “Global Service Principal ID Error: Error: {}” Resolved

SharePoint Online- Create a new Home Site in an existing tenant. Spoiler- its not available yet.

This week at #MSIgnite, there has been a lot of talk about Home Sites. This was released a few months back as a PowerShell command to transform any modern communication site collection into the O365 SharePoint Online landing page for your organization. More can be read here: https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/SharePoint-home-sites-a-landing-for-your-organization-on-the/ba-p/621933 SharePoint home sites are the landing sites … Continue reading SharePoint Online- Create a new Home Site in an existing tenant. Spoiler- its not available yet.

SharePoint Online max attachment and upload sizes for lists and libraries

Overview I tried finding a few good articles about upload sizes for SharePoint. I was a bit confused with old articles, new ones, One Drive for Business sync tools, classic vs modern and was unsure exactly what sizes to recommend to a client. So, I decided to do a POC with various large dummy file … Continue reading SharePoint Online max attachment and upload sizes for lists and libraries

SharePoint Online – Change the Look- Classic vs. Modern

I recently created a Microsoft Office 365 development environment via https://aka.ms/offdp I was creating an environment to do some SharePoint Modern theming (I created a new Communication Site via the modern Admin interface on my new tenant), but noticed the classic (rather the older) Change the Look interface: However, on existing client's tenants, I noticed … Continue reading SharePoint Online – Change the Look- Classic vs. Modern

Azure VM Remote Desktop error- CredSSP encryption oracle remediation

I ran into an issue where I could not Remote Desktop to my Azure VM and was getting this error: Remote Desktop Connection An authentication error has occurred. The function requested is not supported Remote computer: 13.64.xx.xxx This could be due to CredSSP encryption oracle remediation. For more information, see https://go.microsoft.com/fwlink/?linkid=866660 The issue was a … Continue reading Azure VM Remote Desktop error- CredSSP encryption oracle remediation

Deleting a large list from SharePoint using PowerShell

I recently ran into an issue trying to delete a list over 5,000 items from SharePoint. I tried using Metalogix Content Matrix to delete the list/site, but they all were bound by the threshold. I realized I had to use PowerShell, but research lead to even this having issues deleting the list. The solution was … Continue reading Deleting a large list from SharePoint using PowerShell

Updating Visual Studio 2017 Enterprise

Yesterday I noticed a release (VS 2017 Update 6) was released, but my Visual Studio was still running Update 3: The newest update is version 15.6. While reading how to update Visual Studio, the article mentioned Visual Studio Installer. https://docs.microsoft.com/en-us/visualstudio/install/update-visual-studio So I launched Visual Studio Installer and clicked "Update". Note, the installer did not tell … Continue reading Updating Visual Studio 2017 Enterprise

Create a SPFx web part to display SharePoint list data based on locale and Graph API data

This is an example of how I used the SharePoint Framework (SPFx) to create a modern page/modern experience web part that shows SharePoint list data based on a user's Language/Locale/Country and some other user profile information from Azure Active Directory using the Graph API. We onboard guest users using Azure AD B2B to our SharePoint … Continue reading Create a SPFx web part to display SharePoint list data based on locale and Graph API data

SharePoint Online Communication site – How to share with external users

I had an issue where when I tried to share my SharePoint Online Communication Site with an external user, I received an error: Your organization's policies don't allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it. But when I went to my O365 tenant, … Continue reading SharePoint Online Communication site – How to share with external users

SharePoint Online blog site- How to edit the homepage

Problem After about a week of troubleshooting the classic SharePoint Online blog subsite template (BLOG#0), I was FINALLY able to figure out why I could not edit the homepage. Solution: There is a site feature called "Site Pages" that needs to be activated. Once activated, you can edit the blog homepage (assuming you have permissions). … Continue reading SharePoint Online blog site- How to edit the homepage

SharePoint Online- Enable New Modern experience on root site collection

UPDATE 9/27/2019- Microsoft this month is releasing a way to "Swap" sites. So create a new modern site collection, then swap it with the root. Invoke-SPOSiteSwap https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/invoke-spositeswap?view=sharepoint-ps#description If the target is the root site at https://tenant-name.sharepoint.com, then the following preparation activities should be performed prior to performing the swap: Any Featured links defined in SharePoint Start … Continue reading SharePoint Online- Enable New Modern experience on root site collection

SharePoint Server Trail period reinstall fix

Today, I was hit with a SharePoint error on a developers VM when I tried to create a new Site Collection in Central Admin: Sorry, something went wrong The trial period for this product has expired. When I tried to view a teamsite homepage, I received this error: Sorry, something went wrong The "SiteFeedWebPart" Web … Continue reading SharePoint Server Trail period reinstall fix