add new planner card to excel sheet if id of card not exist in the sheet

[drweby2]

i create a sheet with planner tasks and i wanna to add a new row in this sheet if a new card (not exist in excel sheet )is created

here is my flow but it not working it add 5 rows for each card in the plan

[jwhite · Accepted solution]

Hi @drweby2,

My suggestion would be that you use a filter equating the ID of the task and the ID in the table on your list rows and then check to see if that list has any items. If it does, do nothing and if it doesn't add the item:

Similar your flow I first get a list of tasks, but then in the apply to each for this list I filter the List rows with the ID Column in excel being equal to the ID of the task:

I then have a condition to check to see if that filtered list has any items in it. If it does, that means that the task ID already exists so I do nothing. If it is empty it doesn't exist, so I create the row with the task.

The condition that I am checking is the length of the array created by the list rows present in a table with the expression:

length(body('List_rows_present_in_a_table')?['value'])

Let me know if that helps!

Full flow in spoiler:

Spoiler

[drweby2]

Thx alot it work just fine 

i wanna also to add if task id exist but the task title ,due date , start date and assigned to user are not the same add a row in the table 

[jwhite]

Hi @drweby2,

In this case you can add another condition in the "If task already exists" branch of our first condition (the false branch, when our filtered list isn't empty).

This condition just checks if each property is the same. As we are using an AND property on the condition, if they are all the same then it will do nothing. If any of them don't match it we then just use the add row to excel table as before:

You can add any fields which have to match as an additional row to the condition.

Let me know if this helps!