In this post, I share my journey of automating a weekly update of a SharePoint Online list using PowerShell. Faced with the challenge of importing an HR CSV report, I discovered the PnP PowerShell module, which greatly simplified the process. I cover how to connect to SharePoint, import data, empty the list, and update it, while also addressing the challenge of matching username formats. This guide aims to make your first experience with SharePoint Online and PowerShell automation smoother and more efficient.