Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

Like (1) ShareShare
ReportReport
Posted on 5 Aug 2024 15:37:13 by 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
 
 
  • rixmcx59 Profile Picture
    rixmcx59 158 on 07 Aug 2024 at 23:42:06
    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 Profile Picture
    Nived_Nambiar 16,906 on 07 Aug 2024 at 14:45:32
    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 Profile Picture
    rixmcx59 158 on 06 Aug 2024 at 20:25:38
    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 Profile Picture
    Nived_Nambiar 16,906 on 05 Aug 2024 at 16:55:55
    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!

     

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,769

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,466

Leaderboard
Loading started