Assigned to, SharePoint to Outlook Flow

[WRD381]

Working to create a SharePoint to Outlook flow that sends an email only when a list item is "assigned to" in SharePoint.  I have that functionally working just fine but the issue I have is every time the item is modified or edited and email is triggered, which is not the intent of the Flow created. I have spent the past few hours looking over posts for guidance but not seeing a real answer on this.  This seems so simple yet not!  

I have tried two Flow styles " when an item is created or modified" but striking out setting up the conditions to only email when "assigned to" is saved.  

Thank you in advance for the assistance .

[miguelcas]

Hi @WRD381 

I'm going to be helping  you with your issue. First I need to know what type of column is Assign to, it's a string? or a Person type?

To do what you want we need to add a trigger condition to the trigger. I will reply with an example once we have the information. 

[WRD381]

"assigned to" is a person/ group column in SharePoint.  

Thank you,

[miguelcas]

Hi @WRD381 

I was working on my side and this trigger condition will help you with your requirement

@not(empty("Dynamic content of the Assigned to"))

Basically what we are doing here it's asking if the Assign to column is empty or not. Adding the not () function to make a not empty to. So, if Assign to is not empty then send the email. 

Please, add this condition to the trigger as the instructions below

1. Add the trigger When an item is created or modified and set it up with the your list. 

2. Add a compose action to create the expression that is going to be in the trigger condition 

3. As an input to the compose action create the expression selecting the dynamic content from the trigger of the assigned to column

Where the yellow mark refers to the functions and the green one to the dynamic content, clicking on Assigned to will write the expression. Please copy this function to be paste on the trigger condition 

4. Go to the trigger settings and add the trigger condition. Write an "@" before you copy the function as the image below. 

Thank you for using Microsoft Power Platform Communities.
Community Support Team - Miguel Castro.
If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

[WRD381]

Thank you for that help. Went ahead and tried to implement that change Unfortunately, each time I make an edit/ reply it still triggers the email of you have been assigned even though that field has been completed.  

Flow created ..

[miguelcas]

Hi @WRD381 

Understanding your case, even if you already assigned an item to someone, you will make a change in the row item. In that case, we need to add a column to the list in order to know if the notification has already been sent. Adding a column with the name Email Sent  as a Yes/No type and then make the trigger condition to evaluate that column will help the flow to know if it's necessary to send the email or not.