web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automate planner items...
Power Automate
Answered

Automate planner items into excel

(0) ShareShare
ReportReport
Posted on by 453

Hi all,

 

I have a Planner that I would like to automatically pull all the tasks into an excel spreadsheet.

 

Ideally I have a scheduled flow that runs each morning and updates the excel spreadsheet with the latest tasks that have been added into the planner.

 

The purpose of this is so that I can do some reporting in PBI on our planner tasks however I need to get the task data into excel and then have that excel automatically update.

 

Any ideas appreciated!

Thanks!

Categories:
  • Verified answer
    Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @jap11 

     

    I feel instead of scheduled flow, could you try with trigger based approach, add the task details into excel spreadsheet when a task is created in planner?

    This would be simple in design comparing with scheduled flow where you are pulling all tasks to excel file. 

     

    See the flow design required as below:

    Nived_Nambiar_0-1702205079055.png

     

    Hope it helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • Jap11 Profile Picture
    453 on at

    Hi @Nived_Nambiar 

     

    That makes complete sense! I will export all the existing tasks into the excel sheet I plan to use and then use flow to add anything new that is created in planner. 

     

    Thanks for the suggestion!

  • Grace2019 Profile Picture
    8 on at

    Hi @Nived_Nambiar , could you kindly help guide how to update the whole excel spreadsheet from task planner? my goal is not only add the new tasks, but want to capture all the updates in task planner everyday.

     

    I have two steps, first delete rows in the excel, say I have an excel of the previous day's planner tasks. This step is good, testing works.

     

    Grace2019_2-1711566644214.png

     

    Then, I plan to add all the task in that excel. this step runs without error. But the excel is not actual updated with data, its blank.

    Grace2019_1-1711566602347.png

    Do you know how to fix this and add the tasks into the excel?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 271

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard