Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Get which items failed in my flow


I have a flow that gets data from a table in an excel and then creates items in my SPList. 
At the moment I can only see which items failed if I go to the run history. Is there a way that I can get the flow to tell me which items failed? I would like to return this info to my users, every time they run the flow.Capture.PNG

Super User
Super User

Hi @Ardions 


Yes you need to deal with the error. It's quite simple and I explain it in detail here:


You need to create a parallel branch that takes care of what happens when something goes wrong. You can compile them into an array and send an email in the end or do something else. Depends a little on how you want to warn your users.


Can you please check if and let me know if you have any questions?



If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Hi.. your article was very clear, thank you. I added now the branches, but I still would like to know which rows from the excel failed. Is there a way to get this info?

Helpful resources

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.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,394)