Fixing the Sales Pipeline funnel chart’s Pipeline Phases with Power Automate
Every now and then customers comment that their Sales Pipeline funnel chart displays business process stages that they think shouldn’t be on their funnel. The first thing I investigate is what their current Lead To Opportunity and Opportunity Sales Process are and whether any changes have been made to them. If the processes are altered after D365 has been implemented, the funnel chart can… Continue Reading Antti...
Customizing and extending Project for the web
Project for the web was released in October 2019. It runs on Common Data Service, which opens up loads of possibilities for customizing and extending Project. Out-of-the-box, Project offers two different user experiences: An Office UI experience as well as a Model-driven Power Apps experience, based on Unified Interface. Custom Canvas Power Apps can naturally also be built, as long as certain… Continue Reading Antti...
Power Automate: Adding run-only users to a Flow with Flow
One of my previous posts was about listing a user’s Resource Assignments using Power Automate. As the Flow in question is a “personal productivity Flow” that needs to be fired off in a user’s context, a challenge I faced was distributing the Flow to the masses. Well… in my case there’s only me in my tenant and test environment but you get the picture if you have 100 not to mention 1000 people…...
Listing a user’s active Resource Assignments in Project for the web and D365 PSA with Power Automate
A frequent ask from a user assigned to a project is “Which tasks am I assigned to?”. In Project for the web’s (later P4W) and PSA’s terms, this translates to “What are my Resource Assignments?”. Out-of-the-box, there isn’t a straightforward experience to get such a list, unless a new view for Resource Assignments is created in P4W’s or PSA’s Model-driven app. Another solution would...
Dynamics 365 Project Service Automation: Creating a Project with Power Virtual Agents
Power Virtual Agents is definitely a hot topic as I’m writing this blog post. It’s a pretty easy tool to use and definitely a lot of fun. My idea for this post was to create a project in Project for the web by using PVA’s bot as a project template builder. However due to some current limitations with some of Project for the web’s entities, I had to switch my tool from P4W to D365 PSA. The idea… Continue...
Project vlog: Project and Project Task Work Hours
I was watching a couple of Project for the web demos from Ignite by Heather Heide and Russel Hercules. Those demos made me realize that the vlog I previously made about Work templates didn’t fully cover the impact of a Work template’s and Bookable Resource’s work hours on a Project Task’s duration. In short, the following video shows how a Project Task’s duration changes based on a Work… Continue...
Project: Creating a hierarchy for parent and subprojects
Categorizing projects between parent and subprojects is a pretty frequent requirement that I hear in presales. While Project’s Office UI doesn’t support hierarchy visualizations (at least yet), Model-driven apps on CDS do. Visualizing hierarchical data has been around since Dynamics CRM 2015. It’s quite simple to set up and with the new Project, the process is less hassle (at least at the… Continue Reading...
Project: Changing Work Hours for a Work template’s Template Resource
Work Hours and Work templates, which are also known as Calendar Templates and Work Hours Templates, have have a logic of their own in both Project for the web and Dynamics 365 Project Service Automation. Back in the day of PSA V1 and V2, new Work templates needed to be created from scratch, if a change to the underlying work hours was needed. In PSA V3, things got a bit better and changes to… Continue Reading Antti...
Project vlog: Project for the web’s Model-driven app
The Model-driven app for Project for the web makes it possible to extend Project with out-of-the-box features like Roles and Skills. Learn about the different entities and features that ship with Project but are currently mainly accessible from Project’s Model-driven app. Project – Model-driven app Continue Reading Antti Pajunen’s Article on their blog Project vlog: Project for the web’s Model-driven app The...
Project vlog: Getting started with the new Project for the web
The new Project for the web was officially released on October 29th, 2019. This vlog is a 10 minute intro to the new Project to get you up and running with the next generation project management tool from Microsoft. Getting started with Project Continue Reading Antti Pajunen’s Article on their blog Project vlog: Getting started with the new Project for the web The new Project for the web was officially released on October 29th,...
Project vlog: Boards
This vlog covers boards in the new Project for the web. Learn how to quickly arrange and group tasks based on progress, bucket and finish date. Project – Boards Continue Reading Antti Pajunen’s Article on their blog Project vlog: Boards This vlog covers boards in the new Project for the web. Learn how to quickly arrange and group tasks based on progress, bucket and finish date. Project – Boards Blog Syndicated with...
Project vlog: Work templates
This vlog covers Work templates in Project for the web. Learn how to efficiently use Work templates and how to define and set work hours so that projects follow defined working days. Project – Work templates Continue Reading Antti Pajunen’s Article on their blog Project vlog: Work templates This vlog covers Work templates in Project for the web. Learn how to efficiently use Work templates and how to define and set work...
Dynamics 365 Project Service Automation: Setting up Inter-Organizational Sales in PSA
Tested on:Dynamics 365 CE with PSA version 3.10 Multi-currency scenarios are common for many professional services organizations. While PSA has always supported multi-currency scenarios for inter-org sales, that specific area is one of the most complex ones to configure in PSA. The October ’18 wave of business application releases also introduced a new cost price list feature, which will… Continue Reading Antti Pajunen’s...
Referencing records when using the Common Data Service (current environment) connector
The CDS (current environment) connector is the newer version of the two CDS connectors that are available. It has nice new features such as a Create/Update/Delete trigger, support for Service Principals in solution aware Flows and some smaller features in its different actions. It’s the go-to connector to use in solution aware Flows. Despite all the improvements, the connector has also… Continue Reading Antti...
Dynamics 365 Project Service Automation: List of all Primary Keys, Primary Fields and option sets
PSA version referenced: 3.11 Figuring out Primary Keys, Primary Fields and option set values in Dynamics 365 Project Service Automation sometimes takes a bit of time and effort. While there are some sources out these such as the Web API Reference and the Entity Reference, it makes life easier to have all relevant PSA entities and option sets easily available from a single source. This post… Continue Reading Antti Pajunen’s...
Creating a team, a channel and a D365 PSA tab in Microsoft Teams using Flow
This blog post is about enabling collaboration with Microsoft Teams when a Project is created in Dynamics 365 Project Service Automation. The Flow covered on this post will check whether an Account already has a Teams team or not. If a team is present, a new channel for a Project and a PSA tab are created. If a team is not present, the Flow does a bit more and creates an Office 365 Group, a… Continue Reading Antti...
Dynamics 365 Field Service: Moving attachments from Notes to Azure Files and Azure Blobs with Flow
Tested on:Dynamics 365 CE with Field Service v 8.8.2.160, mobile project v 1.0.1322 The previous blog post I wrote was about moving attachments from Notes to SharePoint Online with Flow. My decision to use SharePoint caught the attention of some Azure fans, so I thought I’d explore Azure based storage as well. Azure Storage and all its different services isn’t directly my workload, but this… Continue Reading Antti...
Dynamics 365 Field Service: Moving attachments from Notes to SharePoint Online with Flow
Tested on:Dynamics 365 CE with Field Service v 8.8.0.88, mobile project v 1.0.1322 One of the handy features in Field Service Mobile is the possibility to capture images and signatures. Despite the changes introduced in April 2019 to the storage costs for Common Data Service, SharePoint Online might be better suited for storing all the images that pile up from service and maintenance calls…. Continue Reading Antti...
Dynamics 365 Project Service Automation: Custom Product Bundles
Tested on:Dynamics 365 CE with PSA version 3.9 Enabling Product Bundles has long been a discussion when it comes to Dynamics 365 for Project Service Automation. The OOTB Product Bundles are not supported in PSA but the ask for the feature is out there. It’s something I’ve been running into in pretty much every single presales case that involves materials in some shape or form. As support… Continue Reading Antti...
Dynamics 365 Field Service: Syncing Bookable Resource Bookings to Exchange with Flow
Tested on:Dynamics 365 CE with Field Service version 8.8 I’ve previously written about syncing Dynamics 365 for Project Service Automation’s Resource Assignments to exchange with Flow. For the most part, that Flow can also be used to sync Bookable Resource Bookings to Exchange. The reason we want to do this is because the OOTB feature is deprecated. The Flow covered on this blog post can… Continue Reading Antti...
Dynamics 365 Project Service Automation: Five Q&A scenarios around Time Entries, Actuals, entry recalls and cancellations of approvals
Tested on:Dynamics 365 CE with PSA version 3.8 I was recently doing some testing around Time Entries, Actuals, entry recalls and cancellations of approvals in Dynamics 365 for Project Service Automation. With all the new functionality PSA has around entry recalls and approval cancellations, I can see how the scenarios I’m writing about on this blog post might be a question mark to many PSA… Continue Reading Antti...
Dynamics 365 Project Service Automation: Syncing Resource Assignments with Project Task details to Exchange
Tested on:Dynamics 365 CE with PSA version 3.7 The idea for this blog post came from a conversation on the D365 CE Partner Connect Yammer. Kerry Burn with The 848 Group and CIM had a good question about syncing Project Task information with Bookable Resource Bookings to a user’s calendar in Exchange. Syncing information about Project Tasks has never been supported OOTB and the whole sync… Continue Reading Antti...
Dynamics 365 Project Service Automation: Custom Insight Cards in PSA with Flow
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.7, Unified Interface I recently replied to a question on the Dynamics Community forums about tracking end dates of Project Tasks and comparing them with related Milestones. The question was interesting because looping through all matching Project Tasks and Milestones due utcNow() is something that we need either code or Flow for…. Continue Reading Antti...
Custom Insight Cards in PSA with Flow
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.7, Unified Interface I recently replied to a question on the Dynamics Community forums about tracking end dates of Project Tasks and comparing them with related Milestones. The question was interesting because looping through all matching Project Tasks and Milestones due utcNow() is something that we need either code or Flow… Continue Reading Antti Pajunen’s...
Recalling Time Entries, canceling approvals and correcting Actuals
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.6, Unified Interface The October ’18 release introduced new features to Dynamics 365 Project Service Automation. With PSA’s Update Release 6, the last batch of these new features are now available in the product. Recalling approved Time and Expense Entries, canceling Project Approvals and correcting existing Actuals are… Continue Reading Antti Pajunen’s Article...
Dynamics 365 Project Service Automation: Recalling Time Entries, canceling approvals and correcting Actuals
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.6, Unified Interface The October ’18 release introduced new features to Dynamics 365 Project Service Automation. With PSA’s Update Release 6, the last batch of these new features is now released. Recalling approved Time and Expense Entries, canceling Project Approvals and correcting existing Actuals are three features that are… Continue Reading Antti...
Dynamics 365 Project Service Automation: Using Flow to create a Project with tasks based on Project Contract Line Details
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.6, Unified Interface By default, Project Contract Line Details (later referred to as PCLDs) can be created by importing Project Task and Expense Estimate details from a Project. This is a fast way of creating a frame for an Order and Order Line. Data for PCLDs doesn’t have to be typed in again manually, if a Project with tasks… Continue Reading Antti...
Using Flow to create a Project with tasks based on Project Contract Line Details
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.6, Unified Interface By default, Project Contract Line Details (later referred to as PCLDs) can be created by importing Project Task and Expense Estimate details from a Project. This is a fast way of creating a frame for an Order and Order Line. Data for PCLDs doesn’t have to be typed in again manually, if a Project with… Continue Reading Antti Pajunen’s Article...
Setting Products and Milestones as “Ready to Invoice” when a Project Task is “Complete”
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.6, Unified Interface I was talking to my friend MVP Scott LeFante about products and tasks in Dynamics 365 Project Service Automation after our PSA focused At Your Service episode. Scott and I were thinking about ways of invoicing Product-based lines and Milestones when a Project Task is complete. I naturally wanted to try… Continue Reading Antti Pajunen’s...
Dynamics 365 Project Service Automation: Setting Products and Milestones as “Ready to Invoice” when a Project Task is “Complete”
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.6, Unified Interface I was talking to my friend MVP Scott LeFante about products and tasks in Dynamics 365 Project Service Automation after our PSA focused At Your Service episode. Scott and I were thinking about ways of invoicing Product-based lines and Milestones when a Project Task is complete. I naturally wanted to try that… Continue Reading Antti Pajunen’s...
Creating a Planner plan from a D365 PSA Project with Flow
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.6, Unified Interface My previous post about Creating To-Do tasks from D365 PSA’s Resource Assignments with Flow got me thinking about some of the other collaboration tools we have on the Office side. This led me to think about the possibilities Planner has to offer in conjunction with managing projects with Dynamics 365… Continue Reading Antti Pajunen’s Article...
Creating To-Do tasks from D365 PSA’s Resource Assignments with Flow
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.5, Unified Interface I recently traveled back from the MVP Global Summit with a colleague and fellow MVP Vesa “Vesku” Nopanen. Vesku is a “Microsoft Teams MVP” and a true expert on collaboration, modern workplace and digital transformation. Talking to him got me thinking about all the project and task management tools… Continue Reading Antti Pajunen’s Article on...
Dynamics 365 Project Service Automation: Updating Invoice Line Details and Actuals with values from custom fields
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.4, Unified Interface On my previous post I wrote about using Flow to pass values from custom fields on Actuals throughout PSA’s end-to-end process. The Flows in my previous post used Time Entries as the source for a value for Case. This value was then carried throughout PSA’s end-to-end process from an Unbilled Sales Actual to… Continue Reading Antti...
Dynamics 365 Project Service Automation: Using Flow to pass values from custom fields on Actuals throughout PSA’s end-to-end process
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.4, Unified Interface One of the interesting challenges in PSA has always been passing values from custom fields on Actuals throughout PSA’s end-to-end process. With end-to-end I mean the process of Time Entry to Invoice, keeping in mind that Invoices can be corrected and reconfirmed. Before we dive into the Flows that make this… Continue Reading Antti...
Dynamics 365 Project Service Automation: From Expense Entries to a Project’s Estimate Lines with Flow
Tested on:Dynamics 365 CE version 9.1, PSA solution version 3.3, Unified Interface There was a very interesting question on the Dynamics Community forums about updating Expense Estimates (which are really Estimate Lines related to an Estimate) on a Project based on approved Expense Entries. OOTB this is a bit challenging as Expense Entries are never related to a Project Task nor are they… Continue Reading Antti Pajunen’s...
Getting started with Roadmap
Tested on:Roadmap, Project Online, Common Data Service, Flow The new Roadmap service is rolling out to tenants in different regions. It will give organizations a ” cross-functional, big picture view of all the work in process “. Roadmap and Project Online’s new Home are the first pieces in Microsoft new project management experience. The new project management experience will… Continue Reading Antti Pajunen’s Article on...
Setting Actuals to “Ready to Invoice”
Tested on:Dynamics 365 version 9.2, PSA solution version 3.3, Unified Interface On this blog post I’m covering the changes to how Actuals are invoiced in PSA V3.3. I have also included a small twist by recreating the OOTB functionality of setting Actuals to “Ready to Invoice” and “Not Ready to Invoice” with Flow. Invoicing Actuals has changed slightly in version 3.3 of… Continue Reading Antti Pajunen’s Article on their...
Reversing, canceling and deleting Actuals
Tested on:Dynamics 365 version 9.2, PSA solution version 3.3, Unified Interface Actuals are records that hold financial data about approved Time and Expense Entries, Milestones and Materials in Dynamics 365 Project Service Automation. Actuals are primarily created in the context of Sales (revenue) and Cost for Projects and Project Contracts, and are in most cases passed on to a… Continue Reading Antti Pajunen’s Article on...
Customizing the new Custom Control based Time Entry grid
Tested on:Dynamics 365 version 9.2, PSA solution version 3.3, Unified Interface The October ’18 update of Dynamics 365 Project Service Automation has introduced many much needed features to PSA. One of these features is the new Custom Control based Time Entry grid. For one, it makes submitting Time Entries a lot faster. With the new CC grid the customization experience around Time… Continue Reading Antti Pajunen’s Article...
Validating Resource Roles at Time Entry with Flow
Tested on:Dynamics 365 version 9.1, Project Service Automation solution version 3.1, Unified Interface I have previously written a blog post about preventing Time Entries in Dynamics 365 Project Service Automation when a resource’s Project Team Member Role is different than the Role being used for a Time Entry. Another requirement that occasionally comes up is… Continue Reading Antti Pajunen’s Article on their...
Project Team Member Role to Time Entry with Flow
Tested on: Dynamics 365 version 9.1, Project Service Automation solution version 3.1, Unified Interface When a new Project Team Member record is created, a Role is chosen for the team member. This doesn’t mean that the same Role has to be used when submitting Time Entries as Dynamics 365 Project Service Automation allows a user to submit Time Entries for any defined… Continue Reading Antti Pajunen’s Article on their blog...
From Opportunity Lines to Work Order Products and Services with Flow
Tested on:Dynamics 365 version 9.1, Field Service solution version 8.x, Unified Interface A common customer scenario is one where a core Dynamics 365 Customer Engagement Opportunity form is in use for a sales process. “What do we do with our Opportunity form” is a question that arises in almost every Field Service and PSA implementation where D365 CE is already in… Continue Reading Antti Pajunen’s Article on their...
Vlog covering Bookings and Assignments in PSA V3
Tested on:Dynamics 365 version 9.2, PSA solution version 3.1, Unified Interface Version 3 of Dynamics 365 Project Service Automation has changed the way bookings and assignments work in PSA. As they are now only loosely coupled, Project Managers have more flexibility when it comes to resourcing. This vlog will cover resource bookings and assignments in PSA V3. Be sure… Continue Reading Antti Pajunen’s Article on their...
Marking a Project Task as Complete to prevent Time Entries
Tested on:Dynamics 365 version 9.0.2, PSA solution version 3.x, Unified Interface A subject that comes up frequently is marking Project Tasks as Complete to prevent Time Entries to those tasks. As Dynamics 365 Project Service Automation doesn’t have this functionality out-of-the-box, we have to do some customizing to achieve this goal. This brief blog post will cover… Continue Reading Antti Pajunen’s Article on their...
Two-tier Time Entry approvals with Flow
Tested on:Dynamics 365 version 9.0.2, PSA solution version 3.x, Unified Interface, Microsoft Flow Time and Expense Entries and their approvals are an important part of Dynamics 365 Project Service Automation. A slight downside to Project Approvals is that the logic is based on a single level approval process: A user (or users) set as a Project Approver under Project Team Members approves… Continue Reading Antti Pajunen’s...
PSA V2, Field Service V7 and the Unified Interface
Tested on:Dynamics 365 Customer Engagement version 9.0.2PSA solution version 2.4.6.27Field Service solution version 7.5.3.36Unified Interface I recently tried the Field Service app after updating the V7 Field Service solution and to my surprise the app launched on the Unified Interface. When I was provisioning Field Service to a vanilla instance a few days ago, I… Continue Reading Antti Pajunen’s Article on their...
Dynamics 365 Project Service Automation: Reconciliation View
Tested on: Dynamics 365 version 9.0.2, PSA solution version 3.x, Unified Interface PSA version 3 has a new feature called the Reconciliation View. It’s found on the Project entity. As bookings and assignments on tasks are now only loosely coupled in V3, the new Reconciliation View allows a project manager to reconcile differences between them. This blog post covers three high level… Continue Reading Antti Pajunen’s Article...
Using Flow and PSA to create Time Entries of Work Order Service Tasks
Tested on:Dynamics 365 version 9.0.2, Field Service solution version 8.x, PSA solution version 3.x, Unified Interface, Microsoft Flow Enabling field technicians to generate additional sales on their service calls is one of the many selling points of Dynamics 365 for Field Service. When Microsoft’s Global Field Service Director Ben Vollmer gave a presentation on Field Service at the D365UG… Continue Reading Antti Pajunen’s...
Time Entries in Field Service by using Flow and PSA
Tested on:Dynamics 365 version 9.0.2, Field Service solution version 7.x, PSA solution version 2.x, classic web client, Microsoft Flow One of the most frequent questions I face when doing Dynamics 365 Field Service presales is “How do we submit time entries?“. OOTB Field Service doesn’t offer Time and Expense Entries the way Dynamics 365 Project Service Automation does. Field Service… Continue Reading Antti Pajunen’s...
Adding a lookup to a related Agreement and Work Order on an Invoice
Tested on:Dynamics 365 version 9.0.2, FS solution version 8.x, Unified Client Interface When looking at a Field Service Invoice, one quickly notices it is missing a lookup to a related Agreement and Work Order. References to those entities can be found but they are a couple of mouse clicks away. Navigating to an Invoice Line reveals references to a related Agreement… Continue Reading Antti Pajunen’s Article on their...