cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheOpeningBat
Helper III
Helper III

Deleting rows in a Apply to each action if record doesn't exist fails with no row found

Hi,

 

I have a flow which is deleting rows one by one from an excel file from a Apply to each action which is another excel file, however if a particular id is not present in the delete a rows excel file then it errors with No row found for id. 

 

How to handle such cases in the delete a row action where that particular id is not present.

1 ACCEPTED SOLUTION

Accepted Solutions
chrissahagun
Resolver II
Resolver II

On the step after Delete a Row, go to its settings menu (“...” at its top right corner), then open “Configure Run After”. You can set this step to run after Delete a Row even if it fails.

 

chrissahagun_0-1615998413521.pngchrissahagun_1-1615998450471.png

 

If you need to branch your logic depending on the status of Delete a Row, then you can get the status code of Delete a row using the body expression

 

chrissahagun_0-1615999915661.png

chrissahagun_1-1616000083502.png

chrissahagun_2-1616000133162.png

 

 

 

View solution in original post

3 REPLIES 3
chrissahagun
Resolver II
Resolver II

On the step after Delete a Row, go to its settings menu (“...” at its top right corner), then open “Configure Run After”. You can set this step to run after Delete a Row even if it fails.

 

chrissahagun_0-1615998413521.pngchrissahagun_1-1615998450471.png

 

If you need to branch your logic depending on the status of Delete a Row, then you can get the status code of Delete a row using the body expression

 

chrissahagun_0-1615999915661.png

chrissahagun_1-1616000083502.png

chrissahagun_2-1616000133162.png

 

 

 

chrissahagun
Resolver II
Resolver II

@TheOpeningBat did it work? Like and/or mark my response if it solves your problem 😉

TheOpeningBat
Helper III
Helper III

Thanks @chrissahagun. Works great.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,687)