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
Power Automate: Valid Date/Time Inputs
Power Automate is the workflow engine of Microsoft's Power Platform, and flows come in many shapes and sizes. Often though, flows are created just to move data between systems. All data moves involve an ETL process, but to properly transform data, the extracted data must be properly structured. For example, extracting and formatting datetimes values. … Continue reading Power Automate: Valid Date/Time Inputs
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
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)
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
Power Automate: Parse Strings
The Power Platform is a collective of Microsoft tools natively extensible across Azure. Bundled within this collective is Power Automate, a cloud-based tool facilitating the automation of business processes... Noteworthy, Power Automate is great for empowering everyone; including none developers. Yet, it can feel restrictive to seasoned developers because things are done differently. The parsing … Continue reading Power Automate: Parse Strings
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)
console.log('Charles'); 