Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Excel Get a Row is timing out

(0) ShareShare
ReportReport
Posted on by 5

Good Morning Everyone,

 

I am new to Flow and am doing a pretty standard lookup using Excel Get a row based on a zip code. I have confirmed that in the source file the Zip column contains unique values. When I ran the flow using a test excel file, it ran without issues. Now that I have dropped in the production file, with over 41,000 rows, the flow times out on that step:

FRM_TimeOut.PNG

The flow itself where it gets stuck is:FRM_Flow.PNG

 

Thank you all and let me know if I can provide any further information.

  • Verified answer
    RobElliott Profile Picture
    RobElliott 9,999 on at
    Re: Excel Get a Row is timing out

    When I have done this I have always needed to use the excel action "List Rows in a table" but then also use the Get Row. It works fine if you use both.

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • aquijano Profile Picture
    aquijano 5 on at
    Re: Excel Get a Row is timing out

    As a follow up, I did switch out the Get a Row with an Excel List rows present in a table and it appeared to succeed with that look up. I am just not sure what the purpose is for the Get a Row tool.

     

    Thanks again everyone.

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