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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / No table was found wit...
Power Automate
Unanswered

No table was found with the name 'Table1'.

(1) ShareShare
ReportReport
Posted on by 920 Super User 2024 Season 1

Hi,

I am unable to find the table.

I have an excel file being created in sharepoint (already in table format) in sheet "Data".

wonka1234_0-1698278053623.png

getting error here - 

wonka1234_1-1698278118147.png

 

 

error log - 

No table was found with the name 'Table1'.

wonka1234_2-1698278166729.png

 

Categories:
I have the same question (0)
  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at

    If you open the file in Excel, you can confirm there is indeed a table with the name Table1?

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    @WillPage  Yes, when I open it in excel from sharepoint i see this - 

    wonka1234_0-1698278416515.png

     

  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at

    How long is your delay action? Try to increase to two minutes.

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    @WillPage delayed 6 minutes between my get tables and my list rows present, and still failing 😞

  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at

    That's so strange. What does the raw output of the get tables action look like?

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    @WillPage  very strange - 

     

    wonka1234_0-1698279760653.png

     

  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at

    Well it's definitely there. Try using its id in the input to List rows, instead of the name

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    @WillPage  still not working =[ .. is there another way to get the table name maybe?

  • WillPage Profile Picture
    2,307 Super User 2025 Season 2 on at

    I don't think there is. As a test, try to run that action with Table1 hard coded into the List rows action, instead of using the dynamic content.

  • NicholasNg Profile Picture
    53 on at

    The ID should work. items('Apply_to_each_2')?['id'] or something like that.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard