Using Microsoft Office 365, how to create one central list to keep an eye on small and large projects and have ability to delegate these to team members.

Hi Vasil,

We have a long list of tasks listed on an Excel sheet.

Can we import tasks from this sheet into Microsoft Planner instead of manually inserting them?

Thanks,
Robbie

There's no such functionality built-in. But you can use the Graph API or Flow to achieve this.

Hi Vasil,

Thank you.

I am trying to add a Gmail address to our Microsoft Team. I have enabled external and Guest access.

Is this possible to do? If so, how do I connect the Gmail address with Microsoft Teams.

Thanks,
Robbie

You need to invite him as a Guest user: https://support.office.com/en-us/article/add-guests-to-a-team-in-teams-fccb4fa6-f864-4508-bdde-256e7384a14f

Hi Vasil,

This has worked for me.

I can invite Guest users to our team.

Thanks for that.

I looked into Flow and Graph API and they are not too straight forward.

There are no templates for transferring data from Excel to Planner.

Ideally if there was even pre-written code we could use to create this or some extension to Office 365 for this function, it would be helpful.

We don't want to manually enter all tasks that have to be entered into Planner as it would be too time consuming.

Also, it would be beneficial if it was automated so that the tasks would be added to Planner after row of data entered in Excel.

Any ideas on this?

Thanks,
Robbie

There's a sample Flow here: https://powerusers.microsoft.com/t5/Building-Flows/Creating-Planner-Tasks-from-Excel/td-p/248461

Other than that you could look for some third-party tools that might do this, but those usually come at a price. Here's a sample one: https://apps4.pro/import-export-planner-tasks-using-excel.aspx