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.
hi @sujan maeby this post is going to help you.
You can read everyting
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.
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:
And you could refer to this document about working Excel file with MS Graph:
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.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.