[OneDrive for Business] accounts are essentially [SharePoint Online] site collections. Because of this, ODfB sites also have several hidden lists that are discoverable with scripted solutions. One hidden list is titled Sharing Links and it keeps a record of shared items. Though the Microsoft 365 Admin center has a nice OneDrive activity report, custom solutions … Continue reading OneDrive: Hidden List (Sharing Links)
Training Session: Office 365 Tenant – What is it?
Office 365, now being rebranded as Microsoft 365, is a cloud-based ecosystem. The infrastructure is monitored, secured, and maintained by Microsoft. This includes but isn't limited to security patches, cumulative updates, and feature installs. Understanding that Microsoft is the steward of this environment, they are essentially the Office 365 landlords. However, organizations can subscribe to … Continue reading Training Session: Office 365 Tenant – What is it?
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 (OOB)
Unlike [out-of-the-box] features, custom solutions incur a bit of technical debt. Though, OOB features often come with some nuances and quirks to be wary of... Scenario, use cascading columns to: Select a region,Select a state,Select a city, andView a dynamic list of artists. Again, SQL tables are great, but [SharePoint Online] lists are easy to … Continue reading Power Apps: Cascading Columns (OOB)
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
Power BI: Intersect w/ Netflix Viewing Data
Recap: Visuals were built in the previous Netflix Viewing Data blog, but no formulas. Still, presenting the year-to-year viewing counts in stacked bar charts was simple enough. And the drilldowns weren't bad... Note: The Netflix viewing history export only includes the first time something is viewed, not each time it is viewed. However, today I … Continue reading Power BI: Intersect w/ Netflix Viewing Data
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
Power Automate: Parse Strings
The Power Platform is a collective of Microsoft tools natively extensible across Azure. Bundled within this collective is Power Automate, a cloud-based tool facilitating the automation of business processes... Noteworthy, Power Automate is great for empowering everyone; including none developers. Yet, it can feel restrictive to seasoned developers because things are done differently. The parsing … Continue reading Power Automate: Parse Strings
Training Session: SPO App Names – Static vs Dynamic
[SharePoint Online] apps are essential to SPO sites. The Custom List is a common app, but the Document Library app is probably the most popular. There will always be a request to host documents. But these apps require some considerations... What are these considerations? App names! Keep in mind that SPO apps have static and … Continue reading Training Session: SPO App Names – Static vs Dynamic
Ticketing System via SPO w/ MS Teams and Power Automate (Part II)
Note: Long post, but molte immagini... Creating a basic ticketing system in [SharePoint Online] is easy. But to include the email attachments, a few additional steps are needed. Luckily, Microsoft Teams and Power Automate will handle the heavy lifting again. Despite that, here are some semi-vague instructions: Create a team in Microsoft Teamse.g., Support GroupCreate … Continue reading Ticketing System via SPO w/ MS Teams and Power Automate (Part II)
Training Session: Office 365
Everyone resides at different levels of technical proficiency. As a result, training concepts must be flexible and cater to varying levels of understanding. To properly use Office 365, one must first understand what Office 365 is... What is Office 365? Office 365 is a cloud suite from Microsoft. This suite is available via a subscription … Continue reading Training Session: Office 365
Deleting Private Channels in Microsoft Teams!
Private channels have been available in Teams for several months now. As a result, plenty of people have created plenty of private channels. Some were created accidentally and some were created for testing purposes. Either way, I've been asked to delete several of these channels... Fun fact #1: Creating a private channel in Microsoft Teams … Continue reading Deleting Private Channels in Microsoft Teams!
console.log('Charles'); 