[SharePoint Online] has a number of features and functionalities. Among these, there is robust support for metadata. But why support metadata? Because metadata helps flatten files, index content, and improve search results. And with this robust support, metadata can be created at several different levels. One way to visualize these scopes... Local Regional National Global … Continue reading SharePoint Online: Metadata Scopes
Office 365
SharePoint: List Views (CAML Queries)
Collaborative Application Markup Language (CAML) is a schema used in SharePoint to query list data. Viewing, sorting, and grouping columns, that's straight-forward. One or two filter conditions, also straight-forward. But when three or more conditions are applied, the logic may get a bit murky. Because the UI hasn't really changed over the years, it still … Continue reading SharePoint: List Views (CAML Queries)
Azure Runbook: Task Logging
PowerShell is a scripting language great for task automation. The framework has gone through a number of iterations and Microsoft supports it in Azure. These cloud-hosted scripts are created as Azure Runbooks. Contrasted against the PowerShell ISE and Visual Studio Code, there are some logging differences with Runbooks. Locally run scripts typically write their logs … Continue reading Azure Runbook: Task Logging
Power BI: SPOList – Records v. Tables
Power BI Desktop can connect to a variety of data sources, including [SharePoint Online] lists. The text, date, and numerical columns will map directly, but a Person column will become a Record... E.g., list column Approver is a Person. So, what are Records? These are indexed data structures. Similar to hash tables, tuples, and structs, … Continue reading Power BI: SPOList – Records v. Tables
Power Automate: Populate SPO User Claims
Power Automate is the workflow engine of the Power Platform. Essentially, "Flows" access data via connectors, then perform tasks using actions. Included is a connector for [SharePoint Online] and a few dozen actions. Some actions to highlight: Get itemsUpdate item SCENARIO Remote workers are submitting travel requests and corporate has delegated an approver per state. … Continue reading Power Automate: Populate SPO User Claims
Xamarin: Prototype w/ Power Apps
There are a LOT of Android and iOS apps. Probably fair to say that they are bountiful. But there is a toolset difference... Android apps are typically built using Java while iOS apps are typically written using Swift (or Objective-C). Because of this, distinct apps need to be created for their respective app stores. Unless … Continue reading Xamarin: Prototype w/ Power Apps
Power Automate: Arithmetic Operations
There is are several Math functions available in Power Automate, but I find myself using the basic arithmetic operations most often. An important reminder for each operation, their respective functions will only accept two parameters at a time... E.g.,add( value1, value2 )sub( value1, value2 )mul( value1, value2 )div( value1, value2 ) If more than two … Continue reading Power Automate: Arithmetic Operations
Xamarin: Mockup w/ PowerPoint
Android and iOS apps are bountiful, but there's a toolset difference... Android apps are typically built using Java while iOS apps are typically written using Swift (or Objective-C). Because of this, two apps often have to be written for an app to be available in both app stores. Unless the app is written using Xamarin, … Continue reading Xamarin: Mockup w/ PowerPoint
Power Platform x SharePoint – Approval Requests: Part III (Power BI)
The Power Platform is a Microsoft offering of tools to help organizations meet challenges effectively. Among these tools, there are some notable standouts: Power Automate – Create automated business processes.Power Apps – Create custom forms and portals.Power BI – Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using … Continue reading Power Platform x SharePoint – Approval Requests: Part III (Power BI)
Power Automate: String Building
StringBuilder is a .NET class for string-like objects.. These objects are mutable and handy when appending strings, but that's .NET... E.g., written in C#. StringBuilder sb = new StringBuilder("Hello...", 25); sb.Append("\nCiao..."); sb.Append("\nBonjour..."); sb.Append("\nHola..."); Without the StringBuilder class, these strings are instead tacked onto the end of a variable... E.g., written in JavaScript. var message = … Continue reading Power Automate: String Building
Power Automate: SPOFile Share – Link Expiration
Someone asked me about anonymous sharing with expiring links. Although this could be configured at the tenant level, it isn't always set. As a workaround, how about a workflow to share a file, notify the recipient, then terminate the share? If you have a license for Power Automate, then you can create cloud Flows and … Continue reading Power Automate: SPOFile Share – Link Expiration
Microsoft 365 (The Cloud): Things You Can’t Break
Oversimplifying the cloud, it is subscribing to a company's infrastructure to store and access your files; Microsoft in this example. And with this subscription model, you may also have access to some of their software services. Keep in mind that these files and services are accessed via the internet. But you are NEVER granted too … Continue reading Microsoft 365 (The Cloud): Things You Can’t Break
Power Platform x SharePoint – Approval Requests: Part II (Power Apps)
The Power Platform is a Microsoft offering of tools to help organizations meet challenges effectively. Among these tools, there are some notable standouts... Power Automate – Create automated business processes.Power Apps – Create custom forms and portals.Power BI – Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using … Continue reading Power Platform x SharePoint – Approval Requests: Part II (Power Apps)
SharePoint Online: Site Quota vs Tenant Storage
[SharePoint Online] is a collaboration platform. To foster collaboration across the organization, SPO facilitates the creation of intranet sites to house artifacts. Although an oversimplified breakdown, that's the gist of it. And within each site, the artifacts can be any file type supported by the tenant. But bit-by-bit, these artifacts accumulate and take up space. … Continue reading SharePoint Online: Site Quota vs Tenant Storage
OneDrive: Hidden List (SharePoint Home Cache List – Part II)
The series has finally reached a conclusion. The final list, SharePointHomeCacheList, had so many items that it was divided into two posts. Part I spotlighted 3 list items and Part II will cover two additional items... E.g., export of list object in PowerShell ISE. Get target items $api = "/sites/$($siteGuid)/lists/$($listGuid)/items" $api += "?expand=fields" $lst1 = … Continue reading OneDrive: Hidden List (SharePoint Home Cache List – Part II)
console.log('Charles'); 