pbit file and enter the web URL of the Excel fileĪssociate each Plan with a Team in Microsoft Teams. Test, test, test, until the flow runs successfully!!. Update the flow to point to the SharePoint document library.Add the scripts to the automate tab in Excel online, and test that they work (assuming you are using one of the flows that needs an Office Script).Import the Flow package into Power Automate.Upload the Excel file into a SharePoint document library.Associate each Plan with a Team in Microsoft Teams.The following outlines the deployment and configuration process to deploying the solution, and assumes you are using the flow with Office Scripts. A Power BI template (.pbit) file that visualizes the Planner data.An Excel file that holds the Planner data.The office script files that are used to empty the tables in Excel (if necessary)Īdditionally, the following two files are common across all of the flows.An exported Flow package that copies the Planner data into an Excel file.The following files are included in each folder It is based on the Parallel with Office Scripts flow. The folder called Single Team allows you to just sync Planner tasks for a single Office Team. Some people have found that this is the fastest flow, but on my system this is inconclusive. The folder called Sequential is modification of the Office Scripts flow, however it consists of just a single branch in the flow. Anecdotally the flow with Office Scripts is more stable and runs faster. The next modification was to use Office Scripts and this is available in the Parallel with Office Scripts folder. The original flow (as per the youtube videos reference above) and is available in the Parallel with no Office Scripts folder. The repository contains four versions of the PowerAutomate flow. The orgininal flow has been amended several times, for an overivew of the whole process you need to watch both the original video and then follow it up with This repository contains files and information required to sync the tasks from Microsoft Planner to an Excel file stored in SharePoint, which can then be read by Power BI so in simple terms it provides an automatic sync between all Planner plans and Power BI. Planner-PowerBI-with-PowerAutomate Synching Planner Plans to Power BI using Power Automate Introduction
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |