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
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (1,730)