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.
Learn how Excel IMPORTCSV refreshes linked CSV data, handles locale formats, and switches to IMPORTTEXT for semicolon ...