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 / List rows present in a...
Power Automate
Unanswered

List rows present in a table intermittently fails with table not found

(1) ShareShare
ReportReport
Posted on by 13

Hello,

I am importing some static data from an excel file. The table in the excel file is called "event_shift". Sometimes, reading the values in the table using "List rows present in a table" works with no problems. But randomly, the flow will fail with the error "No table was found with the name '{3084923B-20DA-4EB2-BCF9-FB9DCB0D7EED}'", or sometimes a "resource not found" error. I'm reading from more than one table in the same file, so another table in that file will be read without problems earlier in the flow. The file is static, the table never changes. I have noticed that, between runs that work and runs that don't work, this GUID is the same.

 

Does anyone have any experience with this? Is there a more reliable way to read the values from a table in an excel doc?

Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,315 Super User 2025 Season 2 on at

    Hi @jcy1990 

     

    The only time I have seen this is when people have read from the same file with different tables and its usually the Tables after the initial table.

     

    Its weird its like the connection drops and is temporary broken in between or it thinks its locked by something other than your flow.

     

    Do you have like a time window where it happens more than others? Do you have lots of retries? A high load on the file? Does this file change alot?


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • jcy1990 Profile Picture
    13 on at

    Hi @FLMike,

    The scenario you've described is exactly the scenario I'm in. I have several tables in one file, and I'm trying to read them at different points depending on how my flow executes.

     

    The file almost never changes. It's hard to say what the trends are because this issue is coming up as I test the flow myself, so it's not being triggered at a consistent rate over time. Currently I don't have any retries configured except for the default behavior, and it's not being triggered because the HTTP status associated with the error is a 404. The tables are being referenced by a power app and by my power automate job, just for reads.

     

    I'm looking into implementing retries on error using a do-while with some delay if I can't get it to just work consistently. If you have any ideas for other work arounds though I am desperate to hear them.

  • Verified answer
    Michael E. Gernaey Profile Picture
    53,315 Super User 2025 Season 2 on at

    Hi @jcy1990 

     

    So another user had an issue, and I was explaining to them what you are saying, using error handling and a delay.

     

    Create a Boolean Variable set it to false

    Create a Variable (integer) set it to LoopCounter =  0 

    Create a Variable (integer) set it to MaxRetries  and the number

     

    Use a Do Until loop

    condition =s Wait Until Above Variable is true

     

    Inside

    Create a Scope, call it Try

    Then create 2 under it, in parallel

    Name one Catch, one Success

     

    put your Action in the Try scope

    Set the Catch scope Configure run after, to Failed/Skipped/Timed Out

    set the Success Scope Configure run after, to Success (default)

     

    In your Success set the variable to true and Do until quits

     

    in your Catch

    use Result('Try') to grab the error information

     

    Use the Increment Variable to increase the counter

    immediately have a condition that checks if LoopCounter >= MaxRetries

     

    in Yes, set variable to True and Do until exists

    If not, i dont know if you want to log something or not.. but use the Results('True')

     

    And done


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

  • jcy1990 Profile Picture
    13 on at

    Thanks for the great, detailed response @FLMike. Here's what I went with (in case someone else needs it).

    Screenshot 2024-07-14 at 9.12.01 AM.png

     

    1. (Not pictured) Initialize Http_Retry variable to false. Initialize variables for the values I want to use (Event_Slots and Event_Waitlist_Slots)

    2. Do until Http_Retry is false, with a maximum of 10 loops

    Screenshot 2024-07-14 at 9.13.04 AM.png

    3. Retrieve data (this is the flakey request)

    Screenshot 2024-07-14 at 9.12.23 AM.png

    4. If successful or skipped, set Http_Retry to false

    Screenshot 2024-07-14 at 9.17.58 AM.png

    5. If failed or timed out, Delay 5s and set Http_Retry to true

    Screenshot 2024-07-14 at 9.18.55 AM.png

    Screenshot 2024-07-14 at 9.19.55 AM.png

     

    Since adding retries to all my interactions with the excel file, I have not seen any failed runs.

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 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard