Flow resource not found error

(0) Share

Report

Posted on by sujan Microsoft Employee

Hi,

I am working on PowerApps application to import user uploaded excel file data into a SQL table

As a first step I uploaded the excel file to SharePoint library
next step is to read file content from sharepoint and import to SQL table

The challenges is excel file what I receive from external source to use in my application doesn't have any tables defined, I could not find a way to directly read excel file rows wihout tables in flow.

Please guide on how can I read excel file rows in flow where tables are not defined in excel. Is there any other approach to implement my feature i.e. importing the data of uploaded excel file to SQL table with PowerApps and Flow.

Thanks,

Sujanakar Reddy

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @sujan I'm sure you can need the same post as I recomend to other user

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

As you can see you can read averything without tables.

First you can upload the file into sharepoint, then read it with the poast I recomend you an then use it to send the data to sql with insert row.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @sujan ,

Have you take a try with @ChristianAbata 's suggestion to use Microsoft Graph, I haven't used that currently.

If you want to save the row data in the excel file without table, I'm afraid that there is no any function in Microsoft flow could achieve the requirement, as you said, Microsoft flow couldn't get rows data from excel table, and I suggest that you should create table to the file.

Best regards,

Alice

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

Was this reply helpful? Yes No