cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Read excel table from outlook365 attachment

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

5 REPLIES 5
Community Support
Community Support

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:

1.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,786)