Delete Duplicate Planner Task

(1) Share

Report

Posted on by KM-08101538-0

Hi all

I've just dipped my toe into the world of Power Automate and I've hit a snag - I'm sure it's really straight forward, but I can't get my head around it.

We use MS Planner to track tasks; staff will sometimes add duplicate tasks accidentally. I'd like a Power Automate flow that will delete a new task that is created if the title of that new task already exists in that plan.

I've gotten myself as far as List Tasks, but that's it....I've been drowning in a sea of Initializing variables and apply to each loops....

Any help would be greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

CU09100806-0 2 on at

Like (0)

Report

Follow below the weblink to get the solution.

https://tomriha.com/how-to-avoid-creation-of-duplicate-planner-task-with-power-automate/

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report
Hi KM-08101538-0,

I have been able to build a flow for that, Here are steps:

1. Trigger would be: When a new task is created

2. List all the tasks

3. Filter the array received by the task title of the newly created task

4. Add a condition: If the length of the filtered array is more than 1, it means the newly created task is a duplicte

5. Delete the task if the condition is true.

Here's how the flow looks:

Filter Array Action:

Condition expression:

length(body('Filter_array'))

Here's how it works:
Add a duplicate task

Gets removed automatically:

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
KM-08101538-0 4 on at

Like (0)

Report

@Nandit

That's so helpful - thank you.

Unfortunately that solution only works for me when I'm adding tasks to the planner manually.

I obviously forgot to give you some essential info to allow you to help properly; so sorry about that!

I have a flow that creates tasks from an excel spreadsheet based on selected rows which is working well.

I started off in a vain attempt to set this flow to not add any duplicates (which is why i've added the List tasks step). But the problem is, the tasks are detailed along the columns, not in one row, like so:

So I struggled with the expression for the filter array to pull in the multiple Associated Task Columns (there are 5 in total).

If you had any wisdom on this at all, I'd be very grateful. If not, no problem at all - your solution is really helpful and I can cascade that to others in my team.

Was this reply helpful? Yes No