Unanswered

Email Attachments to a SQL database

(0) Share

Report

Posted on by michie24

Hi,

I have monthly emails with a csv file attachment, and I would like to combine the data (all rows) inside the monthly csv files into a SQL database. Any leads to create an automate flow for it?

I tried googling around but failed to find a solution for it.

Thank you in advanced!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

ArchitectMadhan 1,584 on at

Like (1)

Report

Hi @Michie_24 ,

Step:1 For reading the CSV file content from the email attachment, please follow the steps mentioned in the below link.

https://www.toplineresults.com/2021/02/parse-a-csv-file-from-an-email-using-power-automate/

Step:2 For updating the CSV file content to SQL server table, please follow the steps mentioned in below link.

https://powerusers.microsoft.com/t5/Connecting-To-Data/CSV-gt-Flow-gt-MS-SQL/td-p/68780

Was this reply helpful? Yes No
ArchitectMadhan 1,584 on at

Like (1)

Report

Hi @Michie_24 ,

You are able to follow the approach mentioned in my previous post? If it is helpful for you, please click the button "Accept as Solution" so that people looking for the same solution can find this post easily.

Was this reply helpful? Yes No