cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Excel Failed to Get Row

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III
Resolver III

Re: Excel Failed to Get Row

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
FilterExcelFullFlow.png

 

View solution in original post

5 REPLIES 5
Highlighted
Resolver III
Resolver III

Re: Excel Failed to Get Row

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.

Regular Visitor

Re: Excel Failed to Get Row

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.

Highlighted
Resolver III
Resolver III

Re: Excel Failed to Get Row

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
FilterExcelFullFlow.png

 

View solution in original post

Highlighted
Regular Visitor

Re: Excel Failed to Get Row

Thanks I'll give this a try later.

Highlighted
Regular Visitor

Re: Excel Failed to Get Row

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

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (4,506)