web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dynamics 365 and Flow ...
Power Automate
Answered

Dynamics 365 and Flow -> Send mail on status change

(0) ShareShare
ReportReport
Posted on by

Hi,

 

I am new at flows but I already have problems 🙂

I want to create an email when a Dynamics 365 record changes it state to "Active".

So I created this flow:

image.png

My problem now is, that for every update in my record in this state, I will get an email. But I just want it on the change where the state is set.

So changing the state from DRAFT to ACTIVE (2 to 0) should send an email, but updating the record in state ACTIVE schouldn't.

How to solve this in flow?

With c# I would use Pre and PostImage for this. But in flow I have no idea for this.


Best,

Robin

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    on at

    Hi @RobinPi ,

     

    Which entity are you using?

    Which dynamic content are you using in the Condition? Could you show me the full name of the dynamic content in the Condition?

    I guess that you are working with entity Products, if you want to send an email when the status is Active, please try the following flow.

    In the Condition, select dynamic content Status Label for left value field, then enter Active in the right value field, only when the product is published will the notification be sent.

    1.PNG

     

    Best regards,

    Mabel

     

  • Community Power Platform Member Profile Picture
    on at

    Hi Mabel,

     

    I am using flow with Attract (Dynamics for Talent) and using the "jop openings" entity. It's created in Status "Draft" (Code 2) and I can set it to status "active" (code 0). Then I will get an email for this.

    But I will get an email too when in status "active" any other property is updated. Is there any way to get the changed properties inside flow? So I can check if there is "msydn_jobopeningstatus" in the changed properties?

    image.png

     

    Best,

    Robin

  • Verified answer
    v-yamao-msft Profile Picture
    on at

    Hi @RobinPi ,

     

    Thanks for updating.

    When using the trigger When a record is updated, the flow will be triggered whenever a record is updated. I’m afraid that currently there is no possible way to just trigger the flow when specific field is updated.

    I have seen a similar request on Flow Ideas Forum, please vote it at here:

    https://powerusers.microsoft.com/t5/Flow-Ideas/Workflow-start-conditional-based-on-change-to-item-properties/idi-p/76869?advanced=false&collapse_discussion=true&filter=location&location=idea-board:FlowIdeas&q=on%20specific%20item%20changes&search_type=thread

     

    Best regards,

    Mabel

     

  • Community Power Platform Member Profile Picture
    on at

    Hi @v-yamao-msft,

     

    thanks for your answer. I voted for the idea and accepted your solution so far.

     

    Best,

    Robin

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard