Hopefully this is what you're looking for. It will extract the data from the CSV file and give you an array of objects that can be used to update a SharePoint List, etc. I'm not entirely sure what you want to do with the data once you have it.
For this example, I'm using the following CSV file that contains three columns.

See full flow below. I'll go into each of the actions.

When a file is created (properties only) is set to look for files added to a folder called Assorted Files. I haven't put any checks to see if it was a CSV file - assuming only CSV files will be added here.

Get file content uses the Identifier from the trigger.

Filter array extracts out the data and removes the last empty row we get. The expressions used are:
//From
//converts the data to string, splits on new line, and skips the header row (only want the data)
skip(split(base64ToString(body('Get_file_content')['$content']), decodeUriComponent('%0D%0A')), 1)
//Condition
trim(item())

Select uses the output from Filter array and maps out the headers and values using the following expressions. This assumes I know what the headers are and they are always in the same order in the CSV. You would just increase the index for each new header (depending on your CSV).
//Record Number
split(item(), ',')[0]
//Name
split(item(), ',')[1]
//Amount
split(item(), ',')[2]

After running the flow, I would get the following output.
[
{
"Record Number": "1",
"Name": "Bob",
"Amount": "20"
},
{
"Record Number": "2",
"Name": "Jane",
"Amount": "35"
},
{
"Record Number": "3",
"Name": "Joe",
"Amount": "21"
},
{
"Record Number": "4",
"Name": "Bill",
"Amount": "68"
},
{
"Record Number": "5",
"Name": "Andy",
"Amount": "102"
}
]

I'm not sure what you want to do with the data once you have it in this form. If this is all you're after and can move on from here then all good. Otherwise let us know and we can help build out more for you.