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
Solved! Go to 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
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"?
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
@Anonymous
I suggest using a Switch action to send the email.
@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.
@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.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
40 | |
18 | |
16 | |
15 | |
13 |
User | Count |
---|---|
67 | |
36 | |
28 | |
21 | |
19 |