Excel get updated new tasks created in planner.

Like (0) Share

Report

Posted on 19 Aug 2021 18:26:27 by evargas

I currently have 3 flows that populate to separate planner buckets when I run the flow. When there are new items updated in the excel I would like the planner to be updated as well. I can not seem to create a flow that populates only updated items when it runs. Every time I run it with the updated items it will be populate the old items and there will be duplicate of tasks within the bucket in planner.

I have the same question (0)

All responses (6)

Answers (0)

evargas 22 on 20 Aug 2021 at 14:38:03

Like (0)

Report

Re: Excel get updated new tasks created in planner.

@ScottShearer

If I delete the create a task action how will the planner be uploaded. That action locates what bucket in the planner certain tasks will go into.

Was this reply helpful? Yes No
ScottShearer 25,236 Most Valuable Professional on 20 Aug 2021 at 14:33:06

Like (0)

Report

Re: Excel get updated new tasks created in planner.

@evargas

My suggestion was to remove the Create task action and keep the Update task action.

Was this reply helpful? Yes No
evargas 22 on 20 Aug 2021 at 14:25:59

Like (0)

Report

Re: Excel get updated new tasks created in planner.

@ScottShearer

I deleted the Update Task action and ran the flow the duplicates still appear. Is there an option to only update a task from a certain date or a condition that locates the new items on the excel document?

Was this reply helpful? Yes No
ScottShearer 25,236 Most Valuable Professional on 19 Aug 2021 at 19:54:21

Like (0)

Report

Re: Excel get updated new tasks created in planner.

@evargas

It appears as though you are getting duplicates because you have an Update task action and a Create a task action. I suspect that the Create a task action is you issue and that it should be removed.

Was this reply helpful? Yes No
evargas 22 on 19 Aug 2021 at 19:36:19

Like (0)

Report

Re: Excel get updated new tasks created in planner.

Was this reply helpful? Yes No
ScottShearer 25,236 Most Valuable Professional on 19 Aug 2021 at 18:42:55

Like (0)

Report

Re: Excel get updated new tasks created in planner.

@evargas

Please post a screen shot of your Flow - that will be a big help to thos who want to assist.

Was this reply helpful? Yes No