Building a data pipeline with power automate

Question

Greetings. What I intented to build is when a file (e.g. excel or csv) uploaded to the sharepoint, it can automaticly create a new table for it, and sync the data to the SQL DB. Is it possible?

My ideal pipeline is like this:

1. Excel file uploaded
2. Create a new table with the column header and file name dynamicly
3. Insert the row to the table.

However, power automate do not have a function to extract the column headers, may I ask is there anyways to do it?

Answer 1

Hi @Chi Ming HUNG (Matthew),

Per my research, there is no direct connection between excel table header and flow. Currently we could only create the column manually. Affter create the list and column, you could import data by "List Rows present in a table"

Here is a nice article for reference

https://www.csharp.com/article/automating-excel-data-to-sharepoint-lists-with-power-automate/

Since currently there is no solution forcolumn headers in powerautomate. I sincerely suggest you add your suggestion in SharePoint UserVoice which is a specific platform for us to collect user's request. Your suggestion will help us improve our Products and give users a better experience.

Your understanding is highly appreciated.

Thanks,

Raytheon Xie

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.