cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ffox
Frequent Visitor

MS Flow using Excel get rows returns Bad Request

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

Capture.PNG

What am I missing?

 

Thanks in advance

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

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.

3.PNG

 

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

 

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

View solution in original post

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

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.

3.PNG

 

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,543)