Microsoft Lists are powerful. Especially when they're used to organize things like project tasks, support requests, product logs, etc. But regardless of the list's purpose, lists are created for either the individual or the group. If the individual, then the list is created in that person's [OneDrive for Business] site. Otherwise, the list is saved … Continue reading MS Lists: Power Automate Connectors
Power Automate
Power Automate: Calculate Days in a Month
Often enough, calculating the number of days in a month becomes a developer's task when working with calendars. Back in my newbie days, my solution was creative, and it worked, but it wasn't very efficient. Instead of an elegant formula, I just parsed a date value from a string inside a Try-Catch block: try { … Continue reading Power Automate: Calculate Days in a Month
Power Automate: Copy Emails + Attachments to SPO
Closing out this story, the Power Automate flow built to copy Outlook emails to [SharePoint Online] should have copied the email attachments as well. Though not every email has attachments. Tweak the flow and check for attachments, then copy when necessary... Reviewing a previous flow run, examine an export of the tempObj variable. Take note … Continue reading Power Automate: Copy Emails + Attachments to SPO
Power Automate: Copy Emails to SPO
Once upon a time there was a very special user. This user was great at their job and worked with us for many years. Throughout the years, their job responsibilities required that they catalogue and archive legal records for the business. Unfortunately, soon enough, they were ready for new career opportunities. Now, they needed to … Continue reading Power Automate: Copy Emails to SPO
Power Automate: Working w/ Arrays
The Power Platform prides itself on being low-code. While accurate, each solution requires different levels of coding. Power Automate, the low-code workflow creator, empowers developers to use variables when coding their business automations... Among the available variable types, array is a common data structure in many programming languages. For the uninitiated, arrays are essentially collections … Continue reading Power Automate: Working w/ Arrays
Power Automate: What If… Automation?
Automation is already a thing in our lives, in particular: Email - Inbox rules.Scheduled emails.Automatic replies. Banking -Balance alerts.Scheduled autopay.Monthly transfers Digital Assistants -Set a reminder.Schedule <event>.Call <person>. However, these are usually single action workflows. Something, the "trigger", prompts an activity, the "action". Depending on the activity, people may still need to carry out some … Continue reading Power Automate: What If… Automation?
Power Automate: SPO Item Version Delta
[SharePoint Online] is a well known document management solution. Baked into this Microsoft solution is metadata and versioning. In simplest terms, metadata is document tagging. Versioning is an audit trail of document changes - including document properties... Figure 1 - Version history of a SPO list item. Working with SPO, Power Automate has an action … Continue reading Power Automate: SPO Item Version Delta
Power Automate: Populate SPO User Claims (multiple claims)
Power Automate can add user accounts to SharePoint Online list items. If the person column accepts a single account, then the assignee claims are passed as a string. But for multiple accounts, the assignee claims are passed as an array. Illustrating this, loop through a list of approvers, then add them all to a list … Continue reading Power Automate: Populate SPO User Claims (multiple claims)
Microsoft Forms: Field GUIDS w/ Power Automate
Microsoft Forms is great for quickly collecting responses. Simple forms are created in a few minutes, but even more robust forms are created in maybe half an hour. Though, once the data is collected, what's next? Someone could process the form results with Power Automate. And mapping most fields is straight-forward. Yet, it's important to … Continue reading Microsoft Forms: Field GUIDS w/ Power Automate
Power Automate: Microsoft’s “Rube Goldberg Machine”
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”
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
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 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
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
console.log('Charles'); 