This portfolio showcases the work I have done over the course of my career, even if many of my most recent projects were finished through my company. All of the examples on this page were created using ShareGate, Power Shell , and Power Automate.
SharePoint Migrations with Share Gate and Power Shell
During the process of developing the Company's intranet, a seamless transition from SharePoint Online Classic to both MS Teams and a Communication site was orchestrated.
A PowerShell script was rigorously created, employing the ShareGate PS module, to facilitate this move. The goal of this script was to automate the entire operation, with variable input parameters pulled from an Excel document serving as a guide for subsequent automated actions.
The automation included the dynamic construction of MS Teams sites and the migration of content from the SharePoint Classic source site. This material was strategically dispersed across numerous channels, and it was also generated dynamically by utilizing the Excel input file.
The extensive documentation of this migration process, including granular details of each content transfer, is noteworthy. This log meticulously records any failures or warnings occurring from SharePoint during the course of the activity. In addition, an inventory log was generated to account for all successfully moved sites, aiding in the development of a strong tracking mechanism.
Migration Sample Input File
Full Migration Logs
Inventory Validation - After Migration
Click to Zoom-in the images
All of the preceding processes were aggregated into a single output Excel report that provided access to all information from a single spot.
Content Approval Process with Auditing - Power Automate
Implemented the Content Approval Process for company Intranet with Audit Log for each location.
- All associated sites under HUB Intranet had dedicated non-published library to initiate the work flow.
- Uploading on new content initiated the content approval process. Content Owners for the site received email and teams notification containing task link to Approve/Reject the content.
- Out-of-box logging of the step-step approval process for content management in an Intranet Site
- Logged info, error and warning level details to troubleshoot any kind of errors
Click to Zoom-in the images
Sample Screenshot of the Audit Log list - Associated with Non-Published Document Libraries in each site in Company Intranet
Generate Security Reports - Power Shell
Automation of numerous reports related to site security and permissions was programmed using PowerShell modules designed for SharePoint. The results were shown in a neatly organised Excel spreadsheet with separate tabs for security and individual permit information.
Please see sample images on the let
Click to Zoom-in the images
- Site Security Details: This data tab is focusing on the details of the site level security.
- List Unique Permissions : This data tab focuses on listing all the list and libraries having unique permissions
- Document-Item Permissions: This data tab identifies all the list items and files having unique permissions across the whole site.
Out-Of-Storage Sites Alert Automation - Power Automate
Developed a comprehensive solution combining a Power Automate backend implementation and Power Apps for frontend site storage management.
- Implemented Power Automate routines that run daily REST calls to the SharePoint Admin Centre in order to retrieve the most recent storage data.
- creating a list of sites that require High Priority attention by analysing and filtering data according to predetermined thresholds.
- Serving as the main data source for the Power Apps front end application
- Distributing daily warning notifications to a specified group with filtered site information.
Click to Zoom-in the images
Sample Screenshot of the Daily Warning Notifications
SharePoint Alerts and Monitoring - On Prem
Following list is the back end logging list for Approval Workflow associated with INTRANET site.
- Using out of the box Custom JSON formatting and View formatting, this custom view is developed to look into the approval of document for auditing purposes
- Out-of-box logging of the step-step approval process for content management in an Intranet Site
- Logged info, error and warning level details to troubleshoot any kind of errors
Click to Zoom-in the images
Site and User Activity Report - Power Shell
To carefully record and examine User and Content Analytics for the sites before the migration process, a PowerShell application was developed. The output of the tool is extensive:
- Active User Analysis: Based on their most recent and frequent interactions with the site, active users are methodically identified and categorised using this tool's active user analysis feature. This research offers insightful information about user involvement.
- Active Content Assessment: The tool carefully assesses the content of the website and identifies active content components. Following that, these components are categorised according to how frequently they are accessed and modified, providing a thorough overview of the site's dynamic content landscape.
Employee Offboarding (SharePoint & OneDrive)- Power Shell
A thorough solution was developed as a crucial part of our staff offboarding protocol to help with the smooth transfer. A carefully designed PowerShell script was used to methodically revoke user permissions from SharePoint and OneDrive sites where the departing employee has access rights. This project guarantees the security and compliance of our data management procedures throughout personnel changes, protecting sensitive data and promoting a seamless transition for all parties concerned.
Resetting Site Unique Permissions - Power Shell
automated the process of resetting certain rights for each site's lists, items, and objects.
- Script will go through site permissions and will reset the web level unique permissions.
- In next step, script will loop through all the lists and will remove any unique permissions associated with it.
- Script will also go through all the items and documents to reset the unique permissions.
