cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sujan
Microsoft
Microsoft

Import Excel data to SQL table

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

3 REPLIES 3
ChristianAbata
Super User II
Super User II

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-creat...

 

You can read everyting



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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
Community Support
Community Support

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-M...

 

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.

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,998)