Quite a few years back I wrote a post about reading CSV files in Power Automate. But that can be done so much better now. An imagine having to deal with commas, you would end up with ugly expressions.

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it easier to refresh and reuse frequently updated data inside a worksheet. The ...