Unanswered

Excel get updated new tasks created in planner.

(0) Share

Report

Posted on 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.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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
evargas 22 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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 at

Like (0)

Report
Copy link

Link copied!

@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,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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 at

Like (0)

Report
Copy link

Link copied!

@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