Read excel table from outlook365 attachment

[tlebovic-prg]

I have an Excel file with data saved as a table in an email. I'm able to extract the attachment and save it to an AWS S3 bucket but I would like to convert it to a csv file before saving. I've read a few posts on working with Excel files in Flow but I can't get the steps to extract the data table and parse the lines into a csv file.

Is this posssible to do in Flow without saving the file to OneDrive or Sharepoint?

Thanks

Tom

[v-yamao-msft]

Hi @tlebovic-prg ,

Do you want to save an Excel file from the email attachment to AWS S2 Bucket as a CSV file?

I don’t have AWS S3 bucket to test this issue. Please check if the following flow configuration will be a reference for you:

Best regards,

Mabel

[tlebovic-prg]

Hi Mabel,

Your flow is more or less the same as I currently have but instead of using the OneDrive Create File action I'm using the FTP Create File action. I do get the file with a .csv extension in my S3 bucket but it's still an Excel file - nothing opened it and did a 'Save As' .  The options I see for the Convert File action are only to PDF, not csv, so I'm still stuck.

Thanks

Tom

[v-yamao-msft]

Hi @tlebovic-prg ,

Thanks for updating.

Convert file action is currently used to convert a file to PDF, you could submit a request on Flow Ideas Forum for supporting more file types at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Mabel

[tlebovic-prg]

Is requesting a new file converter all that I can do now?

Is there no way to read an Excel file on the fly and convert it to csv in Flow? 

[v-yamao-msft]

Hi @tlebovic-prg ,

You could submit the request so that the feature will be available in the future.

Besides the way I suggested previously, I haven’t found other ways to convert an Excel file to CSV on the fly using Flow.

I will be trying to do more research on this issue.

Best regards,

Mabel