← All Playbooks • Data & String Utilities • 6 min read

How to Run RegEx & Parse Semicolon/Comma CSV Files in Power Automate (Zero Office Scripts)

Power Automate Cloud Flows still lack native Regular Expressions and RFC-4180 CSV-to-JSON parsing. Learn how to extract invoice IDs, IBANs, and parse European semicolon (;) CSVs in 18ms using Zetaleap Power Toolkit.

⚠️ Common Power Automate Bottleneck

Splitting CSV files with split(outputs(), decodeUriComponent("%0D%0A")) breaks whenever cells contain quoted commas, newlines, or European semicolons (;), and Power Automate has no regex() WDL function.

✅ Zetaleap Edge Architecture

Zetaleap Power Toolkit exposes POST /api/pp/regex and POST /api/pp/csv-to-json as native Swagger 2.0 actions returning typed rows[], firstMatch, and namedGroups[] directly as Dynamic Content.

1

Test Your Pattern or CSV in the Live Power Toolkit Studio

Open https://zetaleap.com/power-toolkit to test your Regular Expression or paste a sample SAP/Excel CSV export and inspect the exact Dynamic Content JSON output.

2

Import Zetaleap Power Toolkit (pp-toolkit.swagger.json) or Call via HTTP

Import the pp-toolkit Swagger 2.0 Custom Connector or add a single POST action targeting /api/pp/csv-to-json or /api/pp/regex with your Bearer zl_... token.

Power Automate POST /api/pp/csv-to-json Payload 
{
  "delimiter": "auto",
  "normalizeHeaders": true,
  "autoType": true,
  "csv": "Vendor;InvoiceNo;AmountEUR\n\"Contoso GmbH\";INV-9041;14850.50"
}
3

Loop Over rows[] Directly in Dataverse or SharePoint

Pass the returned rows[] array directly into an Apply to each loop to create or upsert Dataverse / SharePoint items in milliseconds without slow string splitting.