Author

Joel Plaut

Developer, Architect, and Program/Project Manager

Email Author

Expertise

Developer
Architect
Program/Project Manager
Business Process Automation
Project Management
IT Governance

Favorite Tools

Microsoft 365
SharePoint

Joel is a multifaceted professional, serving as a Developer, Architect, and Program/Project Manager. His extensive experience spans consulting, IT executive roles, and diverse industries.

He possesses in-depth knowledge in collaboration, data warehousing, and enterprise intranet systems, with a specific focus on Microsoft 365, SharePoint, and back-office systems.

Joel is renowned for bringing outstanding technology, business, and organizational skills to the table, making him a specialist in business process automation, system architecture, enterprise deployment, design, solutions development, workflows, document management, organizational structure, and systems customization.

As an expert in project management, IT governance, methodology, and Portfolio Project Management, Joel ensures the seamless execution of projects.

His deep experience extends to designing, developing, and managing high-performance systems, demonstrating proficiency in technology selection, strategy, architecture, BI, collaborative document management systems, and software lifecycle methodology.

Joel is a catalyst for helping organizations optimize business value on a global scale, offering strategic insights and innovative solutions.

Articles

Power Apps

Offline capability in Canvas PowerApps

Summary: In today’s digital landscape, the demand for offline-capable applications is skyrocketing. With the prevalence of mobile devices and the…

Migration

Simplifying & Mastering Complex ECM System Migrations with…

In the rapidly evolving digital landscape, businesses must ensure their content management systems are modern, efficient, and future-proof. Migrating from…

Migration

Achieving Data Accuracy and Compliance in Migrations with…

Ensuring data accuracy and compliance during content migrations is paramount. As organizations move from legacy systems to modern platforms, maintaining…

Power BI

Unlocking Automation – Trigger a Cloud Flow from…

In today’s data-driven landscape, the integration of business intelligence tools and workflow automation has become paramount for organizations seeking to…

SharePoint

Developer’s Guide to SPFx Exploring the Key Files…

SPFx developers must grasp the layout of SharePoint Framework. This means understanding the different types of files included and what…

SharePoint Migration

Data Migration Best Practices for 2024 with Tzunami

Data Migration Best Practices for 2024 As we move forward through 2024, the landscape of data migration has transformed dramatically,…

Power Apps

Building Powerful Applications: A Guide to Creating Custom…

Microsoft Power Apps has emerged as a significant change in the realm of app development, offering a versatile platform to…

Power Apps

Create a Responsive Container-based Popup Dialog Box in…

Creating a responsive container-based popup dialog box in Power Apps involves designing a dynamic and adaptable dialog box that adjusts…

Copilot

Copilot in Action Create Your Site Through AI…

How to use copilot in power pages Make use of Copilot’s features when creating websites with Power Pages. AI…

Power BI

Refresh Dataset for Power Bi Report Using Power…

Power Automate, a service by Microsoft, presents a valuable feature that facilitates the refreshing of datasets utilized in Power BI…

Power Apps

Part – 2 Make Power Apps Ootb Form…

Follow these steps to set up the form responsiveness: Open the power apps and click on the setting. Go into…

Power Apps

Part – 1 Make Power Apps Custom Controls…

What is the responsive Power App form? Responsive Power App forms are made to be viewed and interacted with on…

SharePoint Online

Connecting to SharePoint Online using Managed Identity

When automating tasks in Microsoft 365, it’s best to avoid logon IDs and passwords. The best practice is to use…

Power Automate

How to Create a Word Document From a…

In Microsoft’s Power Automate, crafting dynamic and personalized Word documents through templates has become a streamlined process. Let’s start the…

Intranet Modernization

KWIZ & ProvisionPoint forge a strategic partnership with…

KWIZ and ProvisionPoint, operating as a unified force and recognized as a distinguished provider of Microsoft SharePoint governance and technology solutions, have…

Copilot

Empowering Interaction using Microsoft Copilot Studio

In today’s fast-paced digital landscape, businesses are constantly seeking innovative ways to enhance customer interactions and streamline processes. One technology that…

Copilot

Power Apps Development using Copilot

What is copilot in Microsoft 365? Copilot, an AI-powered development assistance tool, is integrated into Power Apps, enabling app makers…

Power Automate

The Power of Workflow Automation: Simplifying Business Processes…

Introduction: Efficiency and productivity reign supreme in today’s rapidly changing business landscape. However, manual tasks and intricate processes often act…

SharePoint

SharePoint for Remote Work: Enabling Collaboration and Productivity…

The world of work has undergone a significant transformation, with remote work becoming increasingly prevalent. The need for robust collaboration…

Power Automate

