Skip to main content

Notifications

Announcements

No record found.

Project Service Automation forum
Suggested answer

Email Template Types under projects and tasks

Posted on by 15

Hello,

I extensively use the project side of dynamics to manage customer installs. I currently use Project with automation to sync this with my desktop.

I have a couple of questions.

1, Currently I use Email templates for quite a lot of communication. It helps keep the workflow list down so it is quite easy. The only way to make the template visible is to make them Global template and then this restricts them to user tags only for insertion into emails. I would like to add other fields that are directly associated with the project or task. Is this possible using templates or do I have to create a page full of flows ?

1, Is there any way to get additional information like notes to dynamics tasks from MS Project

2, Is there any way to get task completion to sync from dynamics to MS Project

  • Andrew APAC Profile Picture
    Andrew APAC 15 on at
    RE: Email Template Types under projects and tasks

    Thanks,

    Yes it answers my question.

    Sadly it's No.

    :-)

  • Suggested answer
    Matthew Lazowski Profile Picture
    Matthew Lazowski 3,163 on at
    RE: Email Template Types under projects and tasks

    Hi Andrew,

    Here is the list of fields that get synced between MS Project and Dynamics. Sadly I do not think you can add more fields to the sync.

    MS Project Add-In

    When the MS Project Add-in is used to create a Project in PSA, the following records and fields are populated:

    1. Project

    PSA Field

    PSA Schema

    Source

    Name

    Msdyn_subject

    Specified at Publish

    Customer

    Msdyn_customer

    Specified at Publish

    Calendar Template

    Msdyn_calendarid

    Default

    Currency

    Transactioncurrencyid

    Default

    Contracting Unit

    Msdyn_contractorganization

    Default

    Project Manager

    Msdyn_projectmanager

    Default

    Estimated Start Date

    Msdyn_scheduledstart

    Set from Project Tasks

    Estimated Finish Date

    Msdyn_scheduledend

    Set from Project Tasks

    Estimated Hours

    Msdyn_plannedhours

    Set from Project Tasks

    Team Size

    Msdyn_teamsize

    Set from Project Team Members

     

    1. Project Task

    PSA Field

    PSA Schema

    Source

    Project Task Name

    Msdyn_subject

    Task Name

    Due Date

    Msdyn_scheduledend

    Finish

    Estimated Effort

    Msdyn_effort

    Duration

    Scheduled Duration

    Msdyn_scheduleddurationminutes

    Duration

    Parent Task

    Msdyn_parenttask

     

    Auto Scheduling

    Msdyn_autoscheduling

    Always set to manual

    MS Project Client ID

    Msdyn_msprojectclientid

     

    Resourcing Unit

    Msdyn_resourceorganizationalunitid

    Default

    WBS ID

    Msdyn_wbsid

    Default

     

    1. Project Task Dependencies

    PSA Field

    PSA Schema

    Source

    Link Type

    Msdyn_linktype

    Always set to Finish-to-Start

    Predecessor Task

    Msdyn_predecessortask

    Predecessor

    Successor Task

    Msdyn_successortask

    Predecessor

     

    1. Project Team Member

    PSA Field

    PSA Schema

    Source

    Position Name

    Msdyn_name

    Resource Name

    Bookable Resource

    Msdyn_bookableresourceid

    Set as Generic Resource

    MS Project Client ID

    Msdyn_msprojectclientid

     

    Role

    Msdyn_resourcecategory

    Set as default role

    Resourcing Unit

    Msdyn_organizationalunit

    Default

     

    When the MS Project Add-in is used to create a MS Project from PSA, the following records and fields are populated:

    1. Task

    PSA Record

    PSA Field

    PSA Schema

    Destination

    Project Task

    Project Task Name

    Msdyn_subject

    Task Name

    Project Task

    Due Date

    Msdyn_scheduledend

    Finish

    Project Task

    Estimated Effort

    Msdyn_effort

    Duration

    Project Task

    Scheduled Duration

    Msdyn_scheduleddurationminutes

    Duration

    Project Task

    Parent Task

    Msdyn_parenttask

    Determines hierarchy of subtasks

    Project Task

    Auto Scheduling

    Msdyn_autoscheduling

    Always set to manual

    Project Task

     

     

    PSA Notification (text 30) holds warning about unsupported settings

    Project Task Dependencies

    Link Type

    Msdyn_linktype

    Always set to Finish-to-Start

    Project Task Dependencies

    Predecessor Task

    Msdyn_predecessortask

    Predecessor

    Project Task Dependencies

    Successor Task

    Msdyn_successortask

    Predecessor

     

     

    1. Resource

    PSA Record

    PSA Field

    PSA Schema

    Source

    Project Team Member

    Position Name for generic, Bookable Resource for others

    Msdyn_name

    Resource Name

    Project Team Member

    Bookable Resource

    Msdyn_bookableresourceid

    PSA Generic Resource (yes/no)

    Project Team Member

    Role

    Msdyn_resourcecategory

    PSA Role

    Project Team Member

    Resourcing Unit

    Msdyn_organizationalunit

    PSA Resource Org Unit

     

     

     

    PSA Notifications; holds warning about unsupported settings

     

  • Andrew APAC Profile Picture
    Andrew APAC 15 on at
    RE: Email Template Types under projects and tasks

    Thanks for the answer I suspected as much.

    As to 2 and 3. Basically I was attempting to get a little more information to sync between MS Project and Dynamics. The information that currently syncs works well and since the latest update the date issues have gone. I would like however like to get tasks notes to sync from a MS project task to a Dynamics task and a way to also have the tasks to mark as complete rather than managing both platforms. I have several people working on single projects although I manage MS Project only to keep the client updated.

  • LuHao Profile Picture
    LuHao 40,844 on at
    RE: Email Template Types under projects and tasks

    Hi Andrew,

    First, we recommend that you post only one question per thread, which will make it easier for other forum users to quickly navigate to the exact thread.

    1. Unfortunately, it is impossible.

    We can use the workflow to send emails in bulk, because in the email editor of the workflow we can add dynamic fields of project or task.

    https://www.azamba.com/2017/06/05/how-to-email-notification-workflow-in-microsoft-dynamics-365/

    For sending emails, using workflow is more convenient than power automate.

    2 and 3. Could you elaborate more?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans