The ask, convert a whole number to binary. The approach, use a do-while loop and the cloud flow to calculate the power of a number, calling it as a child flow. At some point, this flow may also be used as a child flow, so create it using the Respond to a Power App or … Continue reading Power Automate: Do While Loop | Calculate Binary Of
Author: Charles
Power Automate: SharePoint Online | Check If Document Set Exists [ v2 ]
The ask, determine whether or not a document set exists before Power Automate tries to create one. Otherwise, the cloud flow will run long, appear stuck, and eventually fail. The flow could check for an existing document set by Name, but because SharePoint Online (SPO) isn't the source of truth system. this column value isn't … Continue reading Power Automate: SharePoint Online | Check If Document Set Exists [ v2 ]
Merry New Year | 2025
Cheers to 2025! Quickly recapping 2024, I wrapped the year with 11 speaking events: 10 in-person and 1 virtual. Among the in-person events, I taught my first workshop in MN, traveled to Montreal, QC for an event, and visited 6 different states, speaking in 8 different cities. I still blogged quite a bit but slowed … Continue reading Merry New Year | 2025
Power Automate: Do While Loop | Calculate Power Of
The ask, create a Power Automate cloud flow to calculate exponentiation, a base value taken to the power of an exponent value. Ultimately, this flow will be one of many flows filling in where Microsoft hasn't yet provided an expression. For this ask, create a new cloud flow and choose "When Power Apps calls a … Continue reading Power Automate: Do While Loop | Calculate Power Of
SharePoint Online: JSON Column Formatting | Link to Power Apps
The ask, create a dynamic link from a SharePoint Online (SPO) document library, navigating end-users to a Power Apps canvas app. This app expects "deal_id" as a parameter, Param(), which would be the id of the library item. Is it possible? Yes. Is it complicated? No. SPO libraries, which inherit from lists, are relatively easy … Continue reading SharePoint Online: JSON Column Formatting | Link to Power Apps
Microsoft Dataverse: Table Designs w/ Copilot
The ask, create new Dataverse tables for an upcoming initiative. There are several existing tables that could be used for this initiative, but the project requirements necessitated new tables be created. Because this is an upcoming initiative, business stakeholders aren't ready to build the solution UI, even though Microsoft Copilot could create everything for them: … Continue reading Microsoft Dataverse: Table Designs w/ Copilot
Microsoft 365 Copilot: Data Readiness | SharePoint Online
The ask, evaluate and audit the SharePoint Online (SPO) environment before the Microsoft 365 Copilot rollout, Microsoft's artificial intelligence (AI) assistant for the M365 apps. The top-most concern of the business leaders is whether or not their content is permissioned properly. Though, a security audit could easily help identify SPO sites with lax sharing and/ … Continue reading Microsoft 365 Copilot: Data Readiness | SharePoint Online
Power Automate: SharePoint Online | Update Document Set Metadata
The ask, update the metadata of a document set using a Power Automate cloud flow. In this ask, the document sets are created when certain conditions are met in an external source system. Post-creation, that metadata is kept in sync, receiving updates as changes are made in the source system. So, creating the document set … Continue reading Power Automate: SharePoint Online | Update Document Set Metadata
Power Automate: SharePoint Online | Check If Document Set Exists
Document sets aren't new to SharePoint Online (SPO), but plenty of organizations are just discovering them as they're a great way to bundle related documents. And document sets allow organizations to group and manage these related files as a single entity, defining metadata for the entity instead of individual files. Figure 1 - SharePoint Online … Continue reading Power Automate: SharePoint Online | Check If Document Set Exists
Microsoft Dataverse: Virtual Tables [ Pros ]
Unfortunately, Microsoft Dataverse isn't a data storage consideration for many Power Platform makers because their organizations are already using other data sources like SQL Server, Salesforce, SharePoint Online (SPO), etc. These other data sources are well-supported, but Dataverse is the foundation of the Power Platform, so there is native integration for it in Power BI, … Continue reading Microsoft Dataverse: Virtual Tables [ Pros ]
Power Apps: Canvas App | Ranked Choice Voting (RCV)
This is likely to be a lengthy post because there was no ask today. I just wanted to stress test nested Power Fx With() functions a bit. My question, "Are there any performance concerns nesting With() functions?" To test this and maybe get an answer, I created a Power Apps canvas app to determine the … Continue reading Power Apps: Canvas App | Ranked Choice Voting (RCV)
SharePoint Online: Add Shortcut to OneDrive | Explained
There are essentially two content sync options in SharePoint Online (SPO). Traditional Sync, which is pretty straight-forward, and Add shortcut to OneDrive, which is a bit more confusing for some. Because the shortcut button is stand-alone and it doesn't explicitly say "sync," it does something completely different, right? Figure 1 - SharePoint Online document library … Continue reading SharePoint Online: Add Shortcut to OneDrive | Explained
SharePoint Online: Understanding | Permission Levels
SharePoint Online (SPO) permissions are similar, but a bit different than permissions typically applied to the file share. Partly because SPO is designed to be self-servicing, meaning that it could be managed by end-users, the non-IT people. Historically, the IT group was responsible for configuring all permissions for all business content. Now, the site owner, … Continue reading SharePoint Online: Understanding | Permission Levels
Power Automate: Dynamically Compose HTML Emails
Power Automate can do so much more than send emails, but even so, there are plenty of processes still relying on emails. Some processes depend on emails to report workflow success or failure, others prompt for task approvals, and a few simply provide content queried from a dataset somewhere. Figure 1 - Power Automate cloud … Continue reading Power Automate: Dynamically Compose HTML Emails
Microsoft Lists: Teamwork Management w/ Row-Level Security
Microsoft Planner and Microsoft Project are both great project management solutions. Planner easily groups task items into buckets, visualizing everything for small to mid-sized teams. Project, being a more robust tool, allows subtasks, which are perfect for bigger teams and more nuanced projects. Unfortunately, both can fall short when the client asks for super secure … Continue reading Microsoft Lists: Teamwork Management w/ Row-Level Security
console.log('Charles'); 