Power App canvas apps are extremely customizable. As makers build their business apps, they can connect to data from dozens of sources and output data records dynamically. An easy way to list these records, bind the data source to a gallery control: "A control that contains other controls and shows a set of data… A … Continue reading Power Apps: Design | Nested Galleries
Microsoft
Power Automate: Object Properties
Using connectors and actions, Power Automate can CRUD data from different sources. Often enough, the returned data is simple text and/ or numerical values, but can sometimes be complex data objects. Represented in a JSON format, the properties of these complex data objects can typically be retrieved with key-value pairs... E.g., storing SharePoint list items … Continue reading Power Automate: Object Properties
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
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 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
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)
OneDrive for Business: Default Open Behavior of Office Files
[OneDrive for Business] is typically synced locally to a user's computer. However, Microsoft is embracing a browser-first model for many of their roll-outs. Because of this, everyone should get more comfortable working within the browser. But heavy Office users often aren't impressed with the Online versions. Instead of choosing to open their Excel, Word, and … Continue reading OneDrive for Business: Default Open Behavior of Office Files
Power Apps: SPO People Picker Properties
Migrating to [Azure Active Directory] has companies correcting their local [Active Directory] structures. Considering AD was so forgiving, best practices weren't always adhered to. But an enterprise offering like AAD enforces better practices. Silver lining, this is great for custom solutions because user properties are now more consistent... How it Started... I created an overly … Continue reading Power Apps: SPO People Picker Properties
OneDrive: Hidden List (Recent Lists)
Another hidden list found, so onward to part 5 of the series... This might be a new-ish container, but it logs recently created [SharePoint Online] lists by a person so it gets audited: Create script variables. [System.String] $endUserAccount = "charles@contoso.com" $endUserAccount = $endUserAccount.Replace("@", "_").Replace(".", "_") [System.String] $tenantName = "contoso" [System.String] $requestAPI = "" [System.String] $siteGuid … Continue reading OneDrive: Hidden List (Recent Lists)
console.log('Charles'); 