HELP! Building a flow that sends email with changes in SQL

[clairehola016]

HI all, I am stuck trying to build a flow that sends email to the customers when their status is changed on SQL server. 

This is what I have now: 

What I need is to "send a welcome email to customers whose status on "isMigrated" changed from 0 to 1" Does this look right? I am worried that this means the email will be sent to everyone whenever there is a change on the table, when really I am only trying to send an email to those whose status have changed....any help would be appreciated, I've only built super simply flows before so anything will help! 

Thanks!

[chsanche]

Hi @clairehola016 

You current Flow contains 2 triggers, Recurrence and When an item is modified, the Flows can only have 1 trigger at a time. In this case, you can remove the Recurrence and the Flow is going to trigger on the modification of the records.

Best Regards,

[clairehola016]

@chsanche Thank you so much for your help! I am also wondering if the condition set here is correct? Does this mean that the email will only be sent to those whose status changed instead of everyone? 

Thanks!

[MayT3]

Hi!

i am trying to do the same as you, but I am working with two tables, one is called “comments” and the other one is called “tickets”, in the comments table I have the ticket ID and the user who created the record; on the tickets table I have ticket ID and the user who created the ticket, I would like to send an email to te person who created the ticket (tickets table) every time a new entry in the comments table is created, using the matching ticket ID, could you please advise how I can achieve this? Also, I am not getting dynamic content enabled, I believe this could be an issue while tryin to pull data from the DB

 Thank you!

[MayT3]

Hi!

i am trying to do the same as clairehola016, but I am working with two tables, one is called “comments” and the other one is called “tickets”, in the comments table I have the ticket ID and the user who created the record; on the tickets table I have ticket ID and the user who created the ticket, I would like to send an email to te person who created the ticket (tickets table) every time a new entry in the comments table is created, using the matching ticket ID, could you please advise how I can achieve this? Also, I am not getting dynamic content enabled, I believe this could be an issue while tryin to pull data from the DB

 

 Thank you!

[MayT3]

i am trying to do the same as clairehola016, but I am working with two tables, one is called “comments” and the other one is called “tickets”, in the comments table I have the ticket ID and the user who created the record; on the tickets table I have ticket ID and the user who created the ticket, I would like to send an email to te person who created the ticket (tickets table) every time a new entry in the comments table is created, using the matching ticket ID, could you please advise how I can achieve this? Also, I am not getting dynamic content enabled, I believe this could be an issue while tryin to pull data from the DB

 

 Thank you!