Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Extracting data from a failed flow

(0) ShareShare
ReportReport
Posted on by 20

Hi, 

 

I have a flow that allows a user to save multiple images into sharepoint. Out of the many flows a few had failed with the following error:

 

Unable to process template language expressions in action 'FileContent' inputs at line '1' and column '12834': 'The template language function 'dataUriToBinary' expects its parameter to be formatted as a valid data URI. The provided value '' was not formatted correctly. Please see https://aka.ms/logicexpressions#dataUriToBinary for usage details.'.

 

It seems like 4 items failed out of 35 from the failed flow but I can still access the data which is important for the successful items. 

 

Does anyone know an easy way to extract data from an 'apply to each' loop within flow. I'm hoping to savage as much information as I can, at the moment its just clicking through each individual item. I have about 200+ items to go through so any suggestion would be much appreciated.

 

Thanks!

 

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at
    Re: Extracting data from a failed flow

    Hi @Livi_1 ,

     

    You can usually click on "Next Failed" with the apply to each to get to the next item that has failed.

     

    DamoBird365_0-1613547613794.png

     

    You could also try grabbing the error at each apply to each using the function result() and potentially save it to an array for you to review seperately.  Pieter Veenstra has a good artcle here

     

    @RezaDorrani has also just done an awesome video on error handling - see here

     

    Please let me know if I have solved your problem, don't forget to like and mark as solved if this works for you.

    Cheers,
    Damien


    P.S. take a look at my new blog damobird365.birdhoose.co.uk

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,635 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow