Embedding Images into a SharePoint Designer 2013 Workflow

Posted By Posted by: Peter Williams on August 28, 2017

Objective Recently a client requested that their Project Server workflow, as used in Project Online, required that images be embedded into the email. These images were screenshots and are used to assist in providing instructions to end users. Background This customer was in the process of migrating from an on-premise Project Server 2010 environment to

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Online, SharePoint
Blog Posted In 

Connected SharePoint Site Settings Moved

Posted By Posted by: Irfan Rizvi on May 30, 2017

A recent change to Project Online for customers on “First Release” is related to the Settings for Project Sites, which were previously under “Connected SharePoint Sites” page in PWA Settings. These settings were global to the whole PWA and were applicable to all Enterprise Project Types, while this worked fine there were two major drawbacks

Read More


Blog Posted In 

How to Create an Auto-Incrementing Number Field in a SharePoint List

Posted By Posted by: Ahmed Taee on April 27, 2017

Auto-numbering is a common requirement when working with SharePoint lists. You may want an auto-incrementing number on Issues list items such as “ISS-001” and so on. If you try using calculated column with ID field and entered a formula such as = (“ISS-00” & [ID]), this won’t work for new items! The reason being ID field is

Read More


Blog Posted In Blog Posted In: Blog, How to, SharePoint
Blog Posted In 

Auto-Archive SharePoint List Items using PowerShell

Posted By Posted by: Peter Williams on November 7, 2016

Objective To implement business rules around archiving SharePoint list items. For example, if an item is marked complete and the last modified date is over one-year-old, then move item to a nominated archive list. Considerations A client requested the above objective recently. They were several lists on several sites where he wanted to implement an

Read More


Blog Posted In Blog Posted In: How to, Project Online, SharePoint
Blog Posted In Comments Off on Auto-Archive SharePoint List Items using PowerShell

Project Server 2013 permissions synchronization explained

Posted By Posted by: Peter Williams on August 23, 2016

This blog attempts to explain the synchronization of SharePoint group membership/permissions for Project Server 2013. This ONLY applies when Project Server Permissions mode is enabled. Project Server to Project Web App Site Permission Synchronization Note: The statements made in this section are only applicable if the “Enable Project Web App Sync” option is turned on

Read More


Blog Posted In 

Sharing a SharePoint site with AD Group using ADFS/SSO

Posted By Posted by: Peter Williams on July 27, 2016

Over the years EPM Partners have configured our SharePoint farms to support ADFS (SSO) authentication for some of our clients. Recently, a client use Project Online but have their SSRS reports hosted on our SharePoint servers hosted on Microsoft’s Azure platform (which is akin to on-premise environment). Their Project Online uses SSO against their own Active Directory. Obviously,

Read More


Blog Posted In Blog Posted In: Blog, How to, SharePoint, Uncategorized
Blog Posted In 

How to Migrate Projects to PWA & Retain Cross-Project Dependencies

Posted By Posted by: Dan Stopher on April 22, 2015

Context: As we work with clients to leverage the benefits of Project Server, clients frequently ask how they can migrate locally-saved master schedules to Project Server while retaining cross-project dependencies. The objective of this blog is not to cover the broader topic of schedule migration and general best practice, or how to create cross project dependencies (great

Read More


Blog Posted In Blog Posted In: How to, Troubleshooting
Blog Posted In 

Error and Solution: The INSERT statement conflicted with the FOREIGN KEY constraint

Posted By Posted by: Peter Williams on April 13, 2015

We recently received an issue where our client was unable to see a project in their Project Status Report. They had tried publishing the project and received a “Failed But Not Blocking Correlation”. The error below was found in the project server queue: ReportingProjectChangeMessageFailed (24006) – The INSERT statement conflicted with the FOREIGN KEY constraint “FK_MSP_EpmAssignmentByDay_ProjectUID_AssignmentUID”.

Read More


Blog Posted In