The Microsoft 365 suite is a collection of cloud-based solutions: Outlook Online,SharePoint Online,Microsoft Teams,etc. Also included in this ensemble is Power Automate, Microsoft's workflow solution. Power Automate flows can use dozens (and dozens) of connectors to link both Microsoft and non-Microsoft solutions into automated processes: TwitterAsanaMailChimpYouTubeSalesforceetc. Essentially, an action triggers the process, then a series … Continue reading Power Automate: Microsoft’s “Rube Goldberg Machine”
SharePoint Online
SharePoint Online: File Metadata w/ Graph API
Microsoft's Graph API has endpoints for [SharePoint Online] lists and libraries. Worthy of note, document libraries are /drives when using the APIs. And although libraries are technically lists, the two resources will return different properties for the same SharePoint object. Additionally, some actions can only be performed using the /lists resources. An example of this, … Continue reading SharePoint Online: File Metadata w/ Graph API
SharePoint Online: Metadata Scopes
[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
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)
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
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: 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)
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 Platform x SharePoint – Approval Requests: Part I (Power Automate)
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.PowerApps - Create custom forms and portals.Power BI - Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using [SharePoint … Continue reading Power Platform x SharePoint – Approval Requests: Part I (Power Automate)
OneDrive: Hidden List (SharePoint Home Cache List)
Auditing [OneDrive for Business] sites with PowerShell and the Microsoft Graph API uncovered several hidden lists. The SharePointHomeCacheList is one of these lists, but it offers more information than the previously discussed lists. Continuing the trend of examination: Create script variables. [System.String] $endUserAccount = "charles@contoso.com" $endUserAccount = $endUserAccount.Replace("@", "_").Replace(".", "_") [System.String] $tenantName = "contoso" [System.String] … Continue reading OneDrive: Hidden List (SharePoint Home Cache List)
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
console.log('Charles'); 