Skip to main content

Notifications

Community site session details

Community site session details

Session Id : XDnr7+DMJK+xUezr03z0tt
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
    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
    17,452 Super User 2025 Season 1 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
    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
    17,452 Super User 2025 Season 1 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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,681 Most Valuable Professional

Leaderboard
Loading started