Answered

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

(1) Share

Report

Posted on by rixmcx59

147

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:

Business Process Flows

All responses (4)

Answers (1)

rixmcx59 147 on at

Like (1)

Report

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

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

Nived_Nambiar 15,905 on at

Like (1)

Report

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

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
rixmcx59 147 on at

Like (1)

Report

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

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
Suggested answer

Nived_Nambiar 15,905 on at

Like (2)

Report

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

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!