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 / Power Automate does no...
Power Automate
Answered

Power Automate does not recognize the table in my Excel file

(0) ShareShare
ReportReport
Posted on by 4
 Hello,
I am trying to create a flow with Forms and an Excel that is published in an enterprise SharePoint, I am doing this because the new update of Forms is to be entering all the time to Excel files to have new rows. 

I created a new Excel file that is published in SharePoint and it has the same columns as the file that is connected to the form, however, Power Automate is not able to recognize the table in my file. 

I have removed the rows from the file and the table is empty, however, I am still getting the same error. 

Please help me.
 
Forms.jpg
Categories:
I have the same question (0)
  • Verified answer
    David_MA Profile Picture
    14,056 Super User 2026 Season 1 on at
    Please add a screen shot of the table in your Excel spreadsheet so we can review the spreadsheet. Mask any sensitive data. Normally this only happens if the spreadsheet does not contain any defined tables. A spreadsheet with rows and columns of data is not necessarily a table.
     
    You can review this reference for creating a table in Excel: Create a table in Excel - Microsoft Support. This is the type of table required by the Excel actions in Power Automate.
  • Suggested answer
    ED-09011744-0 Profile Picture
    4 on at
    Hello David,  
     
    Thank you very much for your answer, I attach an image of the table.
    I got this table by copying and pasting from the Excel file that is connected to the form, the idea is that the new answers are below the existing ones. 
    The table has 9000 rows and 222 columns, of which 65 correspond to columns calculated from the columns that are loaded from the form. 
    I don't know if it is because of the density of the table or because I have copied and pasted the information in a new Excel file, but I don't understand what is happening. 
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 557

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 264 Super User 2026 Season 1

Last 30 days Overall leaderboard