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

List Excel Rows Present in a Table - Bad Gateway Error

Hello,

 

I am building a flow to take rows from an Excel file that is attached to an email and create a SharePoint list item using that data.  The step "list rows present in a table" causes a "Bad Gateway" error: "This workbook cannot be edited because it contains the following features:\r\n\r\n• SharePoint lists\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy."  Saving a copy and editing the new copy does not work.

 

According to this post, the error appears to be due to a SharePoint feature not being supported by Excel Online.  (I tried the suggestion in that post of unlinking SharePoint to the file, but it did not help.)  The other suggestion was to open the desktop version; however, for the flow to access the data, I need to save it to the cloud.  I have another flow that is able to list rows in Excel Online without a problem.  Any help would be greatly appreciated.  Thanks!

 

 Capture.PNG

Update: I got the flow to work by using a different Excel file.  The flow works, but the run history shows that it fails.  Here is the error message.  Any ideas about why the flow would work, but show that it fails, and show an error message?  Thanks.

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Thank you, @prasadathalye.

 

I was able to solve the problem by using a different Excel file.  Also, I think the reason the flow showed it was failing when it worked was because aside from the Excel file being saved to SharePoint, there was a graphic in the e-mail signature that was being saved to SharePoint as a png file.  The flow was listing the rows in the Excel file, but because it couldn't list rows in the image file, it showed that it failed.

 

View solution in original post

4 REPLIES 4
PrasadAthalye
Community Champion
Community Champion

Is your excel file on Onedrive OR SharePoint?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

It's in SharePoint. 

Looks like some permission issue. Can you store the file in some other sharepoint site where you have full access and see if it makes any different?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Thank you, @prasadathalye.

 

I was able to solve the problem by using a different Excel file.  Also, I think the reason the flow showed it was failing when it worked was because aside from the Excel file being saved to SharePoint, there was a graphic in the e-mail signature that was being saved to SharePoint as a png file.  The flow was listing the rows in the Excel file, but because it couldn't list rows in the image file, it showed that it failed.

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,003)