Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / When task is completed...
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by storere 37
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:
Business Process Flows
  • Expiscornovus Profile Picture
    Expiscornovus 30,706 on at
    When task is completed - Update a row is updating wrong row
     
    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']
  • storere Profile Picture
    storere 37 on at
    When task is completed - Update a row is updating wrong row
    @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
    Expiscornovus 30,706 on at
    When task is completed - Update a row is updating wrong row
    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.
     
     
     

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

News and Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans