Triggering a Microsoft Flow when a column is updated

mabraham
mabraham
edited 06/14/22 in Add Ons and Integrations

Hi all,

I have a smartsheet that my operations team manages. It tracks all orders that we receive through our defined shipping process. Each order is a new row and there are multiple columns. One of them is the "Estimated Shipping Date" which someone from our team will fill out. I want to create a Microsoft Flow that whenever this date is first put in for that row, we automatically send out an email to the customer (name and email address are found in other columns) with the estimated ship date.

Is this possible? I'm a total newbie to Microsoft Flow and the Smartsheet triggers that are available don't seem to be exactly what I need. I suppose I can use "When a sheet is updated", but I don't know how to put a condition to check if "Estimated Ship Date" value has been updated.

Capture.JPG

Comments