Flow resource not found error

[sujan]

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

[ChristianAbata]

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

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.

[v-alzhan-msft · Accepted solution]

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.