Answered

Delete SQL Row when Task is removed from the Planner list of tasks

(0) Share

Report

Posted on by hadibook

I Created a flow that gets all the Tasks from Microsoft Planner and Add them as rows in a SQL Database. I am trying to Create a flow that tracks if a Task was deleted from the Planner or it deletes the row from the SQL Database as well.

Please help me!

Screenshot 2020-04-07 at 10.25.26.png Screenshot 2020-04-07 at 10.29.06.png

All responses (3)

Answers (1)

JohnAageAnderse 1,986 on at

Like (0)

Report

Re: Delete SQL Row when Task is removed from the Planner list of tasks

@v-alzhan-msft (Alice)

I would suggest to move the action List tasks out of the loop, as it will always get all tasks in the planner, so no need to place it inside the loop.

Can you clarifiy - do you know if using a Filter action is faster than a loop getting all values into an array and then using contains in a condition? (just curious)

Kind regards, John
Verified answer

v-alzhan-msft on at

Like (0)

Report
Re: Delete SQL Row when Task is removed from the Planner list of tasks

Hi @hadibook ,

Please refer to screenshot below to create the flow:

Please make sure there is a column has the same value with the Id of the task, and the column value would be unique, then you could check from each row in the sql table, to see if there is a task in the planner has the same id with the row in the Filter Array action, and if no, delete the row in the sql table.

The length expression in the flow as below:

length(body('Filter_array'))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JohnAageAnderse 1,986 on at

Like (0)

Report
Re: Delete SQL Row when Task is removed from the Planner list of tasks

Hello @hadibook
You are using two loop to process all the Planner tasks and all the SQL table rows, which will take a long time 🙂

Simplify it by first doing this:
After the List tasks action, initialize an array variable
Use an Apply to each loop to add each Planner task id to the array variable (append to array variable).
You now have all the active Planner task ids in the array variable.
Now comes your action to Get SQL tasks.
Keep your Apply to each loop for the SQL tasks.
Replace the inner loop with a condition - Array variable, Contains, Task ID
If yes, do nothing
If no, delete the SQL task
By not using a loop within a loop, you will save a lot of time.
Kind regards, John