Seamlessly Automate Your SharePoint Tasks with Power Automate

Introduction: While SharePoint Online is a powerful collaboration and content management tool, manual tasks can often take up valuable time and resources.…

Intranet Modernization

Microsoft Power Platforms – Introduction, Products, Benefits &…

Introduction Businesses today require a wide range of technologies and tools to manage business processes, including approvals, reviews, filings, workflows,…

Enterprise Solutions

How Enterprise Web Application Development Benefits Your Business

A set of web pages with a single domain name representing your business is one way to define a business…

SharePoint Migration

How to Migrate File Server to SharePoint Online…

Switching to SharePoint entails more than simply transferring all of your data to a cloud server: it’s a completely new…

Financial Automation

How Financial Process Automation Can Help Your Business

Finance automation is leveraging technology to automate critical finance tasks with minimal human participation, including accounting, integration, general ledger,…

Document Management System

Why You Should Use SharePoint for Document Management…

SharePoint offers Document Management System (DMS) capabilities to streamline the document lifecycle from creation to archiving and offers the following…

Infopath

Incrementing repeating table field values

How to increment a field for new rows added into a repeating table in InfoPath It is really helpful to…

Architecture

How To Migrate Documents Into SharePoint

Getting documents into SharePoint There are many ways to get documents into SharePoint. This article covers a range of approaches…

Architecture

SharePoint 2016 News

Upgrading Release Candidate is an update to SharePoint Server 2016 Beta 2 and can be installed over Beta 2, so…

Powershell

Setting a Site Collection to not be read-only

How to set a site collection as not read-only Is your site collection read-only? It is critical to be able…

C#

Deploy multiple Office Solutions in a single setup

How to deploy multiple Office Solutions in a single setup After creation of all your MS-Office solutions, they can be…

Powershell

Changing the page for a SharePoint Library View

Views are easily created by end users, and can be created through automation. I recently had to change the underlying…

Powershell

Copying folder hierarchy with date filter and elimination…

Ever need to copy a tree of folders? I had to do this only for files older than a specified…

Powershell

Extracting to a CSV the list of files…

It’s easy to extract the set of files in all folders, here’s how using PowerShell: $Files = Get-ChildItem "C:ChooseAnyFolder" -Recurse…

Content types

Creating Fields and Content Types cleanly in SharePoint

when creating Content Types in SharePoint, it’s nice to script the process, for planning and repeatability. Here’s a nifty routine…

Powershell

Folder, File size and timestamp analysis using PowerShell

In just a few lines, one can generate a CSV of all files and their attributes including size and timestamp.…

Powershell

Encoding and Decoding URLs in PowerShell

URLs in SharePoint are often filled with “%20” in place of blanks, and other substitutions. However, there are times when…

SharePoint Migration

Fixing taxonomy terms after a Metalogix Migration

When migrating from SharePoint 2010 to 2013 using the Metalogix Content Matrix 7.0.0.1 migration tool, a taxonomy issue was encountered.…

Powershell

PowerGUI vs. PowerShell ISE

Boy, have I become dependent on PowerGUI for PowerShell scripting? I’ve recently been compelled to use the ISE that comes…

Architecture

Challenges in SharePoint projects

SharePoint is a great platform for application development. However there exist some challenges that need to be kept in mind…

SharePoint Development Solutions

Converting SQL for embedded use within VBA

Converting SQL for embedded use within VBA After creating and testing SQL to embed within a VB or VBA application,…

Business Intelligence

PowerPivot rollups of the previous slicer period using…

SQL Data Tools is great in SQL 2012, but I had a challenge to show rollups as separate measures for…

Powershell

How to delete all SharePoint webs in a…

Pretty useful and simple to delete all webs in a site collection except the root web. This worked for me,…

Powershell

Smoothly activating a Feature across SharePoint Site Collections

It’s useful to be able to activate features across site collections. This two line script grabs the desired feature, then…

Powershell

Assigning an Application Pool to a SharePoint Web…

the easy/obvious way is the wrong way. The trick is to reassign the app pool to the web app so…

Excel Services

Getting PowerPivot working in SharePoint

PowerPivot with SharePoint Diagnostics There are a lot of moving parts to PowerPivot. Here are some common causes of PowerPivot…

Powershell

Getting the absolute URL for a SharePoint SPItem

Getting the fully encoded absolute URL Most properties for an SPFile and SPItem only give part of the URL. To…

Powershell

Generating alternate colors in an email HTML table…

Generating rich text emails with PowerShell In this post: Generating automatic emails with embedded-reports and link to uploaded csvwe explored sending…

Architecture

SharePoint Database Naming

