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 / Updating multiple Plan...
Power Automate
Unanswered

Updating multiple Planner Tasks

(0) ShareShare
ReportReport
Posted on 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.

Current State of Create Task and Update Row and Add Checklist Items.png
Categories:
I have the same question (0)

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
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 190 Super User 2025 Season 2

Last 30 days Overall leaderboard