Helpful REGEX Formulas for PowerApps

Regex, short for Regular Expression, is a powerful tool used in computer science to match and manipulate patterns in strings. It enables efficient searching, extraction, and validation of data based on specified criteria, such as email addresses or phone numbers. Though concise, mastering regex syntax is essential for utilizing its full potential in programming and …

Restrict Web Access to SharePoint List

Blocking web access to a SharePoint list in favor of a PowerApp offers improved security, streamlined user experience, and enhanced performance. By channeling all interactions through the app’s controlled environment, sensitive data remains protected, while users benefit from a seamless, efficient interface designed for optimal productivity. This approach ensures a robust and effective data management …

Connect to SharePoint Online List via Powershell

In certain scenarios, it becomes necessary to establish a connection between a PowerShell script and a database in order to retrieve data. While it is widely acknowledged that SharePoint is not a conventional database, it serves as a repository for a vast amount of information within an enterprise leveraging Microsoft 365. In this particular scenario, …