Update a row when a task is completed

(0) Share

Report

Posted on by storere

Hello,

I've discovered a problem with my flow and hoping someone can help.

I have a form that triggers the creation of a planner task. Each new task is named its form ID# (task 1, task 2, etc...)

Once that planner task status is changed to 'Complete' the timestamp is recorded on the central excel file using the Update a Row action.

When testing this appeared to be working fine. But recently I noticed that completion timestamps were being recorded for tasks that were still showing 'In Progress' on the planner board.

I've determined that a timestamp is being recorded anytime a task is completed and not necessarily being recorded against the specific task ID that was completed.

Here is my flow as it appears now.

Is anyone able to explain how to link the When a Task is Completed action with the specific task being completed using the ID # on the central excel file?

Categories:

Building flows

All responses (2)

Answers (0)

Sort by

Suggested answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Please create an automated cloud flow with the trigger 'When a task is completed'.

This operation will initiate when a task is marked as complete.

Once the specific item is trigged, add the action to update the corresponding row.

Hope this helps.

This operation triggers when a task is completed.
storere 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SpongYe

This is what I have done.

Apologies if by renaming the steps in my flow I've made this unclear.

However, I do have:

1. When a task is completed

2. Update a row

What is happening however, is anytime a task is completed on the Planner board a timestamp is being recorded for all outstanding tasks and not the time stamp against the correct, specific task.

Here is what I mean:
I ran a test by submitting 2 forms that have created 2 planner tasks (Task 1 and Task 2).
On the Planner board I have flagged Task 2 as complete and left Task 1 outstanding.
However, the central excel file is recording the same completion timestamp for both even though one remains incomplete, as you can see in the images below.