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
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
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
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
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?
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
User | Count |
---|---|
67 | |
52 | |
48 | |
30 | |
19 |
User | Count |
---|---|
26 | |
23 | |
23 | |
23 | |
22 |