MS Flow using Excel get rows returns Bad Request

[ffox]

Hi, I'm using Flow to get an Excel SS from a SP library. I have a table in the SS entitled Master and I want to get that data and push it to a SP list. I can get the flow to find the SS in the library and I can the file Meta Data, When I use the file name or ID I get

What am I missing?

Thanks in advance

Chris

[v-yamao-msft · Accepted solution]

Hi ffox,

When using Get rows action, we are able to create a connection to Dropbox, OneDrive for Business, OneDrive, etc.

But it seems that there is no available connection for SharePoint library.

So I am afraid that we are not able to enter the File name and Table for the Excel file saved on SharePoint library.

Hope this could be a reference for you.

Best regards,
Mabel Mao

[aegt1510]

I dont know if you are aware of, but in the latest deployments, MS Flow team made available the Excel (Business) action library, which includes a function called "List Rows Present in table" or something like that. Thats the action you want to use for reading excel files from a SharePoint document library.