Power Automate

Sometimes you may want to get file from Azure Blob to your SharePoint Document library. I will demonstrate a minimal Power Automate flow to achieve that. Before you take action, make sure you have Azure blob account and proper access right. Assume I have one root container, and two sub folders within it. Initialize variables for Blob account and the root container. Add Lists blobs (V2). Add For each. Select an output from previous steps = @outputs('Lists_blobs_(V2)')?['body/value']. ...

Occasionally, while building a Power Automate flow, you’ll need your ParseJSON action to accept an empty value—whether that value is an object ({}), array ([]), or string (""). By default, ParseJSON balks at these inputs. So how do we get around that limitation? In this article, I’ll explore a simple, reliable approach that lets your flow handle empty JSON values gracefully. Create Manually trigger a flow. Add Initialize variable action. Name: theEmpty. ...

Recently, when using Power Automate to connect to PostgreSQL 17 through a local gateway, it prompted me to install Npqsql 4.0.17.0 or earlier. I installed 4.0.17.0 as prompted, but still got the same error. I also replaced all the DLL files under the local gateway program. Nothing helped. The similar cases can be traced several years ago, most of them were for Power BI topic with PostgreSQL. I checked the official website: ...

In many organizations, creating standardized documents populated with up-to-date data can be both time-consuming and error-prone. By leveraging Power Automate to pull information directly from a SharePoint list and inject it into a Word template, you can eliminate manual copy-and-paste steps, ensure consistency, and accelerate your document-generation process. In this article, we’ll walk through how to build a flow that retrieves list items, maps fields to placeholders in a Word template, and outputs a fully formatted document—seamlessly bridging SharePoint data with professional Word reports. ...