You’re offline. This is a read only version of the page.
Announcements
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:
Can someone please help me figure out the issue with my flow as I have been unable to find the problem?
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!
Share
Report
All responses (
Answers (
522
