Posts

Security Considerations When Using SharePoint Online

SharePoint Online offers a flexible, cloud-based platform for building internal portals, document repositories, and even limited public-facing content. But like any powerful system, it requires careful configuration to ensure it's secure—especially when content is meant to be shared or discovered across a broader audience. Authentication and Access Control The first layer of defense in SharePoint Online is identity. SharePoint is tightly integrated with Azure Active Directory, making it easy to manage access using Microsoft 365 groups, conditional access policies, and multifactor authentication. For internal sites, restrict access to only the necessary users or groups. Avoid using “Everyone” or “Everyone except external users” unless the site is truly intended for broad organizational access. If external sharing is required, limit it as much as possible: Use guest access sparingly and monitor usage Require sign-in for external users, rather than anonymous links Expire s...

Unexpected Integers where dates should be with Excel Online (Business) connector in SharePoint Online

Image
Importing an integer in place of a date in SharePoint Online and how to fix BLUF: if(empty(items('Apply_to_each_5')?['DOB']), null, if( isInt (items('Apply_to_each_5')?['DOB']), addDays ('1899-12-30', int(substring(items('Apply_to_each_5')?['DOB'], 0, 5))), formatDateTime (items('Apply_to_each_5')?['DOB'], ' yyyy -MM-dd')))          If you've ever tried to import data from an excel file into SharePoint Online, M365, formerly O365, aka down for leap days, you may have run across weirdness when importing a date. Your source excel document may know that that column is a date, or it may thing it's a string. Regardless, when importing, it imports a number like 30008, 20701, etc. This will also cause your flow to fail if you're importing into a date column.  I'll take you through all the steps (but if you just need the formula, it's above) 1. Add an Excel Online (Business) connector to list th...