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 / Flow status is failed ...
Power Automate
Unanswered

Flow status is failed but looks to have worked

(0) ShareShare
ReportReport
Posted on by 453

Hello,

 

I have a flow that checks when a new planner item has been created. Then I list rows present in a table and insert a condition to check that title of the planner task aligns to a prospect name in the excel sheet. If true, then I update that row with some of the details from the planner task.

 

JoshPullan11_0-1704390357490.png

 

The run looks to have failed, but when I check my excel spreadsheet, the information has been added correctly. I'm wondering what I may have done wrong or have setup wrong for the flow to appear as though it's failed when in actual fact is hasn't.

 

Attached some more screenshots of a 'failed run' in case it's obvious to anyone. The first check looks to confirm the condition is false, which is correct, however when I skip through them, there is a couple that failed with the error message "WorkflowOperationParametersRuntimeMissingValue. The 'inputs.parameters' of workflow operation 'Update_a_row' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id'"

 

Then I continue to skip through and find where the condition is true and matches, therefore updates the row as hoped. 

 

JoshPullan11_1-1704390533179.png

 

JoshPullan11_2-1704390588536.png

 

 

JoshPullan11_3-1704390623553.png

 

Does anyone know why this particular part is failing and but not on any of the other rows? My initial guess was the some of the cells under 'Prospect Name' in excel were blank, and that is what may be referred to as 'id' in the error message, so I put some some dummy data in them however the issue persisted. I also think it may be something to do with the 'key value' but not sure what that is supposed to be?

 

Any tips would be appreciated!

 

Thanks

 

Categories:
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @jap11 

     

    show how you use update a row action to update the row 

     

    may be that helps !

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • Jap11 Profile Picture
    453 on at

    Hi Nived,

     

    I changed the Key Column and Key Value to 'Start Time', which is never blank and always unique, this fixed the flow to say successful. Guessing it was related to the previous dynamic content I was using under key column and key value.

     

    JoshPullan11_0-1704392807411.png

     

     

    Thanks,

    Josh

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 292 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 128

Last 30 days Overall leaderboard