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 / When task is completed...
Power Automate
Unanswered

When task is completed - Update a row is updating wrong row

(0) ShareShare
ReportReport
Posted on by 41
Hello,
 
I've posed this before but not had much response.
Hoping someone can help me.
I have an automated cloud flow triggered by a Form that is supposed to:
1. create a task in Planner
2. once that Planner Task is marked 'Complete' then Update a Row on the excel table linked to the From.
 
I initially thought this was working however never tested it with more than 1 task at a time.
I now see that the timestamp is recording for any outstanding tasks, even if I have not flagged them as 'Complete'
 
Assuming the form Id as the unique identifier was the problem, I tried adding Update a Row to include the Task Id on the excel table first thinking this may work better, but I got the same result.
It seems, no matter what unique identifier I use, the flow is looking for non blanks as opposed to using the unique identifier itself to attach the timestamp to. 

Please help! I've been stuck on this for weeks!
In this below example, only task Id #9 has been marked complete in planner.

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,755 Most Valuable Professional on at
    Just to double check, is this one flow or have you shared screenshots of two separate flows?
     
    I see you are using an apply to each in your update row logic. This means it is looping through a list of tasks. Normally I would suggest to use a setup like below (with two actions) in a separate flow.
     
     
     
  • storere Profile Picture
    41 on at
    @Expiscornovus

    I hope you see this, I'm having an awful time trying to figure out how to reply to your response 🤷‍♀️
    I'm afraid I cannot remove the 'Apply to Each' actions because as soon as I select dynamic data from Planner an 'Apply to Each' action automatically appears.
     
  • Expiscornovus Profile Picture
    33,755 Most Valuable Professional on at
     
    In that case try and add the fields as expressions, that should prevent the apply to each from being added.
     
    Task Id
    triggerOutputs()?['body/id']
     
    Completed Date Time
     
    triggerOutputs()?['body/completedDateTime']

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard