Send mail when status changes in SP list. (Trigger doesn't work)

[Anonymous]

Hi,

I have been trying to create a flow so that, when the status of a sharepoint list changes, an email is sent (depending on its status, it is a different email). I have tried with a "Trigger Conditions" but it has not worked for me. I tried putting "@equals(triggerOutputs()?['body/Status/Value'],'Completed','Rejected']" But the workflow doesn't work (doesn't throw error).

Then, I makea call to "Get changes for an item or a file" and finally, apply a "Condition" where if "Has Column Changed: Status" is equals to "true".

Does anyone have an idea to send personalized emails for each state?

Regards

[ScottShearer]

@Anonymous 

You won't be able to create a triiger condition that tests if a column has changed.  As you already found out, the only way that you'll be able to determine if a column has changed is with a Get changes for an item or a file (properties only) action.

Can you explain more about what you want to do when you say "send personalized emails for each state"?

[Anonymous]

Hi @ScottShearer ,

Thanks for your answer.

In answer to your question, what I am looking to do is that if the List Status changes to "Completed", an email is sent with a structure where some information is added. If you change the status to "Processing", you will be sent an email with a structure containing process data. Finally, if the status changes to "Rejected", an email is sent with confidential information and comments on why it has been rejected.

Emilio

[ScottShearer]

@Anonymous 

I suggest using a Switch action to send the email.

1. Use a When an item or file is modified trigger
2. Add a Get changes for an item or a file (properties only) action action
3. Add a condition that checks if your status column has changed
4. On the true side of the condition, add a switch action and send emails as appropriate

[Anonymous]

@ScottShearer thanks for you help.

Regarding a scenario, I have a query.

In the event that other columns other than the status are modified, the flow would continue to execute, only without sending emails. Is there a way to prevent this from happening? For example, adding a "Trigger condition" ? And if so, how could it be? since the ones that have occurred to me have not worked.

I really appreciate your help, it's part of my path to continue learning.

[ScottShearer · Accepted solution]

@Anonymous 

As I mentioned earlier, you won't be able to use a trigger condition.

In your Flow, add a condition that checks to see if the column of interest to you has changed.  If yes, send the emails.  If no, use a control terminate action (with success) to stop the Flow.

[Anonymous]

@ScottShearer 

Thanks you so much, I have performed the steps according to what you have explained to me and it works perfectly. I will leave photos of how it was in the future, someone is useful.

Regards