#ProjectOnline #PowerApps using the Project Online Connector #PPM #Apps #MSProject #O365 Part3
April 26, 2018 at 10:01 pm | Posted in Add-on, Administration, Configuration, Functionality, Information | 1 CommentTags: fice365, PowerApps, PPM, Project 2016, Project Online
In part three of this series of blog posts we will look at using the CreateProject 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/ and part 2: https://pwmather.wordpress.com/2018/04/11/projectonline-powerapps-using-the-project-online-connector-ppm-apps-msproject-o365-part2/
The CreateProject action is: ProjectOnline.CreateProject({“PWASiteURL”}, {“ProjectName”},{Optional parameters}). As you can see, there is the PWA Site as one required parameter and the Project Name as the other. There are also optional parameters for description and start date as documented here. In this post we will add a new page to our example PowerApp to provide inputs to the parameters for the CreateProject action. Add a new blank screen to the PowerApp, in this example I called the new page NewProject:
Next I added a label to the page to add “Create a new project:” then two text input boxes, one for the Project Name and one for the Project Description. The two text input box properties were updated to remove the default text and add hint text as seen below for the Project Name input box:
Next a date picker was added to select the project start date along with two buttons, one to create the project and one to cancel / navigate back to the homepage. The button text was updated as required and the back button OnSelect property updated to navigate to the Projects page:
The create button action for OnSelect would be ProjectOnline.CreateProject(“PWAURL”, TextInput1.Text,{Description: TextInput2.Text, Start: DatePicker1.SelectedDate}) as seen below:
Update the control references such as TextInput1 as required. That is the minimum needed to create a new project but really there should be checks to ensure the name is set as that is a required parameter and also do things like clear the inputs once the project is created / navigate back the homepage automatically. Below is a simple example to ensure the project name input is not blank. Firstly add a new label with the text “Project Name is empty” then add a X icon:
Now select both of those elements from the left menu and group them together:
Now set the group visible property to Off:
Select the X icon and update the OnSelect action to UpdateContext({alert:false}):
Select the grouping then select the Visible property and change the value from false to alert:
Now click the Create button as the OnSelect action needs to be updated to If(IsBlank(TextInput1.Text),UpdateContext({alert:true}),ProjectOnline.CreateProject(“PWAURL”, TextInput1.Text,{Description: TextInput2.Text, Start: DatePicker1.SelectedDate})) as seen below:
Update the control references such as TextInput1 as required. Now if the Project Name input, in my example TextInput1, is empty the alert will be displayed with the X to close the alert:
The final part of this app is to add a button / icon from the home screen to be able to create a new project by navigating to the NewProject screen:
That’s it for now but hopefully enough to get you started with the Project Online Connector for PowerApps, there are more actions available for this connector and so much more you can do with PowerApps! Look out for more Project Online related PowerApps blog posts in the future.
#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.
#ProjectServer and #SharePoint 2013 / 2016 April 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProject
April 11, 2018 at 6:26 am | Posted in Administration, Configuration, CU, Customisation, Fixes, Functionality, Information, Installation | Comments Off on #ProjectServer and #SharePoint 2013 / 2016 April 2018 Cumulative Update #PS2013 #SP2013 #PS2016 #SP2016 #MSProjectTags: Office 2013, Office 2016, Project 2013, Project 2016, Project Server 2013, Project Server 2016, PS2013, PS2016
The Office 2016 April 2018 updates and cumulative updates are now available, please see the links below:
https://support.microsoft.com/en-us/kb/4098622
Project 2016 April 2018 update:
https://support.microsoft.com/en-us/kb/4018320
SharePoint Server 2016 / Project Server 2016 April 2018 update:
https://support.microsoft.com/en-us/kb/4018340 & https://support.microsoft.com/en-us/kb/4018336
The Office 2013 April 2018 updates and cumulative updates are now available, please see the links below:
https://support.microsoft.com/en-us/kb/4098622
Project Server 2013 April 2018 CU Server Roll up package:
https://support.microsoft.com/en-us/kb/4018346
Project Server 2013 April 2018 update:
https://support.microsoft.com/en-us/kb/4018352
Project 2013 April 2018 update:
https://support.microsoft.com/en-us/kb/4018335
Also worth noting, if you haven’t done so already, install Service Pack 1 http://support2.microsoft.com/kb/2880556 first if installing the April 2018 CU for 2013.
As always, fully test these updates on a replica test environment before deploying to production.
Blog at WordPress.com.
Entries and comments feeds.