Skip to main content

Notifications

Community site session details

Community site session details

Session Id : rNr4xTQbg7/rwYt6Pxj3eJ
Power Automate - Using Connectors
Unanswered

Updating multiple Planner Tasks

Like (0) ShareShare
ReportReport
Posted on 3 Nov 2023 17:53:43 by

I want a Flow to:

  1. Lists rows in an Excel Table
  2. Create Tasks based on data from said rows
  3. Push Task Ids back to the Excel Table
  4. Update the Task Ids contained in the Excel Table with Checklist Items (also defined in the same Excel Table)

#s 1-3 are working fine.

 

#4 is the problem.

 

The current approach is to

  1. set variables and 'ListExcelRows' at the root of the flow, then
  2. in an 'Apply to each' loop ('Create Tasks' > 'Append Array' with Task Ids > 'Update an Excel Table row' with Task Ids), then
  3. in 'Apply to each 1' loop ('Update task details').

Despite a number of different approaches, parent/child relationships can be a barrier, or multiple tasks get created because of the creating Checklist Items, or Task Ids cannot be accessed from Excel because a [0] based Array is expected and Task Ids are definitely not integers.

 

If anyone has a reliable and repeatable solution to accomplish the ultimate objective of creating tasks and then updating those tasks, I'd welcome the help.

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,369 Most Valuable Professional

Leaderboard

Featured topics

Loading complete