cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Creating Planner Tasks from Excel

Hi there, Its my first post so please forgive any errors.

 

I have an excel sheet with a set of tasks that I am trying to import into MS Planner.  I have managed to get to the point where I am able to create a task. by using 'Get Rows' then an 'Apply to each' where I have set the 'Create Task' dialog.

 

See image in this post as it matches.  (sorry could not insert the image)

 

https://powerusers.microsoft.com/t5/General-Flow-Discussion/create-a-flow-using-excel-data-to-create...

 

What is the best method to add the following information to the task as it is included in the Excel data

Bucket Name as listed in Excel

Description

Assignee - Email address listed

Progress

Completed data - Need to add historical data to complete overview of tasks.

 

I have tried to  add these but managed to get myself fully confused so stripped my flow back to the basic task.

 

Any assistance would be most welcome.

21 REPLIES 21
RiKx
Frequent Visitor

Anybody manage to get this working with dates and times?

@v-bacao-msft I am trying to implement the solution you have shown above.  In my use case, I have an Excel file that is an export from planner that has been updated.  I now need to import to planner to update the tasks.  

 

In the update task step, I can't find the planner Task Id in dynamic content.  I can only find the Excel dynamic content (as shown for Title, Due Date-Time, Progress, etc). I've included 2 screenshots below showing what I setup based on what I could find.  I was hoping that this would take what was in Excel and map to the planner fields and update, but the flow failed.  I also took a screenshot showing what I get when I try to find the task ID.  I can't make my flow match what you show.  Thanks in advance.

 

cannot find.png

excel content.png

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,042)