Create Planner Tasks in M365 Planner (GCCH) from Excel

[Dimani]

Hello

I am new to Power Apps, and we are using M365 in GCCH.

We would like to create tasks in a Planner in M365, not at the web version of Planner at https://tasks.office.com/

by loading the tasks from an Excel file.

We found an example using Power Automate, but in GCCH there is no Excel connector.  Therefore we are looking into using Power Apps.  

When searching this forum, found someone mentioned a video.  I took a look and it was about creating tasks at the tasks website.

Wonder if there is any example in creating Planner tasks in M365 programmatically?

Thanks

D

[JimmyWork]

You can always use power automate connector for Planner, it has Create task.
Or use Microsoft Graph for more options and settings.

https://docs.microsoft.com/en-us/graph/api/planner-post-tasks?view=graph-rest-1.0&tabs=http

In Power Apps you can call a power automate flow to create the task from the data you send it from power apps, or call Graph Explorer to do the same.

I would also look into the new Microsoft List formatting, that makes the list item look and act like a Planner task, easier to work with and more option.

[Dimani]

Hello JimmyWork,

Thanks for your information. 

Interesting.  From Power Apps we can call Power Automate Flow to create a Planner task.  

I found these two in our Power Apps, but they do not appear to be for creating tasks in Planner.  Perhaps we are in GCCH, so we do not have the Power Automate connector?

• Power Automate for Admins
• Power Automate Management

I will take a look at Graphic Explorer later.

Good to know list has more options and easier to work with.  I looked at it a bit a while back when creating some items/tasks manually.  Overall, it seems Planner is a bit better as it already have the built-in charts and we can create tasks on the calendar and can see them in the calendar too.  I have not looked further whether list has calendar and built-in charts.  My management like Planner, so we are going for the Planner route at the moment.  In any case, it is good to know that list is easier to work with and has more options programmatically. 

Thanks!

Dimani

[JimmyWork]

@Dimani 

First check this out why I'm recommending list, need to check the calendar option but pretty sure you can have a flow that creates this. The new board view makes the list look like a panner task etc.

https://techcommunity.microsoft.com/t5/sharepoint/board-view-in-sharepoint-online-microsoft-lists/m-...

This gives you info on how to call power automate in power apps.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

Hope this helps, but you will find that Graph supports more options for creating tasks and tags etc. then power automate currently does. And you can always call Graph in a power automate flow.

[Dimani]

Hello JimmyWork

Thanks for your information! 

Did not know that a list can be formatted like a planner and we can call Power Automate from Power Apps.

I have a little success in using the CreateTask from PowerApps to create a task in a planner. 

I pass in the bucket id, task title, start date, due date and assignee.  All values are hard-coded. 

Though it creates the task with the assignee, it always go to no bucket instead of the to do bucket, and both dates are blank. The dates are simply in double quote like "2022-02-22".

There is no error.

I have created another thread asking the above.

The next steps would be reading in records from Excel and looping through those records.

Thank you.

Dimani

[Dimani]

Edit to my last reply.

Looks like the order of the dates in CreateTask matters.

Now both dates are add to the task.

Hopefully can resolve why it does not put the task in the To do bucket.