web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / List rows from excel t...
Power Automate
Unanswered

List rows from excel table - bad gateway 502

(0) ShareShare
ReportReport
Posted on by 2

Hello,

 

I am trying to read excel file (.xlsx) from sharepoint which contains data connections, objects.

While doing an action - List rows present in a file, it does not populate table name created in excel and hence I cannot perform the action.

I would also want to update the excel file in sharepoint which contains data connections, objects.

Is there a way to achieve the same?

If no, can we achieve this using custom connectors or API's for both read and write to excel action.

 

Error:

Status: 502

Message: This workbook cannot be edited because it contains following features...

 

TIA!

Categories:
  • jinivthakkar Profile Picture
    4,187 on at

    @swapnilahirrao open your excel,  top menu - Table design and see table name. If you can see table name and your contents in the table then your excel is correct and the connector should populate the table name.

     

    Else select your table and click on Home->Format as table->Save and close the excel, upload in your location and try again.

     

    First the table has to be populated then we can see the other requirement.

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

  • swapnilahirrao Profile Picture
    2 on at

    @jinivthakkar thanks for your response.

    As you mentioned, my excel sheet has a table and it shows up in table design also, but excel consists of data connections and objects.

    Hence, it seems to give bad gateway error.

     

    I am looking to perform read/write operations to support sharepoint excel files which consists of excel features like data connections, objects.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 389

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard