![]() Microsoft Project and Planner come from the same team, share many technologies and have increasingly similar interface designs, with Planner getting more powerful tools while features from Planner show up in Project. Managing tasks and projects with a group of people? Microsoft has a lot of tools for task management (including To Do, Outlook tasks, Azure Boards for developers or building your own with Lists) but there are two overlapping offerings for team projects. Project will have the same option for starting a Teams chat about a specific task that Planner already has. Not everyone wants to be a project manager but Microsoft wants to make it less painful when team task management needs to get more formal. (those Excel files have columns with all the info of the planner and tasks belonging to the plan per default setting of export)Įxport all the planners I own or am a member to excel.Why Microsoft has Project and Planner and how they’re converging Per default, per planner, I can go to each of them and manually export to excel. So I will post my question here, hoping for a step by step visual on how to get where I want: Hello I have tried the solution but unfortunately it did not give me a valid run as solution. ![]() If you want to download the full solutions then please visit the downloads page. In general I prefer to just post the steps rather than giving a download, but this time I will make an exception. Have you noticed that the connector doesn’t return the priority of tasks?Īre you interested in including the priority in your exports? The following user voice item is asking for this field to be added to the API of Microsoft Planner This post however will help you get started with the beginning of the export Planner to Excel. There are quite a lot of changes that I would probably make to make this work for larger organisations with many plans and many tasks. In this post I didn’t consider performance. For this please have a look at my post about Formatting dates in Power Automate. Now there is just one thing left to do and that is format the date nicely. This now results in the following listing of my data in Excel I could imagine that start date, name of team and other fields would also be of interest. ![]() But you could of course use any data found in the tasks. In my example I’ve only used Task, Assigned To and Due Date. In my case I will create multiple entries in my excel file. In this post I’m not going to look at merging all these people into a single piece of text, however this is of course possible. Now we can use the display name of the user profile to update our Excel file to give us a nice and clear picture of the users that have been assigned to the task. Yes, that isn’t a very nice display name of a property. The Get user profile action can take the user id that has been supplied by the List tasks action.Īll we need to do is use the value assignments Assigned To User id property. Using the Get user profile action we can collect the user’s details. Also the Due date could do with cleaning up. We want to see people’s names not ugly IDs. If we now added an Excel action to Add a row into a table we would probably get something like this. So far it is all quite easy to collect all the plans. The Plan Id is supplied by the list plans for a group action. Both of these are readily available from the action that we added earlier on. ![]() All we need to supply again is the group id and the plan Id. Then for each of the plans we can collect all the tasks using the List Tasks Action. The will appear as dynamic content for you, so nothing complicated here. Using the List plans for a group action will give us a full overview of the plans within the organisation.įor the Group Id we can use the group Id supplied by the List Teams action. Remember the teams are connected to groups. Using this list of teams we can now collect all the plans. I’m using a manually triggers flow but you could also schedule this on a regular basis. This will give me a list of groups that I want to look at. Building the Export planner to Excel flowįirst things first, To Export planner to Excel, I will need to list all my teams. Tasks can have a start date, a due date, a description and they can be assigned to people and there is quite a bit more, but I don’t want to go into the details of that now. The structure for tasks in Planner is quite simple.Ī Team in Microsoft Teams is connected to one group. Building the Export planner to Excel flow.
0 Comments
Leave a Reply. |