Bulk Import Excel Tasks in Planner using Power Automate

In this video you will learn how to bulk import tasks in planner from excel file. First, I will convert excel sheet containing tasks data to a table and then I will create power automate flow which will loop through all records from excel table and create tasks in the designated project plan inside planner app.

🔴 *** BE OUR FRIEND ***

🔎 HASHTAGS 🔎
#PowerAutomate
#Planner
#Excel

[allisonbrowning]

THANK YOU! Just imported over 300 tasks in a matter of minutes. You are a life saver

[anupamgupta]

Here's the due date script - if(empty(item()?['Due Date']}, null, add0dDays('1899-12-30', int(item()?['Due Date']), 'yyyy-MM-dd'))

[lisamariem]

Only video online that was short and sweet also very effective and to the point for creating this task! Thank you so much!!! Amazing job!

[vanitakumar]

ps - you made my work so much easier - I managed to create 50 tasks with so much ease! This flow works like a charm.

[freakyblonde]

Fantastic video. Made my day as my team was struggling with this issue after migrating to another system. Thank you!

[sketchtwenty]

I will create this PA flow to use as a template for whenever it makes sense to start planning in Excel then to move the tasks into planner for assigning and tracking progress. Great job.

[meghannygren]

Thank you for making my day easier today!

[vanitakumar]

Thank you - this was so easy and simple to follow - Highly appreciate your efforts in creating this video and making it so simple. Thank you again!

[tatyanamutovskaya]

Thanks a lot for this detailed step-by-step video! It’s highly engaging! I’m going to try right now ;)

[Knowdis]

Thank you so much. Very good instructions!

[greenstair]

Thank you that was really helpful to me. Very much appreciated

[jonahnelson]

if(empty(item()?['Due Date']), null, addDays('1899-12-31', int(item()?['Due Date']), 'yyy-MM-dd'))

[ryanthompson]

Great video, although a bit fast at times. Note that I exported my Tasks from MS Project into Excel and thus skipped the date format issue. Thanks a lot!

[Tigse]

Extremely helpful video, thanks for this. Is there also the possibility to import the "Description" or "Comments" field for a task?

[mohammedakeef]

Nicely put. Very short and informative. Could you please share the formula to convert date ?? Would be really helpful.
Thanks.

[dbfather]

do you know of a way to bring notes in as well? I attempted to add a column titled "Notes" with the information needed for each row but it wasn't pulled. Thank you for making this tutorial though, it has been the only one that has actually helped.

[UmarKBinAlam]

It would be nice if you put the formula in the video description in the text format to copy paste

[Mitchell_]

Great Video really helpful and works well! Like most of the other comments I have a question is there a way to import the priority and labels from the excel sheet into the planner? I found the format it is entered in by exporting the plan to excel but i cant seem to get the labels to be attached when running the flow? Any help if this is possible is amazing!

I have filled all the relevant cells in on excel its just getting Planner to read the cells and automatically populate the information I am struggling with!

[rtdqmwb]

This is great. For some reason it creates a due date but not a start date. Any ideas?

[fstnfncyndn]

There is one hiccup I am running into. The date script formats it very nicely, except my dates are off by a day ahead. Example My Due date in my spreadsheet is July 31, but when it's imported to Planner it's showing up as July 30th. Do you know of a way I can update the script to account for the default midnight timestamp it's applying to the data?