#Project Roadmap is live #PPM #ProjectManagement #MSProject #ProjectOnline #Office365 #PowerPlatfom
December 19, 2018 at 9:00 pm | Posted in Add-on, Administration, App, Configuration, Functionality, Information, Reporting | 2 CommentsTags: MS Project, Office365, Power Platform, PPM, Project Online, Roadmaps
Microsoft Project Roadmap is now live and rolling out! This is available on one of my demo tenants, in this post we will have a walkthrough creating a roadmap. For those of you who might not be aware, Roadmap is a new feature added to Microsoft’s PPM offering, this was announced at Microsoft Ignite: https://pwmather.wordpress.com/2018/09/24/microsoft-project-the-future-ignite-ppm-pmot-workmanagement-projectonline-projectmanagement/ and: https://pwmather.wordpress.com/2018/09/26/microsoft-project-roadmap-product-at-a-glance-ppm-office365-flow-powerplatform-dynamics365-azure-azureboards/
Once this has been rolled to your tenant, it will need to be enabled, Brian Smith covered that already here: https://blogs.msdn.microsoft.com/brismith/2018/12/07/project-online-getting-started-with-roadmap/. Once activated on your tenant, you will see a new option on the Project Home page:
For those of you not familiar with the new Project Home, see this post: https://pwmather.wordpress.com/2018/08/20/new-projectonline-project-home-office365-ppm-ui-ux-msproject-fabricui/
Clicking the Roadmap option for the first time will trigger Roadmap to be set up for the first time on that tenant, you will see the message below:
Once that has completed after a short while, you will see the following page:
This is the blank roadmap canvas ready for you to create your roadmap items. There is a prompt to do this, see the “Add a row” card. Click the Add row button, this will load a side panel on the right:
Specify a name for the row – this could be the project name, feature name etc., it is just your reference for that roadmap item row. Specify an owner for that roadmap row – this is the person who is responsible for that project or feature etc. Then select the connection, the row can either connect to a Project Online project or an Azure DevOps Board:
In this example, I will select Project Online. The panel then changes so you can enter the PWA URL:
Enter the PWA URL and press the green tick to validate it:
Now start typing the name of the project you want to link this row to:
Then click the project name to select it. After a few moments, the panel will update:
Click See Details to view the permissions of the Flow – Roadmap uses Microsoft Flow behind the scenes to sync the data from Project Online and Azure Boards into the Roadmap database. Click Continue, the panel will then update to show what services the Flow will connect to and the account it will use:
Click Connect, after few moments the panel will update to Add items, here you can search for tasks from the linked Project Online project / Azure Board project:
Start typing the task names then select them, the selected items will appear in the table below:
Note the Type column, “Phase” are tasks with a duration greater than 0 and “Key date” are 0 duration tasks. Click Add at the bottom once the tasks are selected. These items will then be added to the roadmap row:
Notice in the right hand panel, you can see the last time the project was updated – this is the last time the project was synchronised to the roadmap database using Microsoft Flow. This happens every 5 minutes but you can trigger it manually by pressing the update button. We will look at the Flow later on. In the right hand panel, you can also click the project name, this will link to the Project Detail Page for that project in Project Online. You can access this project panel by either clicking the row title or selecting the row then clicking the Details button above the timeline.
Key dates can be added to the timeline using the Add key date button:
Key dates can be anything from key business dates to dates when a product is due to ship, it is just a way to visualise important dates for the roadmap.
Multiple rows can be added, you can have different rows linked to different PWA instances or different Azure Boards. The row order can be changed using the Move up or Move down arrow buttons above the timeline when a row is selected.
All items on the roadmap can have a status set:
Give the roadmap a name by clicking the “Untitled roadmap”, this will open a panel for you to update the name:
You have other options on the page, zoom to change the zoom level of the timeline. Filter to filter for a specific owner. Go to date to scroll the timeline to a date and Members to share access to the roadmap. This is done via Office 365 groups, you can either link this to an existing group or create a new one:
Once linked to a group, you will see the privacy level below the roadmap title:
The roadmap then has all of the features the Office 365 groups provide such as File, Planner, SharePoint, Conversations etc. The group can be accessed by clicking the group name on the members callout:
Clicking the Project link on the top bar will take you back to the Project Home, here you will now see your roadmap:
You can create many roadmaps from Project Home, linked to different projects and different Office 365 groups. If you wanted another user to access your roadmap, copy the URL link once you’ve accessed the roadmap then send then the URL, just ensure they have been added as a member to that roadmap.
As mentioned earlier on, the roadmap feature use Microsoft Flow to sync the data with the roadmap database. For each row you create that is linked to Project Online or Azure Boards in a roadmap, a new Flow will get created automatically. These will run every 5 minutes to sync the data. Two rows in my example roadmap were linked to projects in Project Online, this created two Flows for me:
We can drill in and see the Flow:
There are many actions in this Flow to sync the data, the Flow does many checks checking things like the project last published time and will only sync if the project publish was greater than 15 minutes ago. I wouldn’t recommend changing this Flow unless you know what you are doing – there is no need to change this Flow, leave it be! If you do happen to break it by accident, disable the Flow from the Flow admin page then on the roadmap, try to manually update a project row that is linked to that Flow, it will display a Fix option:
Click Fix, the panel will then update to show the Fix button:
Click Fix and the Flow will be redeployed.
That’s it for this post – a great addition to the Microsoft PPM offering.
New #ProjectOnline #Project Home #Office365 #PPM #UI #UX #MSProject #FabricUI
August 20, 2018 at 7:29 pm | Posted in Administration, App, Functionality, Information | 3 CommentsTags: Office365, PPM, Project 2016, Project Online
Recently you may or may not have seen that Project Online has a new Project Home page to improve access and navigation to the projects that you need access to. Those of you that navigate directly to your Project Online PWA URL probably won’t have noticed the new feature, those of you that use the Project app from the app Office 365 app launcher / waffle might have seen this if your Office 365 tenant has been updated.
Access Project from the Office 365 App Launcher:
Or from the office.com site (click Explore all your apps):
This feature is currently rolling out, at the time of writing clicking the Project app on my tenants just directed me to the default /sites/PWA site as it always has done since Project Online was launched. Whilst this feature rolls out fully you can still try and access the new Project Home by navigating directly to https://project.microsoft.com if this has reached your tenant yet. If the feature hasn’t rolled out to your tenant yet, you might see a message stating that you don’t have access to this page.
On one of my demo tenants I can access this:
When you first access the Project Home app, you will see the placeholders for the projects if you have no data there, you have a favourites sections and a Recent section. Here is the page after accessing a few projects on my demo system:
I have 4 projects in my recent list as seen above. You can hover over the project row in the Recent list to add a project as a favorite using the star icon or click the ellipsis to see a menu and use the the Add to favorite menu option:
This then pushes the projects to the favorites section:
You can then click the ellipsis on the card to remove a project as a favorite:
Clicking the project card or project name row in the recent list will navigate you to the project detail page (PDP) – the last PDP you accessed just like it does from the Project Center page as this uses the projectdrilldown.aspx page which will load the last PDP you accessed for that project.
The recent project list will contain projects from multiple Project Web App (PWA) instances on the same Office 365 tenant to give you that central Project Home page for all projects you accessed. By default you will see 8 projects on the recent list ordered by the last accessed time, once you reach more than 8 project, you have the Show more control:
This will then display the next 8 projects, keep pressing Show more until all are displayed, you then see a Show less control:
You have the same feature on the favorites section too:
Also on this page you can use the Create New > Project feature:
This will launch the Create a new project wizard page on the default PWA instance on the tenant – the default instance is /sites/PWA:
You also have the ability to navigate to the the default PWA instance (_sites/PWA) homepage using the “Go to Project Web App –>” link:
Or the Project link on the top nav bar:
On the settings cog you have the license information:
This loads a license page that displays the licenses for the 3rd party software packages / libraries used in Project Home.
Great to see a new look and feel for Project making use of the Office Fabric UI React components.
Getting Starting with #ProjectOnline and #PowerApps #PVC18 presentation links #PPM #PMOT #Apps #Office365 #MSProject
June 14, 2018 at 7:59 pm | Posted in Add-on, Administration, App, Configuration, Customisation, Functionality, Information, Mobile | 1 CommentTags: Apps, Office365, PowerApps, Project Online
Last week I had the pleasure of presenting at the awesome Project Virtual Conference 2018. During my session I referenced existing blog posts and code samples that I had previously published on my blog. As promised in the presentation, here is a blog post containing all of the relevant links to help get you started using PowerApps for Project Online. A link to my session is here: http://projectvirtualconference.com/sessions/getting-started-with-project-online-and-powerapps/
Firstly here is a link to the official PowerApps site: https://powerapps.microsoft.com/en-us/build-powerapps/
The first example app we looked at was a navigation PowerApp for Project Online, this made use of the SharePoint Online connector in PowerApps. As discussed, you would need a process to get the required Project Online data into the target SharePoint list for this approach. Here a link to an example solution starter PowerShell script that will do just that: https://pwmather.wordpress.com/2018/03/01/projectonline-powershell-to-keep-ppm-data-in-sync-on-sharepoint-list-pmot-o365/
Once the data is available, here are the two links that walkthrough creating this example navigation app:
The next example PowerApp we looked at in the presentation made use of the Project Online connector in PowerApps to give examples of using some of the actions available in the connector. This works directly with Project Online so does not require any background process to get data into SharePoint. As mentioned in the presentation, the properties available are fairly limited, hence for the navigation app I had to get the data from Project Online into SharePoint list first as I needed the Project Site URL which is not in the Project data set in the Project Online connector for PowerApps. This example app did make use of the Project Online connector in PowerApps: https://docs.microsoft.com/en-us/connectors/projectonline/
Here are the three links that walkthrough creating this example app:
As mentioned in the presentation, you can create a PowerApp that make use of both the SharePoint connector and Project Online or any number of connectors available for PowerApps – there are lots!
PowerApps are a great way to build business applications without having to write any code!
#ProjectOnline #PowerApps using the Project Online Connector #PPM #Apps #MSProject #O365 Part2
April 11, 2018 at 12:20 pm | Posted in Add-on, Administration, App, Configuration, Customisation | 2 CommentsTags: Office365, PowerApps, PPM, Project 2016, Project Online
In part two of this series of blog posts we will look at using the ListTasks action from the Project Online PowerApps Connector. For those of you that missed part 1, here is a link: https://pwmather.wordpress.com/2018/03/14/projectonline-powerapps-using-the-project-online-connector-ppm-apps-msproject-o365-part1/
The ListTasks action is: ProjectOnline.ListTasks("{ProjectGUID}","{"PWASiteURL}).value
As you can see we need to pass in two parameters here, the Project GUID and the PWA Site URL. As this requires the Project GUID, we will use the PowerApp we started with in part 1 and pass in the Project GUID from the first screen. Add another screen to your PowerApp, in this example I have just added a blank screen and renamed it to Tasks:
Now add a data table to this new screen:
With the new data table selected, click the Advanced option in the right pane:
Now on the advanced settings pane, in DATA > Items enter:
ProjectOnline.ListTasks(Gallery2.Selected.Id,https://tenant.sharepoint.com/sites/pwa).value
Update the query as required, for example update to the correct gallery name and update to the correct PWA URL.
Click “Choose the fields you want to add from the customization pane”, in this example I have selected Name and PercentComplete:
Now I will add a label at the top of the screen to display the Project Name. With the label added to the screen, select the label and click the advanced setting pane:
In DATA > Text starting typing the name of your gallery added to the first screen, select it then type “.” then click selected then “.” then click Name:
Now the project name for the first project in the gallery will display:
You could look to include an option here to add new tasks if you wanted, the action to use would be: https://docs.microsoft.com/en-us/connectors/projectonline/#creates-new-task
Now we need to add in a control to be able to navigate back to the projects screen, I have just added a left arrow icon then updated the OnSelect property in the advanced settings pane to navigate to the projects screen:
Now on the Projects screen we need to update the next icon on the gallery to navigate to the Tasks screen, select the icon and update the OnSelect property on the advanced pane:
Now you have an app that will display a list of all projects directly from Project Online, then access the tasks from that selected project.
Next up we will look at create new projects in Project Online using the CreateProject action.
#ProjectOnline #PowerApps using the Project Online Connector #PPM #Apps #MSProject #O365 Part1
March 14, 2018 at 10:39 pm | Posted in Add-on, Administration, App, Configuration, Customisation | 2 CommentsTags: Office365, PowerApps, PPM, Project 2016, Project Online
I recently published two articles on creating a navigation type app for Project Online using PowerApps, here is a screen shot of the project details screen from that example app:
For those of you that missed those posts, the links are below:
That particular example used a SharePoint list as the data source as there were certain properties I needed such as the Project Site URL that are not available in the native Project Online connector for PowerApps. I also stored project images in that source SharePoint list and displayed those in my example app. I used a custom process to populate the SharePoint list with the Project Online data and kept that data in sync. In this series of blog posts we will look at how to use the native Project Online PowerApps connector: https://docs.microsoft.com/en-us/connectors/projectonline/.
This connector allows us to perform certain actions in PowerApps such as read the list of Projects directly from the PWA site collection: https://docs.microsoft.com/en-us/connectors/projectonline/#List_projects or creating a new project: https://docs.microsoft.com/en-us/connectors/projectonline/#Creates_new_project for example.
This series of blog posts wont build a full PowerApp using this connector but it will show snippets on how to use some of the Project Online PowerApps connector functions.
The first one we will look at is displaying a list of projects in PowerApps using the list projects function.
This series of posts assume that you have set up a Project Online Connection to Project Online:
If you haven’t set up a Project Online connection yet, it is very simple, just click the + New Connection link and find Project Online then add.
Using the PowerApps studio, either desktop or web, we will start with a blank app:
The first thing to do is to add the Project Online data source, click “connect to data”. This will load all of your connections you have added to PowerApps / Flow, select the Project Online connection:
Then close the Data window. Now decide on the visual that you need to display the projects, I inserted a gallery:
Then set the layout to just Title as I only will just display the project name for the purpose of this blog post:
Click Advanced on the Gallery settings pane and you will notice it states “CustomGallerySample” in the DATA > Items field. Update this to:
ProjectOnline.ListProjects("{PWASiteURL}").value
Now you can select a property to display on the gallery, in this example I will select Name:
Now all of your projects will appear in the gallery directly from Project Online:
In the next post we will look at how to use the ListTasks function in the Project Online PowerApps connector.
#ProjectOnline workaround for Project app link on #O365 waffle app launcher #PPM #PMOT #Office365
March 8, 2018 at 2:42 am | Posted in Administration, App, Configuration, Customisation, Fixes, Functionality, Information | 2 CommentsTags: Office365, PPM, Project 2016, Project Online
For organisations that only have one Project Web App (PWA) instance and use /PWA, today using the Project app link on the Office 365 waffle app launcher works as expected. For those organisations that have multiple PWA instances this can be an issue. The link I am talking about can be seen below:
This points to /MyProjects as seen above but when Project Online is present on the tenant it will always redirect to /sites/PWA as seen below:
This can be a problem for those customers that either have multiple PWA instances or do not use the default /PWA instance. Unfortunately the Project link on the waffle app launcher is not configurable so one workaround we have done for clients before is to not use the /PWA instance at all apart from using it as a landing page for the other PWA instances in the organisation. If you are in the planning stage for rolling out Project Online and know that you will have multiple PWA instances on the same Office 365 tenant, this might be a good option for you to consider and explore.
Firstly create the following css file that will be used to remove the PWA quick launch menu:
Save this on the /PWA site somewhere such as the Style Library:
Now edit the PWA homepage and delete the “Track your work” web part and add a content editor web part, in the content editor web part reference the .css file and change the chrome type to None:
Click Apply then click OK and the quick launch will disappear. Add another content editor web part and update the Title to “Project Web App sites” or a more appropriate name as required:
Click the new content editor web part where is states click here to add new content then add in the links to all the PWA instances that you have on the tenant using the content editor web part controls – you have lots of options and can make it look as nice as you like. In this example I have just used a simple table:
Click Stop editing on the Page tab and you will see the following:
Then ensure all users of Project Online have read access to the /PWA site (do not grant higher access as you do not want them incorrectly creating projects here):
This way if a user clicks the “Project” app link on the Office 365 waffle app launcher they can at least then easily navigate onto the correct PWA instance.
You could take this even further and have multiple content editor web parts on the page, one for each PWA instance then use SharePoint’s audience targeting feature to show the correct PWA instance/s for the logged on user.
#ProjectOnline #PowerShell to keep #PPM data in sync on #SharePoint list #PMOT #O365
March 1, 2018 at 1:38 pm | Posted in Add-on, Administration, App, Configuration, Customisation, Functionality, Information | 1 CommentTags: Office365, PowerApps, PowerShell, PPM, Project Online, SharePoint Online
Following on from my two PowerApps posts on creating an example Project Online PowerApps app, I thought I would publish the example PowerShell script that I used to populate and update my SharePoint list in the Project Web App site collection. For those that missed my Project Online PowerApps posts, please find the links below:
The script sample can be downloaded from the Microsoft Script Gallery here: https://gallery.technet.microsoft.com/Keep-Online-data-in-sync-06a1bf8d
This PowerShell script will use the Project Reporting OData API to get all of the published projects in the Project Online PWA Site Collection, then for each project it will then create or update a list item on the specified SharePoint list. If the project has already been created on the SharePoint list on a previous run, the items will be updated rather than creating a new item.The user setting up the script will need to make some changes to the script, this is covered in the blog post.
The account used will need access to the OData API in PWA and contribute access to the target SharePoint list. The SharePoint list will also need to be created beforehand with the required columns.
To get the script to work you will need to reference the DLL as seen in the image below:
This can be installed from the SharePoint Online Client components / management shell. I used the dll from the SharePoint Online Management Shell in this example.
Firstly decide what project level fields you want to include in your PowerApp / SharePoint list, this will determine the list column requirements. Then create the SharePoint list in the PWA site collection with the required columns, for this example I created a list called ProjectData with the columns below:
Title is used for my Project Names in this example. You will then need to update the list item update / creation part of the sample script to map to the correct SharePoint column names you created and the project fields:
Also ensure the variables have been updated correctly, placeholder values seen below:
Save and run the PowerShell script (fully test on a non-production PWA site collection before Production) to ensure the data is captured correctly in the target SharePoint list. This script could be run manually on demand or on schedule using a scheduled task if running on a server or a scheduled Azure Function or other methods. This script could also be updated to work based on the project publish event using a combination of Flow / Logic App and an Azure Function based on previous examples I have blogged: https://pwmather.wordpress.com/2017/08/01/running-projectonline-powershell-in-azure-using-azurefunctions-ppm-cloud-flow-logicapp-part2/
Whilst the purpose of this script was to enable us to get the data into a SharePoint list and keep the data in sync for our PowerApp, it can be used for other purposes. For example, you could use this example script to modified the last script I published for HTLM fields to update existing items rather than creating new items each run. Do keep in mind that this SharePoint list would not be security trimmed like a Project Center view though, so you might want to restrict access to the SharePoint list depending on your data / security policies for your PPM data.
The script is provided "As is" with no warranties etc.
#ProjectOnline #PowerApps example #Office365 #PPM #PMOT #Apps #MSProject #SharePoint Part2
February 24, 2018 at 10:17 pm | Posted in Add-on, Administration, App, Configuration, Customisation, Functionality, Information, Mobile | 2 CommentsTags: Office365, PowerApps, PPM, Project 2016, Project Online, SharePoint Online
In part 2 of this series we look at continuing with the example PowerApp for Project Online for project details and project navigation. For those of you that missed part 1, a link to the post can be found below:
In part 2 we will update the detail screen to display the data we want and include links to PWA for the associated project. If you are following, open the app you started in part 1:
Using the tree view on the left, click DetailScreen1 to load the detail screen or click the chevron next to a project from the browse screen:
Firstly I updated the screen label to “Project Details” and deleted the delete and edit icons:
Next two buttons were added to the top bar, one for the Site and one for the Tasks. The Site button will launch DataCardValue8 which in my case is the Project Site URL as seen below:
The Tasks button will launch the Project Schedule PDP but concatenating the PWA URL for the schedule PDP (or whatever PDP you want to link to) then using the ProjectID, in my case DataCardValue2, from the detail screen for the projuid URL parameter:
The buttons were added to the screen using the insert menu:
As you can see, there are lots of options on the insert ribbon! Other quick links could easily be added such as Issues, Risks, New Risk etc. That is it for the detail view, we have some project details and two buttons that link out to PWA for the associated project:
Just for fun I also added a new screen in for a chart. I inserted a bar chart and created a project count by progress chart:
For the Items, I entered the following formula to count the number of projects Completed, Not Starter or In Progress:
The formula is below for my data, ProjectData is the name of my SharePoint list and Progress is the column on my SharePoint list that contains the % complete value for each project:
Table(
{Column: "Completed", Value: CountIf(ProjectData, Progress = 100)
},
{Column: "Not Started", Value: CountIf(ProjectData, Progress = 0)
},
{Column: "In Progress", Value: CountIf(ProjectData, Progress <> 0 && Progress <> 100)
}
)
Then set the item colours:
I then added the back arrow to navigate back to the main browse screen:
The final change was to add an icon to the main browse screen that enabled navigation to the chart screen:
To preview your app in PowerApps, press F5:
Main screen: list of projects with search and sort using project name, link for each project to project detail screen, access to chart screen, refresh the data and link to create a new project in Project Online
Details screen: project details with button links to the project site or schedule PDP in Project Online PWA and a back button to the main screen
Chart screen: bar chart display project count by progress for Completed, Not Started and In Progress with a back button to the main screen
Once you are happy with your app you can share it to your organisation. Before you do, access the App Settings view and give it a name, set the icon and description:
Then click Save and save it to your organisations PowerApps environment then share the app:
For details on Saving, publishing and sharing your apps see the links here: https://docs.microsoft.com/en-us/powerapps/save-publish-app & https://docs.microsoft.com/en-us/powerapps/share-app Users can then access your app using the browser, PowerApps Studio or the PowerApps mobile app!
Hopefully that has given you enough to get started or given you some ideas for Project Online PowerApps. There are so many features to PowerApps, they are very powerful! For getting started guides on PowerApps start here: https://docs.microsoft.com/en-us/powerapps/getting-started
Have fun!
#ProjectOnline #PowerApps example #Office365 #PPM #PMOT #Apps #MSProject Part1
February 21, 2018 at 11:47 pm | Posted in Add-on, Administration, App, Configuration, Customisation, Functionality, Information, Mobile | 3 CommentsTags: Office365, PowerApps, PPM, Project 2016, Project Online
PowerApps aren’t a new feature in Office 365 but not one that I have blogged about before, mainly due to the lack of native support for Project Online, but I have created apps before using PowerApps – it’s an awesome application! PowerApps provide a great way for users to create powerful business apps without writing code. You can use the same connectors that have use for Flow etc. so there is great support for SharePoint Online but no so much for Project Online. There is a connector in preview but it doesn’t return the properties I needed for this example. To get around this, the easiest approach is to have your Project Online data in a SharePoint list, I have covered a few examples with code samples before:
In this series of posts, we will create a simple navigation type app for Project Online using PowerApps. In part 1 we look at getting started and creating / updating the browse / home screen. To do this we will need the Project Online data in a SharePoint list using a similar process as the examples above. This post assumes you already have your Project Online data available in a SharePoint Online list and a process to keep this updated as your Project Online changes, similar to the list below:
Access PowerApps from the Office 365 app launcher:
This will launch PowerApps:
If you haven’t used SharePoint Online in Flow or PowerApps before, firstly you will need to click Connections > New Connections > Type SharePoint in the Search bar and add the SharePoint connection:
Once you have the connection you can create the app. To create the PowerApp you can either use the web based PowerApps Studio that can be accessed on the Apps page:
Or there is an App available in the Microsoft Store:
For the purpose of this blog post I will be using the Windows 10 App but the steps are the same.
Once the App launches, you can Open existing apps:
Or create a new one, click the New button:
From here you can create an app starting with your data, start from a blank canvas or start from a template. The templates options will present you with template previews to select from:
For the purpose of the this blog post and to keep the blog post shorter, we will start with our SharePoint data, if this is your first PowerApp this might be the best option to start with until you’re familiar with PowerApps:
Type the URL of the site that contains the list:
Press Go then select the correct list and press Connect, in this example it is ProjectData:
PowerApps will then build a working app for you based on the data in your SharePoint list:
Once finished, home / browse screen is displayed:
Clicking the chevron for a project loads the detail screen:
That might be good enough for some scenarios – pretty awesome given it was a click of a button! As mentioned, we will look to make a navigation type app that displays some high level project information so we will make some minor tweaks to the base app PowerApps kindly created for us.
Clicking on different areas on the canvas will enable different settings or you can click the elements using the left hand tree view. The first item we will change is the ProjectData label which by default takes the source list name. This property is the LblAppName1:
Moving down the screen, we want to change the search feature so that the search box and sorting work on the Project Name. To do this, select BrowseGallery1 from the left hand tree view, then click Advanced, finally update the Data items. Replace ComplianceAssetId with Title as seen below in two places:
The search box and sort icon will now work on the Project Name – in our case this is Title on the source SharePoint list.
Next up we want to see Project Name and Project Owner on the project summary section. Using the left hand tree view, click Title1 then access the Advanced menu. In the DATA section under the Text property, update this to “ThisItem.Title”:
Notice the Project Name now appears. Repeat for Subtitle1 and select a different project property or multiple properties, I will set the Project Owner and % complete:
I will also change the Body1 property to display the Project Start and Finish Dates:
The final change for the browse screen in part 1 of this blog post is to change the IconNewItem1, this is the + symbol in the top right corner. In the default app, this will load the edit screen to create a new list item, for this example we will point this to load the create project page in Project Online. Select the IconNewItem1 from the left hand tree view, replace the OnSelect “NewForm(EditForm1;Navigate(EditScreen1, None) with Launch(https://PWASiteURL/_layouts/15/PWA/Wizards/CreateProject.aspx) and update the tooltip as seen below:
The browse screen should look something like this now:
With the ability to search and sort on Project Name:
Worth noting is that this project data will not be security trimmed etc.
We have barely touched the surface of PowerApps but that is it for Part 1. In Part 2 we look at updating the detail view and adding in links to navigate to the project in PWA.
Running #ProjectOnline #PowerShell in #Azure using #AzureFunctions #PPM #Cloud #Flow #LogicApp Part1
July 28, 2017 at 4:50 pm | Posted in Add-on, Administration, App, Configuration, Customisation, Fixes, Functionality, Information, PowerShell, Workflow | 4 CommentsTags: Azure Function, Flow, Office365, PowerShell, PPM, Project 2016, Project Online
Following on from my last post where I published an example solution starter PowerShell script for adding project team users to the Project Site, here I mentioned about running the script in an Azure Function and even running this sync from a Project Online event. The blog post can be seen below if you missed that:
Whilst I will use that example PowerShell script from my last blog post as an example, the concept will work for any PowerShell script.
I wont cover the details in setting up the Azure Function in part 1 as there is plenty of support out there for this – for this example I created an Http Trigger – PowerShell function.
I then uploaded the SharePoint DLLs and copied in the PowerShell script into the editor:
The project site user sync script didn’t work as is as I had to make some minor changes to get this to run from the Azure Function. This included change the way the SharePoint CSOM DLLs where loaded in. In the example script I used Add-Type to load the DLLs but in the Azure Function I had to switch this out to use Import-Module:
The next change I had to make was to comment out all of the feedback to the console, so all of the write-hosts. I also had to remove the functions within the script so that is was one block. After these changes I could execute the PowerShell script to add the project team members from my example project into the associated project site from the Azure Function. As this was an HTTP Trigger Azure Function, you can get the URL to the function and access that URL to execute the function.
This opens up lots of possibilities to easily execute this Azure Function from other applications that can make the HTTP call. For example you build easily execute this script once the project has been published either using a remote event receiver (RER) or a Microsoft Flow / Azure Logic App. The example script would need to be made generic and pass in a variable into the Azure Function for it to be a workable solution.
In part 2 of this blog post we will look at make a full event driven solution that is fired on project publish then executing the Azure Function and passing in a variable.
Author Details
-
Blog at WordPress.com.
Entries and comments feeds.