The primary naming convention to put in place is the Database Naming standard. By default, SharePoint puts a GUID at…

Sql

Metadata Warehouse of SharePoint Content

I often write custom reports to be able to analyze huge data from a SharePoint farm. I can ansewr questions…

Navigation

Adjusting Quicklinks Programmatically in SharePoint

Use PowerShell to set Quicklinks Programmatically in SharePoint Wouldn’t it be great to hide all lists of a certain type…

Content types

Removing a stubborn Content Type from a SharePoint…

Removing a Content Type from a SharePoint Library Having a single content type in a library can make a library…

SharePoint

Clearing out all SharePoint document versions for a…

Wiping out all SharePoint document versions for a set of documents Sometimes users create many versions of a document inadvertently.…

Powershell

SharePoint Group Management

Managing SharePoint Groups in PowerShell SharePoint Groups are a great mechanism for managing user permissions, however they exist within a…

Alerts

Generating automatic emails with embedded reports and link…

Generating automatic emails with the embedded content There’s often a need to automate the generation of reports on SharePoint. I…

Event receivers

Reporting on SharePoint Event Receivers

SharePoint Event Receiver Reporting Event Receivers are a very powerful SharePoint construct. Because of timing issues, they can be tricky…

Powershell

SharePoint Full Farm Site Collection Admin report

Reporting on SharePoint Full Farm Site Collection Admins Site Collection Administrators retain a great deal of power and capability within…

Performance

SharePoint Monitoring Metrics

SharePoint Monitoring Metrics I pulled together some useful metrics for monitoring SharePoint environments: Storage Server drive(s) disk space availability (15%…

Book Review

Book Review: SharePoint 2010 Development with Visual Studio…

Cookbook is a good term for this book. It is an excellent overview of SharePoint programming, with a task focus…

Powershell

AD User group membership not propagating into site…

AD User group membership propagation issue In some rare instances, users may exist within a Site Collection that don’t receive…

Powershell

Copy files in folders from a Document Library…

Copy SharePoint files in folders to disk A common request is extracting all the files within folders in a document…

Infopath

InfoPath error when runtime dlls are wiped

InfoPath error for runtime DLLs disappearing I had an interesting problem the other day. One of the users of an…

Powershell

Automating Creation of Per-Location Views

Automating the Creation of Per-Location Views SharePoint offers the capability of customizing the Views in Folders. This can be done…

Business connectivity services

Smart Filtering in BCS

Smart Filtering in Business Connectivity Services Business Connectivity Services allows the rapid creation of reference connections to live legacy data…

Security

Item Level Permissions

Item Level Permissions SharePoint has a robust object model supporting security at each level of the farm. Let’s take a…

Powershell

Gradual Site Collection Deletion

Gradual Site Collection Deletion I had a mission to achieve overnight; move 28 site collections into a new managed path,…

Performance

Sync DB Grows Indefinitely

Sync DB is a database that is a part of the User Profile Service related to Active Directory synchronization. Unfortunately…

Powershell

Solving asynchronous Event Handler update conflicts

Titus makes truly great and unique software for securing SharePoint documents based on metadata. However I ran into a huge…

SharePoint

Clarifying the Security Scope limits in SharePoint lists

Historically, Microsoft has defined it along the more conservative definition as “A scope is the security boundary for a securable…

Fast Search

Tuning Your Crawl

Want to tune your Search crawling? There’s plenty of benefit to be had refining how Search crawls in SharePoint. Eliminate…

Content types

Eliminating metadata from the Folder Content Type

Once again I was compelled to swoop in to fix a managled set of Metadata and Content Types for a…

MySite

Trusted MySite Host Location

How often can one make a change in Development that blows up Production? Within the User Profile Service Application one…

Rbs

RBS external provider invalid reference

Inside every Content Database is a key table called AllDocs; when configured for RBS there is a field called DocFlags…

Security

Secure Store Master Key Error

Don’t you hate mysterious, scary errors? How about this one? A critical incident has occurred where the Secure Store service…

Project Server and Web Access

Migrating a full copy of MS-Project Server content

There’s a frequent need to refresh MS-Project Server test environments from Production. The conventional wisdom holds that you need to delete…

Rbs

RBS (Remote Blob Storage) part 3

A configured and running Remote Blob Storage (RBS) is a ticking time bomb until you’ve configured the Maintainer to run.…

Rbs

RBS (Remote Blob Storage) part 2

To get RBS going we are going to configure SQL Server, install the RBS libraries on the SharePoint servers, and…

Rbs

RBS (Remote Blob Storage) part 1

Remote Blob Storage (RBS) is a Microsoft technology for managing large BLOBs (Binary Large Objects) in SQL Server and is…