cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Questions
Helper I
Helper I

Load data from CSV into SQL server?

Is there a way to take a CSV file and load it into SQL Server?

I want to grab a file in an email attachment and load it into SQL.

The file could also be in a SPO document library.

I'd want to do this as cleanly as possible, do those connectors exist?  I didn't see them last time I looked but maybe I just missed them?

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @Questions,

 

It is possible, you could use Data operation and expression to process the CSV file, or use third-part connector (Such as Encodian) to convert the CSV to an object, then insert these items in the object into SQL via SQL connector.

Solved: Read csv file from email attachment and insert/upd... - Power Platform Community (microsoft....

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

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @Questions,

 

It is possible, you could use Data operation and expression to process the CSV file, or use third-part connector (Such as Encodian) to convert the CSV to an object, then insert these items in the object into SQL via SQL connector.

Solved: Read csv file from email attachment and insert/upd... - Power Platform Community (microsoft....

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

takolota
Super User
Super User

If anyone wants a comma delimited CSV reader / parser using only the standard actions in Power Automate that can also handle larger files, in-data commas, and in-data line-breaks, then try this template flow:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

 

You could also try this batch SQL template to more efficiently enter the values in SQL:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/...

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,580)