Triggering a Microsoft Flow when a column is updated

02/08/19 Edited 12/09/19

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

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi,

    Is there a specific reason you want to use Flow or could you use something else? I would suggest using Alerts & Actions in Smartsheet instead.

    Would that work?

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • I believe that when we looked at this option, the alert came from a generic Smart Sheet email address, and we needed it to be from a specific corporate email account.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    If it's an alert, it will send from the e-mail address that configured the rule.

    Would that work or do you still need to connect it to Flow?

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • That would work! Thank you!

    I will test ASAP.

    Best regards.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Great!

    Happy to help!

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • I would like to know if there is an answer to the original question. I have an alert set up to notify on approval but do not want a link to the sheet included in the notification. From what I can tell from other boards, the only way this can be done is with a third party, such as Zapier or Power Automate.


Sign In or Register to comment.