Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

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

Posted on 22 Nov 2024 15:13:20 by 35
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.

  • Expiscornovus Profile Picture
    Expiscornovus 30,523 on 23 Nov 2024 at 14:03:25
    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

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,111

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard