I am creating a powerapp which will allow the user to upload an excel data in to a sharepoint list. I tried doing it by following a video https://www.youtube.com/watch?v=45qSaxyS9Rg but it is giving me an error "No table was found with the name 'Table1'." is there anyway to solve this or any other way to upload a an excel sheet to a sharepoint list via PowerApps.


You may need to create a Table in the Excel file:

  1. Select a cell within your data.
  2. Select Home > Format as Table
  3. Choose a style for your table
  4. In the Format as Table dialog box, set your cell range
  5. Mark if your table has headers.
  6. Select OK.

For more information, read here

Also, by default tables in Excel will be named like Table1, Table2. To rename to some other name:

  1. Select the Table by clicking any cell in the table
  2. Select Design from the top menu bar
  3. Table Name property should be visible on the top left corner below the File menu
| improve this answer | |
  • Thank you for your response. :) Yes, I already have the table 'table1' in the excel which is being uploaded but it still giving an error for the table. not sure what am I missing here. – HRY yesterday

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.