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.

Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...

Tech expert ThioJoe demonstrates how Python now works inside Excel with a live example.