Blog
Practical articles from KomuraSoft LLC about website development, SEO, Google Ads, Windows development, legacy asset reuse, and bug investigation.
AI search across this site
Search queries are sent to Cloudflare AI Search to generate results. Please do not enter personal information.
-
Replacing an Excel Ledger with a SharePoint List — Sharing, History, and Flow Integration to Put an End to the Broken Ledger
A practical guide to migrating an Excel ledger on a shared folder to a SharePoint list (Microsoft Lists). Covers solving concurrent editing, overwrites and r...
-
Automating Excel and CSV Work with PowerShell — Practical Recipes for Aggregation, Reconciliation, and Report Output
Practical recipes for automating CSV aggregation, reconciliation, and Excel report output with PowerShell. Covers the default encodings of Import-Csv/Export-...
-
Power Automate Error Handling and Retry Design — Preventing 'The Flow Was Working, Then It Just Stopped'
A collection of design patterns for preventing Power Automate flows from silently stopping without anyone noticing. Based on Microsoft Learn's official speci...
-
Where Do Downcoding and Returned Claims Actually Happen? — Taking Apart Receipt Checking Logic Using ORCA's Source Code and Public Documents
Where do downcoding and returned claims actually happen? From ORCA's data check function and its check masters, through the rece-den data check, to the compu...
-
PowerShell Error Handling and Retry Design — From the try/catch Trap to Exit Codes and Retry Best Practices
A practical rundown of PowerShell error handling: the difference between terminating and non-terminating errors, the -ErrorAction Stop pattern for the try/ca...
-
Designing Scheduled Flows in Power Automate — Month-End Processing, Business-Day Checks, and Reminders in Practice
A practical guide to automating recurring processes with Power Automate's Recurrence trigger. Covers the trap of the default time zone being UTC, date expres...
-
PowerShell Execution Policy and Script Signing — A Practical Guide to Graduating From "Papering Over It With Bypass"
PowerShell's execution policy is "a safety feature, not a security boundary." This article covers the differences between policies like RemoteSigned, scope p...
-
Automating Data Entry Into Legacy Core Systems With Power Automate for Desktop — Replacing Manual Entry From Excel and Paper With UI Automation
A practical guide to replacing manual data entry into old core systems that have no API, using UI automation in Power Automate for desktop (PAD). Covers what...
-
Automating Purchase-Order and Invoice PDFs That Arrive by Email With Power Automate — Designing Storage, Routing, Notification, and Extraction
A practical guide to automating the storage, routing, and notification of purchase-order and invoice PDFs that arrive by email with Power Automate, covering ...
-
Building an Approval Workflow in Power Automate — Digitizing Paper and Email-Based Approval Requests
A practical guide to digitizing paper approval forms and email-attached Excel requests with Power Automate: the types of approval actions, choosing among For...