Hopefully this is what you're after. This assumes that you don't have any commas within the actual values and that you already know the columns in the CSV attached.
For this example, I've go the following CSV file attached to my email.
See full flow below. I'll go into each of the actions.
When a new email arrives gets the email and attachments. I've set it to Include Attachments and Only with Attachments, plus a Subject Filter.
Apply to each iterates over each of the Attachments.
Filter array uses the following expression to extract out each of the rows of data, skips the first row (headers), and removes any empty rows.
//From
skip(
split(
base64ToString(items('Apply_to_each')?['contentBytes']),
decodeUriComponent('%0D%0A')
),
1
)
//Condition
trim(item())
Apply to each row iterates over each of the rows from the Filter array.
Create item uses the following expressions to add a new item to the SharePoint List. Note that I didn't know what you wanted to do with the Title column, so just left it blank in this example.
split(item(), ',')?[0]
split(item(), ',')?[1]
split(item(), ',')?[2]
split(item(), ',')?[3]
split(item(), ',')?[4]
split(item(), ',')?[5]
After running the flow, we would have the following output.
