Answered

Delete a Planner task from Excel when that task is deleted from Planner

(1) Share

Report

Posted on by rixmcx59

158

Hello all, I have a flow that adds and updates tasks in Excel based on a Planner plan, the flow works fine until a user deletes a task in Planner, not a completed task but a task that should not have been created in the first place.

My question is, how to use flow to delete a task that exists in Excel but not in Planner, I have found dozens of posts on how to Add/Update Excel from Planner using flow but nothing on deleting. I can get the row count from List Tasks and List rows present in a table which tells me when Excel has more rows but I cannot figure out how to compare the two lists if ID's.

When I use a Select action and Join action to get the List of ID's to compare, then a filter array it's not returning the right result.

Thanks for any help

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

I assume that your excel records have task id of each task as a column. In that case, First List all tasks , then loop through each row in excel table, use filter array to filter the tasks list with the id equal to id of each task as a record in excel, if output of the filter array is empty, then delete that row using task id as key column.

Take this flow as reference:-

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
rixmcx59 158 on at

Like (1)

Report

Thank you for the response, looks great, one question, do I add this as a parallel branch to my current workflow or use a condition like "If Count of ExcelID > CountPlannerID" then do the above steps.

Thanks

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

well, I am not sure how your current flow looks like- but the step which i have mentioned can be added sequentially as well, like after /delete add this section to check whether to delete tasks from planner or not

Was this reply helpful? Yes No
rixmcx59 158 on at

Like (1)

Report

Thanks so much for the help, here is the flow working with all the actions rolled up in a scope for error handling.

Was this reply helpful? Yes No