Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a Run Scripts from SharePoint library action too? Office scripts are similar ...
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.