Answered

Power Automate does not recognize the table in my Excel file

(0) Share

Report

Posted on by ED-09011744-0

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.

Categories:

Building flows

Forms.jpg

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

ED-09011744-0 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No