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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Failed to Get Row
Power Automate
Answered

Excel Failed to Get Row

(0) ShareShare
ReportReport
Posted on by 12

Hi,

 

I have a 4 parrallel flows set up that when I activate it manually it will look in 4 different sheets and see if there is new data or updated data.

 

When I update data in 1 sheet, that flow will be succeful if I activate the flow and the 3 other sheets will fail.

However, that is exactly what I want. How do I have the flow accept that it's a good thing and stop giving me false positives and failed notifications.

Categories:
I have the same question (0)
  • jwhite Profile Picture
    191 on at

    Hi @Ectra ,

    Would you mind sharing your flows? I'm having a hard time seeing why you would ever want your flow to fail, I believe it could more elegantly be handled by a condition or filter checking if your criteria has been met and if not simply doing nothing or returning a notification to inform of that outcome.

  • Ectra Profile Picture
    12 on at

    https://imgur.com/aCdpj3V

     

    Basically, there are two sheets.

    If I add something in 1 sheet it will look in the first column for the word "new". 

    When it finds the word "new" it will make an event in the calendar with the details that I have in the excel file.

     

    However, I didn't add something in the second sheet, thus it cannot find "New" in that sheet. Thus it will fail.
    That is fine for me, because I don't want it to do anything on that sheet because I didnt make any changes.

  • Verified answer
    jwhite Profile Picture
    191 on at

    Hi @Ectra,

    Instead of getting a row with the key value of NEW or change I would reccomend that instead you use the "List rows present in a table" and filter it by rows with values in the status column equal to the appropriate status as below:

     

    I set up a flow with a similar structure to yours but with filters on the list rows rather than a get rows:

    FilterExcelFilters.png

    as you can see I added a fitler query to each of Status eq 'NEW' or Status eq 'Change' to make sure that we are only getting rows we are interested in.

    I then use an Apply to each to go through the rows we have returned and do any appropriate actions for a new or changed record. If there aren't any records which have NEW or change in the status column the list will be empty so nothing will happen:

    FilterExcelApply.png

    It's important to note here that because you want to update the row with the event ID you will still need a unique identifier column for the key column/value. I added a column which just increments +1 to the previous entry, but any unique value will do. I added a similar apply to each for the "Change" list rows as well.

    With this setup the flows will not give you failed notifications when there isn't a row with the value of new, but will still only do any actions if there are rows with a status of new (or change).

     

    Let me know if this helps or if it isn't suitable for you!

     

    Full flow in spoiler:

    Spoiler (Highlight to read)
    FilterExcelFullFlow.png

     

  • Ectra Profile Picture
    12 on at

    Thanks I'll give this a try later.

  • Ectra Profile Picture
    12 on at

    Thank you very much! I implemented this method and the flow works great now!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard