Unanswered

Email content based on Forms answers

(0) Share

Report

Posted on by sanderson62089

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:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Hi @sanderson62089

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

Thanks

Was this reply helpful? Yes No
sanderson62089 31 on at

Like (1)

Report

I don't have the actual flow because I'm trying to guide someone else, but this is the basis we're looking at:
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:
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:
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?

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Hi @sanderson62089

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

Thanks

Was this reply helpful? Yes No
sanderson62089 31 on at

Like (0)

Report

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

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Hi @sanderson62089

Could you please check your email and reply?

Was this reply helpful? Yes No
Verified answer

abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
sanderson62089 31 on at

Like (1)

Report

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

Was this reply helpful? Yes No