cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pcoombe
Resolver I
Resolver I

Power Automate - how to trigger an email workflow when 'Assigned To' value is changed to another 'Assigned to' value.

Hi All,

 

I was wondering if someone might be able to help me. I need to build a very simple wf which sends an email when the assigned to value changes to someone else. 

I am using the function when an item is created or modified but I am unsure what to put in the control condition. I really need something that triggers send an email when assigned to is not equal to current assigned to but I cannot figure out the current assigned to in terms of how to write this in the power automate flow without pinging an email every time the form is modified, as the form may be modified but the assigned to may not necessarily be the field that is changed. This workflow should only work on that one field. 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @pcoombe ,

Could you please share a bit more about the "Assigned To" field in your SP List?

Is your SP List a SP Task List?

Further, do you want to fire your flow only when the "Assigned To" field is changed (is not equal to previous value) rather than whenever the record is modified in your SP List?

 

Based on the needs that you mentioned, I afraid that there is no direct way to achieve your needs in Power Automate flow. Currently, there is no direct way to get the previous stored value for a column in a SP List in Power Automate flow.

 

As an alternative solution, I think the "Send an HTTP request to SharePoint" action with help of List Versioning (enable List Versioning for your SP Task List) could achieve your needs. Please check and see if the following blog would help in your scenario:

http://johnliu.net/blog/2018/5/microsoft-flow-sharepoint-trigger-on-specific-fields-changed-via-sp-h...

 

In addition, as another solution, you could also consider add another column (called "Assigned To Copy", person type) in your SP Task List to store the previous stored value for the "Assigned To" column. When you create a new item in your SP Task List, set the "Assigned To" column and  "Assigned To Copy" to same value. Then you could configure your flow as below:

2.JPG

 

3.JPG

Please consider take a try with above two solutions, then check if the issue is solved. I think the second solution would be easier that the first one.

Note: I assume that the "Assigned To" field in your SP list is a single option field.

 

Best regards, 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @pcoombe ,

The Flow needs to know both values, so send them both in the parameters to the item that is being changed. You would then have a Condition on those two fields not being equal.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

v-xida-msft
Community Support
Community Support

Hi @pcoombe ,

Could you please share a bit more about the "Assigned To" field in your SP List?

Is your SP List a SP Task List?

Further, do you want to fire your flow only when the "Assigned To" field is changed (is not equal to previous value) rather than whenever the record is modified in your SP List?

 

Based on the needs that you mentioned, I afraid that there is no direct way to achieve your needs in Power Automate flow. Currently, there is no direct way to get the previous stored value for a column in a SP List in Power Automate flow.

 

As an alternative solution, I think the "Send an HTTP request to SharePoint" action with help of List Versioning (enable List Versioning for your SP Task List) could achieve your needs. Please check and see if the following blog would help in your scenario:

http://johnliu.net/blog/2018/5/microsoft-flow-sharepoint-trigger-on-specific-fields-changed-via-sp-h...

 

In addition, as another solution, you could also consider add another column (called "Assigned To Copy", person type) in your SP Task List to store the previous stored value for the "Assigned To" column. When you create a new item in your SP Task List, set the "Assigned To" column and  "Assigned To Copy" to same value. Then you could configure your flow as below:

2.JPG

 

3.JPG

Please consider take a try with above two solutions, then check if the issue is solved. I think the second solution would be easier that the first one.

Note: I assume that the "Assigned To" field in your SP list is a single option field.

 

Best regards, 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xida-msft 

 

I was thinking about the assigned to copy option myself. It is not a task list, just a normal list, so I am thinking of having a wf set up that copies assigned to (person control) to assigned to copy (person control), and then as you say send an email when assigned to <> assigned to. 

 

Really appreciate your help in quantifying the fact that it looks like it has to be a workaround on this one. Cheers!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,257)