web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : Kqv5tpH0VcctPNBTMnRWGM
Power Platform Community / Forums / Power Automate - Building Flows / How do I send an email...
Power Automate - Building Flows
Answered

How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

Like (0) ShareShare
ReportReport
Posted on 14 Feb 2022 01:26:43 by Henry G Smith 166

I want to be able to send a user an email when they go into their task area on dynamics HR and change their task from not started or in progress to 'complete'

I thought the below screenshot may be the way - but it seems to fail. 

DynamicsHS_0-1644801822747.png

DynamicsHS_1-1644801908135.png

Hoping someone will be able to help me out.

Thanks

Categories:
Business Process Flows
I have the same question (0)
  • v-yujincui-msft Profile Picture
    v-yujincui-msft on 18 Feb 2022 at 00:55:44
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi @DynamicsHS ，

     

    Glad to see you solved the problem.

    You could mark your answer or mine as a 'solution' to close the case.

     

    Best Regards,

    Charlile Choi

  • Henry G Smith Profile Picture
    Henry G Smith 166 on 17 Feb 2022 at 23:40:09
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi Charlie I just figured it out !

     

    I used cdm_workerid eq 'output' instead.

     

    and it worked!

     

    Huge thank you! Thank you for the patients as well !

     

     

  • Henry G Smith Profile Picture
    Henry G Smith 166 on 17 Feb 2022 at 21:42:32
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi Charlie, 

     

    The first half of the automation works. However, when I get to the compose section the data for assigned worker ID spits out information that is completely different to the personnel number shown in dataverse data tables, see below:

    DynamicsHS_3-1645134494466.png

     

    in powerapps:

    DynamicsHS_1-1645133699672.png

    If I was to put in: outputs('Get_a_row_by_ID')?['body/_cdm_assignedworkerid_value@Microsoft.Dynamics.CRM.lookuplogicalname']

    what would come up is just cdm_worker

     

    If i put in _cdm_assignedworkerid_value : a random number being' 0673ef6c-2054-ec11-8f8e-00224815a1b6' would appear. 

     

    I also tried:

    cdm_assignedworker  :

    DynamicsHS_2-1645134092430.png

    but nothing comes up in the compose.

     

    it seems like my data isn't reading the worker number at all? 

  • Verified answer
    v-yujincui-msft Profile Picture
    v-yujincui-msft on 17 Feb 2022 at 09:31:44
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi @DynamicsHS ,

     

    Try to modify the previous Flow a little.

    You can find the fieldname from the Action's outputs.

    outputs('Get_a_row_by_ID')?['body/_cr43e_assignedworker_value@OData.Community.Display.V1.FormattedValue']
    cr43e_workernumber
    first(outputs('List_rows')?['body/value'])?['cr43e_emailaddress1']

    vyujincuimsft_1-1645089976711.png

    vyujincuimsft_2-1645090063103.png

    Result Screenshot:

    vyujincuimsft_3-1645090180844.png

     

     

    Best Regards,

    Charlie Choi

     
  • Henry G Smith Profile Picture
    Henry G Smith 166 on 17 Feb 2022 at 05:12:43
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi Charlie, 

     

    My assigned worker column in business process tasks is the one that pulls the personnel number rather than the work name for some reason:

    DynamicsHS_0-1645074394209.png

    the worker name and worker number (personnel number) are also store in the 'workers' table

    DynamicsHS_2-1645074586217.png

    &

     

    DynamicsHS_3-1645074620321.png

    in the worker data table it shows:

    DynamicsHS_4-1645074742345.png

    Regards,

    HS

  • v-yujincui-msft Profile Picture
    v-yujincui-msft on 17 Feb 2022 at 04:29:27
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi @DynamicsHS ,

     

    Could you please tell me which table your personnel number and worker name are stored in?

    Is your ‘Assigned Worker’ column a lookup column? 

    vyujincuimsft_0-1645071498037.png

     

    Best Regards,

    Charlie Choi

  • Henry G Smith Profile Picture
    Henry G Smith 166 on 17 Feb 2022 at 03:54:26
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi Charlie, 

     

    I actually don't have an 'assigned' column in my business process task table of columns. All I have is assigned group, assigned position and 'assigned worker' - but assigned worker bring up the personnel number and not the worker name

     

    see below:

    DynamicsHS_0-1645070024027.png

    assigned worker circled:

    DynamicsHS_1-1645070062282.png

     

    Regards,

    HS

  • v-yujincui-msft Profile Picture
    v-yujincui-msft on 17 Feb 2022 at 03:44:57
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi @DynamicsHS ,

     

    Could you please provide more details about your 'Assigned' column?

     

    Best Regards,

    Charlie Choi

  • Henry G Smith Profile Picture
    Henry G Smith 166 on 17 Feb 2022 at 03:30:19
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi Charlie, 

     

    Here's what came up:

    DynamicsHS_1-1645068553905.png

     

    It seems my personnel number instead is coming up? not the assigned workers name. Even the owner column is just coming up as "Dynamics365 Dynamics 365 for Talent"

     

    Regards,

    HS 

  • v-yujincui-msft Profile Picture
    v-yujincui-msft on 17 Feb 2022 at 03:24:04
    Re: How do I send an email notification to a user when a task status has been complete in Dynamics HR (dataverse)?

    Hi @DynamicsHS ,

     

    You could modify the view to better display the data.

    vyujincuimsft_0-1645068102183.png

    vyujincuimsft_1-1645068148621.png

     

    Best Regards,

    Charlie Choi

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans