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

Notifications

Announcements

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

Categories:
I have the same question (0)
  • takolota1 Profile Picture
    4,974 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard