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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email content based on...
Power Automate
Answered

Email content based on Forms answers

(0) ShareShare
ReportReport
Posted on by 31

We've got a Form to fill out for new hires, and based on the answers we need to send an email to the HR manager including which trainings to sign the employee up for. The issue I have is figuring out the translate the answers from the Form into a list of trainings. We made an Excel table that correlates the right training to the answer, but is there a way to link the whole table instead of one row at a time using "Get a row"? Or is there an easier way entirely that I'm missing?

Categories:
  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @sanderson62089 

     

    Not sure I understood everything you mentioned. Could you post your current screen shot of your flow? 

     

    Thanks

  • sanderson62089 Profile Picture
    31 on at

    I don't have the actual flow because I'm trying to guide someone else, but this is the basis we're looking at:

    sanderson62089_0-1631041939869.png

    We're trying to make it set up a Task to sign the new employee up for a training, and also send an email to the HR manager with the training the new employee needs.  For example, here's one of the questions:

    sanderson62089_1-1631042083490.png

    If the employee is not expected to have field work, then they don't need the basic training. But if any of the other three answers are selected, then they will. Here is the table we made linking the answers to the appropriate trainings:

    sanderson62089_3-1631042183861.png

    So the question is, is it possible create an email based on the answers to the Form but swapping in the correlated trainings in the second column?

  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @sanderson62089 

     

    Yes it is possible. You need an IF condition to check the response text and add the relevant trainings. 

     

    Thanks

  • sanderson62089 Profile Picture
    31 on at

    Could I ask you to elaborate a little bit more on that? I'm still relatively new to Power Automate.

  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @sanderson62089 

     

    Could you please check your email and reply?

  • Verified answer
    abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @sanderson62089 

     

    Thanks for the discussions. You can collect all the answers from Form. Declare a variable and append the responses for  single/multi-choices. Finally map the variable which contains all the responses under the email step.

     

    Thanks

  • sanderson62089 Profile Picture
    31 on at

    Thank you again! You're a Power Automate wizard.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 335 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard