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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Send email to "Assigned To" user - Only Once!

(0) ShareShare
ReportReport
Posted on by

Hello!

 

I'm trying to build a flow to notify a dynamic user once a ticket has been assigned to him/her.

 

assigned.png

 

As you probably know, as of now the flow triggers each time the item is updated and sends the user an email each time the item is updated.  What can I do to tweak this to only run when the field changes from blank to populated. Or from one user to another? If the field doesn't change, I don't want it to send the email.

 

The same logic would apply for when the ticket is flagged as resolved, and someone makes an update to the item. It sends that same "Your ticket has been resolved" email again.

 

Any help would be greatly appreciated!

I have the same question (0)
  • v-yuazh-msft Profile Picture
    on at
    Re: Send email to "Assigned To" user - Only Once!

    Hi @Anonymous,

     

    Do you want the flow would only run when the "Assigned To" field changes from blank to populated or from one user to another?

     

    If you want the flow would only run when the "Assigned To" field changes from blank to populated or from one user to another that means you want the flow would only run when the "Assigned To" field changes,and the the flow wouldn't run when only other field changes.

     

    The trigger "when a special field is changed" is not supported in microsoft flow currently,

    If you would like this trigger to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

    As an alternative way, you could add a Yes/No type column "AssignedToIsChanged" in your sharepoint list, and every time when an item is modified, if the "Assigned To" field is modifed, then you must set the "AssignedToIsChanged" field to "Yes",if the "Assigned To" field isn't modifed, then you must set the "AssignedToIsChanged" field to "No".

     

    So you could add a Condition under the trigger to check if the "AssignedToIsChanged" field is equal to true, if the "AssignedToIsChanged" field is equal to true, that means the "Assigned To" field is modifed, so you could send the email inside the If yes branch, else, do nothing inside the If no branch.

     

     

    Best regards,

    Alice

     

  • Community Power Platform Member Profile Picture
    on at
    Re: Send email to "Assigned To" user - Only Once!

    Hi @v-yuazh-msft,

     

    Thanks for the reply. I'll  make that suggestion in theFlow Ideas Forum.  As for the workaround, would someone have to manually change the value of the  "AssignedToIsChanged" field?

  • v-yuazh-msft Profile Picture
    on at
    Re: Send email to "Assigned To" user - Only Once!

    Hi @Anonymous,

     

    Yes,  the workaround would need someone to manually change the value of the  "AssignedToIsChanged" field.

     

    Best regards,

    Alice

  • Community Power Platform Member Profile Picture
    on at
    Re: Send email to "Assigned To" user - Only Once!

    Thanks @v-yuazh-msft

     

    Are you aware of any other methods available to automatically send a user who is identified as the person responsible for working this "ticket" an email notifying them it's assigned to them?

     

    I could use Planner,  and  use the out of the box notifications, but i'd lose out  on all of my item metadata doing so.  Any other creative solutions out there?

  • v-yuazh-msft Profile Picture
    on at
    Re: Send email to "Assigned To" user - Only Once!

    Hi @Anonymous,

     

    I afraid that the workaround that I provided is the only way to achieve your requirement and there is no any other way could achieve your requirement in microsoft flow currently.

     

    Please take a try on my solution and let me know if your problem could be solved.

     

    Best regards,

    Alice

  • GabrielStJohn Profile Picture
    on at
    Re: Send email to "Assigned To" user - Only Once!

    Hello, @Anonymous!

    Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


    Thank you for being an active member of the Flow Community!

    -Gabriel
    Flow Community Manager

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

Responsible AI policies

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard