How to change PCF local port number(8181)
You might have noticed that when you tested your PCF component locally, npm always used port number:8181 as default. Is that possible to change a different one ? and How? [start] Initializing... [start] Validating manifest... [start] Validating control... [start] Generating manifest types... ... Starting control harness... [Browsersync] Access URLs: ---------------------------- Local: http://localhost:8181 ---------------------------- [Browsersync] Serving files from: C:\projects\LinearInput\out\controls\LinearInputControl [Browsersync] Watching files... The short answer is Yes if that really bothers you. ...
How to get files from Azure blob to SharePoint via 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']. ...
How to handle empty object for ParseJSON in Power Automate
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. ...
Power Automate: Troubleshooting for connecting to local PostgreSQL (requires Npqsql 4.0.17.0 to be installed)
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: ...
Power Canvas App: Looping marquee text
Ever wanted to add dynamic content to your Power Apps to highlight key information? This article I will explorer an approach for looping marquee text for a text input control. The demonstration use Authoring Version: 3.25061.7,and enabled ‘Modern controls and themes’. Effect first: Prepare the app. 1. Insert controls in a blank screen: One text label control: TextCanvas1 Text= "While Montaigne's philosophy was admired and copied in France, none of his most immediate disciples tried to write essays." ...
Power Automate: SharePoint List to populate Word Template
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. ...
Power Automate: Filter Emails Which Have No Category
In this Article I want to show you how to filter no category email in outlook via Power Automate. In current Outlook 365 connector, there is no option to filter out emails with/without categories. When I tried to build the flow, I thought I could use Get emails (V3). After I tried I realised that there is no info in the body, but it doesn’t have the categories information, and the most important thing is it may consume more API if I use it first. ...
How to use combined filter panel in Power Apps
In this article, I want to explore a way to use combined filter controls and pass the values to dataset. I used Accounts(Sample data)table for the demostration, you can use your own data if you’d like. Control list. Control Refer to Source Data ComBox Business Type Account Toggle Credit Hold Account DropDown(Preview) Relationship Type Account Reset Reset All conrols n/a Table(preview) collection Account The layout will be like this screen shot. ...
The limitations of TRIM() in T‑SQL when cleaning/migrating data
In T-SQL, the TRIM() function only removes spaces (ASCII 32) and cannot remove hidden characters (such as newline characters, carriage returns, tabs, or some emojis). These characters might cause issues during data cleaning (or migration), for example: Data imported may contain carriage return (CHAR(13)) or newline (CHAR(10)). Data copied and pasted may contain tab characters (CHAR(9)). Specially formatted strings may contain invisible Unicode control characters, such as certain emojis. Common hidden characters include: ...