web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SmartSheet workflow to...
Power Automate
Suggested Answer

SmartSheet workflow to send out an email

(0) ShareShare
ReportReport
Posted on by 4
I hope someone can provide some guidance on how to create this automation workflow.
I’m trying to generate an email after a new row has been created on Smartsheet table and include these fields that are in the Smartsheet table and include them in the body of the email.
 
your assistance is greatly appreciated.

Type of Opening:
Opening Date:
Concept:
Unit Name:
Unit Number:
Shipping Address:
Contact: Contact:
Office Phone:
Email:
Division:
Payment:
Order Platform:
Assign Purchase Region #:
Categories:
I have the same question (0)
  • Suggested answer
    Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
    Hi 
     
    To make the flow - just follow the steps 
     
    Currently I don't have access to smartsheet but can guide you how to do it.
     
    1. First create a flow after selecting following trigger which triggers the flow when the row is added in smartsheet.
     
     
    2. Now the trigger would have some dynamic contents which may be having all the required values- you can place all the required values in send email action as shown below and then by which you can send email.
     
     
    Hope it helps !
     
    Thanks & Regards,

    Nived N :rocket:

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    :magnifying_glass_tilted_left: Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! :raising_hands:

  • AD-26071511-0 Profile Picture
    4 on at
    Hi Nived,
     
    Thank you for your response, I'm having difficulty grabbing the fields from Smartsheet and adding them to the Body of the email.  Here is my example.
     

    The fields are within the Smartsheet Sheet, each description is in different columns.
    Example:
     
    How can these fields be added to the body of the email within Power automate workflow?


    Col 1 Type of Opening:
    Col 2 Opening Date:
    Col 3 Concept:
    Col 4 Unit Name:
    Col 5 Unit Number:
    Col 6 Shipping Address:
    Col 7  Contact: Contact:
     
    Best regards,

    I can be reach at Alejandro.delagarza@sodexo.com
  • AD-26071511-0 Profile Picture
    4 on at
     I need to insert each fields in the body of the email below. Lining up in this ordered 

    Col 1 Type of Opening:
    Col 2 Opening Date:
    Col 3 Concept:
    Col 4 Unit Name:
    Col 5 Unit Number:
    Col 6 Shipping Address:
    Col 7  Contact:
     
     
  • Nived_Nambiar Profile Picture
    18,129 Super User 2025 Season 2 on at
     
    since i don't have access to smartsheet, i could not try this. But can you show me what are the output associated with the trigger's output- I hope that has the columns values required.
     
    Thanks & Regards,

    Nived N 

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard