[SharePoint Online] empowers teamwork with team sites. These "dynamic and productive" team sites are created using prebuilt templates to scaffold workspaces for: Projects,Departments,Divisions,etc. Classic vs. Modern For those coming from the [SharePoint Server] world, SPO has some noticeable differences. First at bat, the site template options are limited. SPS offered several different site templates for … Continue reading Training: SharePoint Online – Site Templates
SharePoint Online
Training: SharePoint – 5000 Item Limit Threshold
### What The 5,000 items list view threshold is a limit on the number of items displayed in a single SharePoint view. This is NOT a limit on how many total items a list or library can hold. ### Why This is a performance restriction. Larger database queries require more resources and more processing. This … Continue reading Training: SharePoint – 5000 Item Limit Threshold
Training Session: Graph API – OneDrive vs SharePoint
Microsoft has invested heavily into their Graph API which connects with the Office 365 services. The approach of old, CSOM, not so much as of late. But that makes sense considering the services are cloud-hosted. CSOM was perfect for solutions running on the application server, but [SharePoint Online] doesn't allow this. Going forward, the Graph … Continue reading Training Session: Graph API – OneDrive vs SharePoint
Power Apps: Cascading Columns (custom)
Cascading columns are important to many applications, but often require custom solutions. Although the functionality is available out-of-the-box in Power Apps, custom solutions are still fun to build... For the uninitiated, cascading columns are essentially dropdowns that control the available selections of the next dropdown: e.g., Dropdown #1 - US StatesDropdown #2 - US CitiesDropdown … Continue reading Power Apps: Cascading Columns (custom)
Power Apps: SPO Document Library Upload
Power Apps is a Microsoft offering to quickly build business apps using pre-built templates. The content of these business apps is housed in various data sources, but presented via data connectors. Data connectors are essential to these business apps... Noteworthy, the [SharePoint Online] connector is a common Power App connection. For many organizations, if they're … Continue reading Power Apps: SPO Document Library Upload
Graph API: Query Teams Provisioned SPO Sites
Usage of Microsoft Teams boomed under COVID-19 shelter in place orders. For organizations with Office 365 licenses, Teams facilitated remote collaboration, but each newly created team provisions a [SharePoint Online] site collection. Post-quarantine, organizations may want to audit their Teams' provisioned SPO sites. And if end-users aren't restricted from creating teams, then there will be … Continue reading Graph API: Query Teams Provisioned SPO Sites
Batching w/ Microsoft Graph API – Part II
Batching w/ Microsoft Graph API - Part I used the Microsoft batch example as a guide, but their example created a folder in my [OneDrive for Business] account. Instead, I wanted to target a [SharePoint Online] site. And to specify which SPO site, the API requires the site ID... FYI, the Graph API site search … Continue reading Batching w/ Microsoft Graph API – Part II
Batching w/ Microsoft Graph API – Part I
Microsoft's Graph is a RESTful web API to interact with Office 365 services. Although still being developed, this currently includes CRUD operations for, but not limited to: SharePoint OnlineOneDrive for BusinessOutlookMicrosoft TeamsExcel Many of these REST requests are well documented with examples, but Microsoft examples won't address every scenario... Example: Use the Microsoft Graph Explorer … Continue reading Batching w/ Microsoft Graph API – Part I
Ticketing System via SPO w/ MS Teams and Power Automate
ServiceNow is great at what it does and this is not a co-sign. But I do enjoy being able to email the system and it generate a ticket on my behalf. However, some people would rather not use ServiceNow. Maybe the UI isn't what they're looking for. Or maybe they would rather build something using … Continue reading Ticketing System via SPO w/ MS Teams and Power Automate
SharePoint Online: External Sharing Audit (Option. II)
I recently wrote about external sharing in SPO. If you externally share content, then you may need to audit external accounts in your tenant. Note: Your tenant must allow external sharing. The Microsoft 365 Admin Center is your first resource to audit and report these external accounts. Secondly, you can use PowerShell to audit specified … Continue reading SharePoint Online: External Sharing Audit (Option. II)
Migrating from File Shares to Office 365: Step-by-Step *Suggestions*!
Note: Legacy file shares are still a thing! They serve a purpose. I'm sure of that, but I'm team cloud at this point and I'm with Office 365. I picked a team... Coincidentally enough, we (my job) decided to migrate to Office 365. All personal content goes to OneDrive for Business and group content goes … Continue reading Migrating from File Shares to Office 365: Step-by-Step *Suggestions*!
SPList: Simple Column Formatting
SharePoint is good platform to build on, but it continues to impress me what can be done with minimal effort. My background is programming and programmers like to build custom solutions. However, Microsoft has built so much into SharePoint that I haven't had to build any large custom solutions for quite some time. Not that … Continue reading SPList: Simple Column Formatting
SharePoint Online: External Sharing Audit (Option. I)
Admin Center \ Security & Compliance SPO easily allows sharing w/ external parties. The same is true w/ OneDrive for Business. However, this assumes that external sharing is allowed within your tenant. Some business requirements may require disabling this, but external sharing is not disabled here. Because of this, you may be required to audit … Continue reading SharePoint Online: External Sharing Audit (Option. I)
console.log('Charles'); 