Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Flow fails with Get Row from Excel function

(0) ShareShare
ReportReport
Posted on by 13

 Hello,

I have made a flow which runs when a form is submitted. The flow is used to update tables in Excel online and gives status updates in these different tables.

All the submittes are loaded in the first table.
Then, the key value which is given in the form is used to get a row in excel. These two do match, since the error only appears in the get row action linked to the first table, and not in any other get row action linked to other tables (using the same key value).

This is the error:

{
  "status"404,
  "message""No row was found with Id '666666'.\r\nclientRequestId: 926800e8-1f75-41bf-adc7-dd1ded52f9b7",
  "source""excelonline-we.azconn-we.p.azurewebsites.net"
}

Flow error.jpg

It is strange, because it runs smoothly for 99% of the time. However, I want it to run 100% succesfull.

Also, if I retry the flow, it does succeed

  • he184468 Profile Picture
    he184468 3 on at
    Re: Flow fails with Get Row from Excel function

    Same problem!

  • PaolaArce Profile Picture
    PaolaArce 3 on at
    Re: Flow fails with Get Row from Excel function

    Hi,

     

    I have the same problem, the flow works fine at random times and I get the error: No row was found with Id.

     

    Any idea how to solve this?

     

    Thanks

  • Verified answer
    DanielM Profile Picture
    DanielM 13 on at
    Re: Flow fails with Get Row from Excel function

    Thanks for your response

     

    In the meantime I did remove all the submits in Excel, so '666666' isn't there anymore. The error is still the same.

     

    A part of my flow looks like this:

    Flow.jpg

     

    The first three actions do work correctly, however, the 'Een rij ophalen'/get row gives the error.

    Get row.jpg

    So, the key column is the following in excel:

    Table.jpg

    The key value filled in in the Form does match with a value in this table. For example, 1234 is filled in in Forms, 1234 appears in this table (connection between excel and forms). 20 seconds later (due to a delay), flow searches for the key value, which has just been added in table 1 (_56F9DC etc...). Sometimes (1 out of 10 maybe) it fails, but the numbers do match: 1234 is in the table and filled in in the form, but flow cannot find it in the table. It gives the error displayed in my first message. 

     

    I tried a work-around. The 'Do until' is a sollution which I tried, it does work. But I am not sure if it is coincidence it did succeed or if it is a propper sollution for the error. I put the 'Een rij ophalen' in the do until. Looks like this:

    Flow sol.jpg

  • v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Flow fails with Get Row from Excel function

    Hi @DanielM,

     

    Does the issue would occasionally has problems?

    Could you please share a screenshot of the Condifiguration of your flow?

    The error message told that the row will id '666666' was not found, have you check if the search row id is '666666'?

     

    Please share more details so we would try to provide a proper workaround for you.

     

    Best regards,

    Alice

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics