Writing planner tasks to excel

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am trying to create an automated flow to write planner tasks into an excel on One-Drive. I have been successful in pulling the data from the planner to excel.

My issue is that the flow is writing the tasks multiple times into excel.

E.g. If I have below 2 tasks in the planner:

Task 1

Task 2

When the excel is populated from the planner, it shows:

Task 1

Task 2

Task 1

Task 2

Below is the screenshot of my flow:

Power Automate.jpg

Can someone please help me figure out the issue with my flow as I have been unable to find the problem?

All responses (1)

Answers (1)

Verified answer

Christopher S on at

Like (0)

Report

Re: Writing planner tasks to excel

Hi @Anonymous

The problem is that you have an Apply to each inside another Apply to each, you just need to retrieve the planner tasks and loop through them (Apply to each) to insert them in the Excel file. If you check on your Flow, the "Get tasks" action is inside an apply to each and this creates the duplicates.

Best Regards
--
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!