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 / Build Flow to Import t...
Power Automate
Answered

Build Flow to Import to Planner from Excel + Update Excel based on Planner Activity

(0) ShareShare
ReportReport
Posted on by 7

Hi everyone - 

 

Hoping for a bit of direction and help. At the end of the day I'm trying to find a solution that will work for everyone on the team. We have some people who really prefer excel to keep track of their tasks and some (including myself) who prefer planner.

 

I'm very new to flows, but I have a feeling we could come up with some workarounds to satisfy both groups. 

 

Here's what I'm hoping for:

  • Automated flow(s) that either runs real time/ scheduled 2-3x per day or is triggered, M-F
  • Flow to import and update tasks from Excel to Planner and vice versa
  • Incl Field: Plan, Bucket, Title, Assignment, Progress, Priority, Due Date

As an aside, our team members currently work across multiple plans. If it's possible, I'd like to create one spreadsheet off of which this flow would run. 

 

All the above said, I am so hopeful that someone's run into this before and has a flow that they wouldn't mind sharing my way. It would be amazing.

 

Thanks

H

Categories:
I have the same question (0)
  • Verified answer
    ChristianAbata Profile Picture
    8,953 Most Valuable Professional on at

    Hi @HParker 

    Maybe yoy need someting like this.

    create.PNG

    So you can decide when run the flow with a schedule conector, and then get all task in excel to create task in planner.

  • kwertan Profile Picture
    4 on at

    HI- i am also looking to do what the original poster was searching for. I am not understanding how the solution shows how this is automated?

  • MPLekter Profile Picture
    17 on at

    Me neither. It seems like a good start, but where's the finish? 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 600

#2
Valantis Profile Picture

Valantis 453

#3
11manish Profile Picture

11manish 356

Last 30 days Overall leaderboard