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)
SharePoint Online
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
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)
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!
SharePoint Sites: Naming Conventions
Because of a recent initiative, I need to rename my Showcase site to Product Showcase. SharePoint (SP) site names are dynamic so I can update this through the UI... The change is simple and the update is immediate. But my site URL doesn't reflect this change. Why? Because site URLs are static... ex., SharePoint Online … Continue reading SharePoint Sites: Naming Conventions
Thank you, Retention Policy!
End-users delete a lot of content. So many "accidental" deletions... Anyway, they can delete content and often enough, they delete the wrong file! *gasp* Note: Another lengthy post, but w/ pictures... Deleted files go to the Recycle bin. The process is routine at this point... SharePoint Online files can be restored from the site's Recycle … Continue reading Thank you, Retention Policy!
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
Microsoft Graph API – Move SPO File
The Graph API has a learning curve, but is powerful. If you're working with Office 365, then the Microsoft Graph is definitely worth exploring. Note: You can test and work w/ the APIs via the Graph Explorer. https://developer.microsoft.com/en-us/graph/graph-explorer Task / Goal: Move a PowerPoint file from the "Marketing" folder in a source library to the … Continue reading Microsoft Graph API – Move SPO File
Microsoft Ignite 2019 – Recap
Microsoft just hosted Ignite 2019 in Orlando, FL. This was my first year attending and there was more than enough content. It's impossible to recap it all because it was impossible for me see everything: 25,000+ attendees 1,000+ sessions 300+ sponsors 200+ hands-on experiences I mean WHOA! Microsoft mission:"Empower every person and every organization on … Continue reading Microsoft Ignite 2019 – Recap
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)
console.log('Charles'); 