My blog on SharePoint, Power Platform and related stuff.
I'm sharing my slide-deck and promoted URL's from the Brock University: Our journey to the cloud using SharePoint webinar. The slide-deck can be downloaded below. Here are the promoted URL's: Want to know more? Visit the SharePoint blog Want to get inspired? Get the SharePoint Look Book Thanks to those that attended and thanks to … Continue reading SharePoint Webinar
This blog post was prompted by recent activities in my O365 developer tenant. I noticed that I had not set the default time zone during site creation (see image below). It’s easy to change the time zone through Site Settings > Regional Settings but, it's even easier if you set it once for all new … Continue reading SPO Admin change the default Time Zone
Microsoft released a simple, yet very effective, approval tool for business automation called Request sign-off. The request for sign-off comes "out of the box" and works with individual documents and list items. To start a sign-off: Select the target document; click Flow and select Request sign-off. Click Create flow. Behind the scenes the flow will … Continue reading Modernize Sign-offs with SharePoint Online
Most higher-ed institutions have the need to manage agreements with other institutions (i.e. exchange programs). This usually comes in the form of an Excel spreadsheet buried away in a shared network drive. Using SharePoint and Flow will go a long way in modernizing agreements management by surfacing content and adding value through automation. Recent enhancements to … Continue reading Modernize Agreements Management
The Issue Tracking app has been around since SharePoint 2007. It has proven itself useful for projects and support operations alike. Recent developments with column formatting present opportunities to breathe new life into the Issue Tracking app. Current Issue Tracking: Issue Tracking with column formatting: The use of JSON column formatting in the Issue Tracking … Continue reading Reinvigorating the SharePoint Issue Tracking App
The modern experience is a welcome addition to the SharePoint platform. The user experience is elegant and works well on desktop and mobile platforms. The modern experience comes "out of the box" with all SharePoint Online provisioned Communication and Team sites. For those of us with legacy "Classic" sites the option to “upgrade” is available … Continue reading SharePoint Hacks – Modern Experience
In January 2018 Microsoft released the SharePoint Migration Tool for file-share to SharePoint Online (SPO) migrations. Prior to this announcement migration options were limited to PowerShell or 3rd party tools like Sharegate. I've been lucky enough to have access to Sharegate and use it for more than just file and site migrations. Auditing, reporting, security … Continue reading Migration Match Off: PowerShell vs Sharegate vs SharePoint Migration Tool
Power BI Desktop is an excellent tool for ETL (extract, transform and load) operations and can perform almost any transformation that its big brother, SSIS (SQL Server Integration Services) can. Most ETL operations can be performed with no code - this is a big plus for those new to Power BI or for rapid report … Continue reading Data Validation with Power BI
Power BI is an excellent data visualization tool but for data exploration Power BI is not a traditional choice. Tools like R and Python are two of the most popular data exploration tools on the market but come with a steep learning curve in order to master syntax and all of the other complexities that … Continue reading No Code Data Exploration with Power BI
In Part 1 of this blog, we extracted Audit Log data from Office 365 using PowerShell and stored it in SharePoint for the purposes of quantifying Power BI adoption. In Part 2 we will transform and visualize the Audit Log data using Power BI. We’ll focus on: connecting and transforming the Audit Data from JSON … Continue reading Measuring Power BI Adoption using PowerShell, SharePoint and Power BI – Part 2
