I have a Sharepoint List with data in it.

and i created a flow

I first tried to just save it to my one drive, but the folder will not appear. so I am trying to save it to my sharepoint site. but its not saving it as a proper CSV file?

the file type is not .csv? i need a solution for both this and just saving to my onedrive? the flow runs fine but no file shows up on my drive