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 / Add a row and update e...
Power Automate
Unanswered

Add a row and update excel from planner

(0) ShareShare
ReportReport
Posted on by 5

Hi everyone

I would really appreciate it, when you can help me with the following problem:

 

I want to add a row in an excel table when I create a new task in planner. When I run the flow ragain it should not add a new row, when this task already exists in the excel table.

Furthermore when I update a task in planner it should be updated in the excel table as well without adding a new row. 
Another problem is the Checklist. In the picture you can see, that the tasks have always two checklist items. The row in the excel should show me only the checklist item that got choosen.

 

I have to admit that I am a noob at doing stuff like this. I already tried to watch some tutorials in doing this. But the flow I created is very unstable and has a lot of issues. Thank you for your help

Unbenannt2.PNG
Unbenannt.PNG
Categories:
I have the same question (0)
  • takolota1 Profile Picture
    4,980 Moderator on at

    @VolkanEmre 

     

    If your use-case is leading you to try to sync all of your Planner instance to a spreadsheet or list, then I highly recommend just using the board / kanban-like view in a SharePoint list. It will save a lot of headache.

     

    Here is a template that automatically sets up an Agile project management kanban SP list for you…

    https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Project-Tracker-SharePoint-and-Teams/td-p/1788102

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 976

#2
Valantis Profile Picture

Valantis 863

#3
Haque Profile Picture

Haque 547

Last 30 days Overall leaderboard