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

Community site session details

Session Id : If8SkRsojbV82LT1pd8lPX
Power Automate - Using Flows
Unanswered

Flow Fails with error: Action 'List_rows_present_in_a_table'

Like (2) ShareShare
ReportReport
Posted on 10 Apr 2025 12:52:10 by 2
I have multiple flows setup to copy a Table from an Excel Spreadsheet to a Sharepoint list.
 
The Spreadsheet is the same and is updated daily and the flow is used to either copy new data or overwrite existing data.
 
These flows work for a while sometimes weeks / sometimes months but then all of a sudden I get the following error:
 
Action 'List_rows_present_in_a_table' failed: Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.
 
 
If I go to edit the flow I get this error message:
 
Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.'.\r\nclientRequestId: e05d597c-ffab-4cc5-9c1f-87d161923bcb", "error": { "message": "Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.'." }, "source": "excelonline-we.azconn-we-003.p.azurewebsites.net" }
 
I have to repoint the parameter at the same file and select the same table again for it to work.
 
Has anyone else come across this and found a fix?
 
Thanks
 
I have the same question (0)
  • RS-08051429-0 Profile Picture
    4 on 30 Jun 2025 at 14:08:58
    Flow Fails with error: Action 'List_rows_present_in_a_table'
    Hi, we're experiencing the same issue with two Power Automate flows, and as you mentioned, it only happens occasionally. Did you find a solution?
  • AD-10041242-0 Profile Picture
    2 on 11 Apr 2025 at 09:16:16
    Flow Fails with error: Action 'List_rows_present_in_a_table'
    Update, when I relink the spreadsheet the table stays the same but the file changes:
     
    Original:
     
          "file": "01UDFABJT7YLT3FDW3NBEJECJT75AM7ADE",
          "table": "{B5805672-F6BD-4A80-B5DA-C74E87DC0674}"
     
    Re-Linked version:
     
          "file": "01UDFABJTCQZ2TOK45VFA3UWBQWARHARJM",
          "table": "{B5805672-F6BD-4A80-B5DA-C74E87DC0674}"
  • ronaldwalcott Profile Picture
    3,825 Super User 2025 Season 2 on 10 Apr 2025 at 22:59:55
    Flow Fails with error: Action 'List_rows_present_in_a_table'
    This could be caused by a token expiration issue. The connections are maintained using tokens which expire and are supposed to refresh automatically but could sometimes fail. When you repoint the parameter it recreates the connection with a new token.
  • grantjenkins Profile Picture
    11,059 Moderator on 10 Apr 2025 at 14:50:02
    Flow Fails with error: Action 'List_rows_present_in_a_table'
    I can't recall seeing this issue before. A workaround "AKA. hack" might be to retrieve the tables in the Excel file, then get the first table returned (assuming your Excel file has only one Table, or it will always be the first Table).
     
    The expression to get the first table is below:
     
    first(outputs('Get_tables')?['body/value'])?['name']
     
     
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 954 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 650 Moderator

#3
trice602 Profile Picture

trice602 327 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow