The ask, remove the apostrophes from some input text representing a series of project names, then via a Power Automate cloud flow, create a SharePoint Online folder for each project. Now, the maker already has an action to replace the slashes, which are illegal folder characters: replace( variables('fldrName'), '/', '-' ) But apostrophes are allowed … Continue reading Expressions: Power Automate | Cloud Flow – Remove Apostrophe
Power Platform
SharePoint Online | Column Links to Power Apps: JSON for Prod + NonProd
The ask, suggest improvements to an earlier JSON snippet. A Power Platform maker wanted to easily navigate SharePoint Online (SPO) users to their Power Apps solution, so they opted to create a dynamic link using JSON list column formatting. The result, a clickable icon with the HREF path built using an array and the SPO … Continue reading SharePoint Online | Column Links to Power Apps: JSON for Prod + NonProd
Solution Rebuild: Part #1 | Database – Access to Dataverse (Extracting + Transforming)
The ask, rebuild a legacy VB.NET desktop application as a Power Platform solution. The app was written maybe 17 years ago, hasn't been updated, and is a media tracker app, like a personal IMDb. Because it was a personal solution, not an enterprise solution, its data was stored in a Microsoft Access database, so this … Continue reading Solution Rebuild: Part #1 | Database – Access to Dataverse (Extracting + Transforming)
Power Automate + SharePoint Online: Get Items | Lookup Column Threshold Error
The ask, correct a failing Power Automate cloud flow. For months, this flow ran daily, without issue, querying a growing SharePoint Online list, but now, the Get Items action is failing and throwing an error: "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold." Figure 1 … Continue reading Power Automate + SharePoint Online: Get Items | Lookup Column Threshold Error
Power Apps: Canvas Apps | Model-View-ViewModel (MVVM)
The ask this time, pitch Power Apps as a low-code consideration for a few pro-code initiatives stuck in the perpetual, project backlog. Although sentiments are changing, there are still pro-dev teams skeptical of the Power Platform. A common concern, driven by much of the community skepticism, is the idea that low-code is limiting and restrictive, … Continue reading Power Apps: Canvas Apps | Model-View-ViewModel (MVVM)
Power Platform: Canvas App + Cloud Flow | SPO List Config.
The ask, propose an alternative configuration option for a Power Platform solution. The maker created a Power Apps canvas app and a Power Automate cloud flow. When items are submitted, others are prompted via email, sent by the cloud flow, to open the canvas app and complete an action. Following best practice, the maker created … Continue reading Power Platform: Canvas App + Cloud Flow | SPO List Config.
Power Platform: SPO Data Sources + Error Emails
The ask, rethink error email recipients of a Power Platform solution. The original maker needs to transfer ongoing support to the help desk and presently, if there's an issue, the cloud flows are designed to email the maker directly. Fortunately, the solution's data source is a series of SharePoint Online (SPO) lists, so there's at … Continue reading Power Platform: SPO Data Sources + Error Emails
Power Automate: Cloud Flows | Terminate Unnecessary Runs
The ask, address a Power Automate cloud flow that needlessly continues to run even when there's no data to process. This particular flow is an Automated cloud flow, and it runs daily, emailing a dynamic list of people a digest report of SharePoint Online list items created the day prior. The flow is triggered, then … Continue reading Power Automate: Cloud Flows | Terminate Unnecessary Runs
Power Automate: Cloud Flow + Better Readability (Scope Controls)
The ask, suggest some structural changes for a few Power Automate cloud flows to improve readability. The flow makers are already adding comments and notes to their controls, but their flows still come across as unstructured. The proposed solution, add and nest flow actions into Scope controls: Figure 1 - Power Automate cloud flow with … Continue reading Power Automate: Cloud Flow + Better Readability (Scope Controls)
Power Automate: Cloud Flow | Filter Datasets Better
The ask, improve a long running cloud flow's performance. It has a Get files (properties only) action querying 2,000 recent items which are filtered using a Condition block. Because the library already has 100K+ items, OData filters can be hit or miss, so the maker is iterating each returned item, causing the flow loop to … Continue reading Power Automate: Cloud Flow | Filter Datasets Better
Power Automate: Cloud Flows | Is the Array Empty?
The ask, suggest some alternative Power Automate logic for a group of non-dev cloud flow makers. Arrays and functions are new concepts to them, but they understand variables. So, instead of using the length() function to determine whether or not an array is empty, they would like some "more intuitive" logic for their Condition blocks: … Continue reading Power Automate: Cloud Flows | Is the Array Empty?
Power Automate: Cloud Flows + Complex Conditional Logic
The ask, see if there is a better way to conditionally update a Salesforce record whenever there is a value mismatch between it and SharePoint Online (SPO), the source system. There is already a Condition block with a nested Update record action, but can the condition logic be improved? Figure 1 - Power Automate cloud … Continue reading Power Automate: Cloud Flows + Complex Conditional Logic
Power Automate: SharePoint Online | Check If Document Set Exists [ v3 ]
The ask, find another, another way to determine whether a document set exists or not. Still using the Deal ID value as the unique identifier, instead of adding the Get files (properties only) action [ option #2 ], use the Send an HTTP request to SharePoint action. This particular HTTP request action takes advantage of … Continue reading Power Automate: SharePoint Online | Check If Document Set Exists [ v3 ]
Power Automate: Do While Loop | Calculate Binary Of
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
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 ]
console.log('Charles'); 