Unanswered

Import Excel data to SQL table

(0) Share

Report

Posted on by sujan Microsoft Employee

Hi,

I am working on an PowerApps applicaiton, my requirement is app should have feature to read excel file uploaded by user and insert the data into SQL table.

As a first step I am uploading excel file to sharepoint and in next step want to read file content and insert in SQL table.

The challenge is excel file I receive from external source doesn't have any tables defined. I could not find any way to directly get rows from excel without reading table.

Please suggest how can I read rows in excel where tables are not defined and insert into SQL table. Also suggest if there is any other approach to achieve my goal.

Thanks,

Sujanakar Reddy

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

hi @sujan maeby this post is going to help you.

https://sharepains.com/2018/10/17/microsoft-flow-read-large-excel-files-within-seconds-without-creating-tables-using-microsoft-graph/

You can read everyting
sujan Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response Christian.

I referred to the post, can you help me understanding what does 'Tenant ID', 'Client Id' and 'Secret' refers to.

Thanks,
Sujanakar Reddy
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sujan,

Maybe you could have a try to import the Excel data by using MS Graph, then transform it the output array and format it.

There is a similar post you could refer to, this user gave an idea about it, hope it could help you:

https://powerusers.microsoft.com/t5/Building-Flows/Nested-Array-after-reading-a-XLS-worksheet-with-MS-Graph/m-p/491975

And you could refer to this document about working Excel file with MS Graph:

https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0

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.