Author Archive

PeoplePicker Issues with SharePoint 2019 in a DMZ

December 21, 2021

We have the task of installing SharePoint 2019 in a corporate DMZ but then connecting back behind the corporate firewall to the AD instance so our corporate users can connect to the platform via SSO.  We ran a wacky STSADM -O command that allowed us to successfully connect the PeoplePicker in Central Admin to add […]

Posted in SharePoint 2019 Comments Off on PeoplePicker Issues with SharePoint 2019 in a DMZ

OneDrive admin center settings are coming to the SharePoint admin center

May 10, 2021

This is good news.  For those of us who have SharePoint Online admin access but do not have admin access over the entire Microsoft 365 tenant, this will give us a little more ownership.  The post was released previously but updated today.  It may take even longer for those of us on the Government Cloud […]

Posted in Office 365 Comments Off on OneDrive admin center settings are coming to the SharePoint admin center

Automation options for SharePoint Online

November 17, 2020

There has been, and continues to be, a lot of buzz about PowerApps in Microsoft365 (previously called Office365). As the workflow engines behind SharePoint 2010 and SharePoint 2013 workflows are disabled and soon to be disabled (respectively) for SharePoint Online, the push is to rewrite them for SharePoint Online using PowerApps. That’s pretty much the […]

Posted in Office 365 Comments Off on Automation options for SharePoint Online

Error connecting to Microsoft365 using MFA: The sign-in name or password does not match one in the Microsoft account system

August 2, 2020

If you have received any of these errors lately trying to connect via Multi-Factor Authentication (MFA) to your Microsoft365 tenant using PowerShell, the resolution may be that you need to revise your login script. Click each image to open in a new window. Simply put, the resolution we’ve found is to use the -UseWebLogin parameter […]

Posted in Office 365 Comments Off on Error connecting to Microsoft365 using MFA: The sign-in name or password does not match one in the Microsoft account system

View Workflow History

July 24, 2020

With Microsoft disabling SharePoint 2010 workflows in Microsoft365, you may find yourself hurriedly creating an inventory of all of your workflows in SharePoint Online so you can rewrite them in PowerAutomate or Nintex. It would be helpful to know the last time a workflow was ran and/or how much that workflow is being used (if […]

Posted in Office 365 Comments Off on View Workflow History

Export Search Results for entire Office365 tenant to CSV

June 21, 2020

I needed to perform a search of our entire tenant for a few key terms and then produce a CSV of all the search results. I was not able to find anything on the web which produced this result. The best thing I could find was a PowerShell script for searching a single site collection […]

Posted in Office 365 Comments Off on Export Search Results for entire Office365 tenant to CSV

Hide “Download” option on documents right-click menu

May 30, 2020

Do you want to prevent people from downloading a copy of a document or spreadsheet from SharePoint? I’ve shown you previously how to hide the Download to Excel button in the ribbon. This is the next step in the evolution of keeping your users dialed back. Hover over any document or spreadsheet for an elipsis […]

Posted in Office 365 Comments Off on Hide “Download” option on documents right-click menu

Remove Left-Hand Nav on a List Form

April 8, 2020

Today I was asked to remove the left-hand navigation on the New Item form for a list in Office365. The form was opening in full-page mode, rather than the “modal dialog” format (aka “LightBox”) and was showing the site navigation on the left. The site owner did not want this. This should also work on […]

Posted in Office 365, SharePoint 2013 Comments Off on Remove Left-Hand Nav on a List Form

Adjust / Modify Column Width in an Office365 List

August 2, 2019

Previously, I wrote about how to adjust the column width of a list in SharePoint 2010. However, none of that advice works in SharePoint Online. There is a ton of crazy information out on the web and most all of it is useless. I found this one suggestion by Vadivelu B. on a Microsoft forum to be just […]

Posted in Office 365 Comments Off on Adjust / Modify Column Width in an Office365 List

Import Excel file into an Existing List

January 29, 2019

SharePoint offers the basic feature of importing a spreadsheet which will then become a brand new list. If any updates are made to the spreadsheet, you will either have to: manually key in the updates to the list -or- copy and paste the updates to the list using the DataSheet View or QuickEdit (depending on […]

Posted in Office 365, SharePoint 2013 Comments Off on Import Excel file into an Existing List