How to use Flow to update a single Excel cell when a task is completed in Planner

[whitegerbera]

I am using a Microsoft Form to input data into an Excel spreadsheet as well as creating a task in Planner.  When that task is complete, I would like that completion date to be added into a specific column (and of course in a specific row, aligned with that task) in my Excel spreadsheet.  I see the Flow option to "update row" in Excel, but cannot figure out how to update a single cell and/or if this is even possible?

[v-yuazh-msft · Accepted solution]

Hi @whitegerbera,

Please make sure you have a excel table saved in your Onedrive for business and with a "Task Title" and a "Completion Date" column as below:

 

And please make sure each Task Title would have a same and unique task title in the planner task.

Then you could create a flow as below:

The expression in the "Completion Date" column as below:

formatDateTime(utcNow(),'yyyy-MM-dd')

When a planner task which's title is "task1" is completed, the flow would run successfully as below:

The excel table would be updated as below:

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

It was telling me the ActionFailed. An action failed. No dependent actions succeeded error msg. After I had gone and marked a task as complete.