Using Microsoft Flow to Send Email

Hello,

Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an attachment of various do's & don'ts.

I think I've got my flow set up ok but I'm wondering out I create separate variables from the newly created row in Flow so that I can then use those as email fields, name fields, etc.

Find more posts tagged with

Sheets

API and Developers

Integrations

Email Notifications

Comments

Alejandra

Hi Oby,

If you want to include an attachment in an alert, you could upload the attachment to the row, and under the alert's advanced options, you could choose to display the attachment column (if it's not already selected).

Advanced options

Oby

Yes, I was aware of this but that means that I'm filling up my spreadsheet with multiple versions of the same attachment each time. That's not to mention my needing to add an attachment to every row in the first place.

This is why I need to use a template-style alert where the same information is sent each time instead of row/or cell dependent alerts.

This is also why I'm using flow with Smartsheet because Smartsheet doesn't have this functionality currently.

Sign in to join the conversation!

Quick Links

Trending discussions

Will and API token for a report give access to the Sheet the Report generated from?
Hi, I have a large Smartsheet, I want to generate a row report that reduces information displayed down to a specific group. For that Row Report, if I were to generate an API token and share it to a third party, will that third part have access to the information on the original 'Grid' sheet, or will it be reduced to what…
Smartsheet API Bug: Copy Sheet with include=forms Fails (Regression)
Hello Support Team, We are experiencing an issue with the Smartsheet Copy Sheet API when attempting to include forms. Endpoint: POST https://api.smartsheet.com/2.0/sheets/1097094865571716/copy?include=forms Request Body: { "destinationType": "folder", "destinationId": 608151415351172, "newName": "new_sheet_included_Forms"…
Issue with Searching a sheet with more than 10k rows
Hello, I am using the Smartsheet Search rows module in make : I am querying a sheet with 18k rows If i search for data in the first 10k rows it find is. if its after that, it doesnt find it. please help Kind Regards, Wesley.