I currently have a flow that emails me lead details when a new lead is added to our database. I've used the SQL When an item is created trigger and it's working great.
But I'm running into a situation where sometimes the name of the lead gets updated in the database as we obtain more information about the event.
I'm trying to use the When an item is modified trigger to capture those name changes. I want this to only send the email if the specific field "ProgramName" is what was modified. I don't want to get an email whenever any other field in that row gets changed.
I'm stuck figuring out what action I can add that evaluates if the ProgramName changed. I looked at the "condition" option hoping I could say if ProgramName changed then use the Yes/No branching to determine the action taken. But there is not an evaluator for if the value of the field has been updated.
Any thoughts on what I could use here?
Thank you in advance!
