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 / Using Power Automate t...
Power Automate
Unanswered

Using Power Automate to update task due dates

(0) ShareShare
ReportReport
Posted on by 24

Hi All,

 

I'm (very) new to power automate, so I apologize if this question is trivial. I'm trying to automatically update my tasks in Teams from an excel table that changes.

 

I have no problem creating the tasks with "manaaly trigger a flow -> List rows present in a table -> apply to each + create a task". However, I want to update the task due date from the excel (about 50 constant tasks, for which the due date changes on a weekly basis). So the task name is constant, but the due date changes.

 

When I try to use the "update task", i cannot select the "Task ID" from the excel table directly, but need to select each task name separately from the drop down list. Any idea why I cannot select the Task ID from the excel?

 

Many thaks!

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,511 Most Valuable Professional on at

    Hi @polywantacracke,

     

    There should be a Add a custom item option available in the dropdown control of the Task Id field which you can use. Can you check if you also have that option?

     

    addcustomvalue.png

     

    In that dialog you can select either a dynamic content field (like a taskid field from an Excel) or use an expression.

     

    taskidselect.png

  • polywantacracke Profile Picture
    24 on at

    Many thanks for your reply. This is what I have been trying to do, but get an error. Any idea why?

     

     

    polywantacracke_0-1636809449868.png

     

  • Expiscornovus Profile Picture
    33,511 Most Valuable Professional on at

    Hi @polywantacracke,

     

    My guess it can't find the id specified in your Excel sheet. Can you make a screenshot of the contents of your Excel and of the task you are trying to update.

     

    Taskid_example.png

     

    Can you also check on the task itself. Under the elipses (...) there should be a copy link to task option. The correct id of the task you want to update should be in the url.

     

    https://tasks.office.com/yourdomain.onmicrosoft.com/Home/Task/YmMX_qRoK0WF_-mOSQ2dOpgAKsxn?Type=TaskLink&Channel=Link&CreatedTime=637724146382880000

     

    copylinktotask.png

  • polywantacracke Profile Picture
    24 on at

    Thanks again for your reply. See screenshot attached. The task ID should be "Machine 003", which I can add using power automate linking to Excel with no problem. However, the "update task" operation does not work for some reason...I see that the Input is correct, but still I get an error.

    polywantacracke_0-1636822017546.png

    is the Task ID not the name ("Machine 003") taken from Excel? Any idea why I can add a task like this but not update in the same manner?

     

    Thanks!!

     

     

  • Expiscornovus Profile Picture
    33,511 Most Valuable Professional on at

    Hi @polywantacracke,

     

    The task ID is a unique identifier and not the name. If the name would be used as unique identifier you would never be able to create tasks with the same name 😉

     

    The system needs to know a unique identifier to be able to retrieve the correct task. Hopefully that makes sense 🙂

  • polywantacracke Profile Picture
    24 on at

    Thanks, this does make sense.

     

    So is there a way to automatically retrieve all the task IDs? Or do I have to go to the link for each one separately? 

     

    Thanks!

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!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard