Triggering a Microsoft Flow when a column is updated
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.
Comments
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That would work! Thank you!
I will test ASAP.
Best regards.
-
Great!
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives