Trigger an email based on question response

Hi there, I have a form with a lot of questions and it’s working as expected. I’ve been searching for the best way to set up triggers to send an email based on the response to about half of the questions. What’s the best (free) way to do this?

Thanks very much,
Liz

Hi @rangiora_fire_3576,

There are at least methods you can do it, 1- if you are familiar with a programming language, you can write a small script and upload it to a micro server to run. this method can be achieved without any cost but it wouldn’t be easy if you are not familiar 2- if you have access to Power Automate, you can create a flow to trigger based on the answers and send an email to whomever you want, if you have already an Microsoft work account, you might have the access to all needed components

1 Like

If you wish, you can also ‘trigger’ an email from within the form, by exploiting in-form URLs. This will present a URL that the user can then tap, so it does require an explicit user interaction, meaning you cant quite programmatically send an email. But close :slightly_smiling_face:

By making this URL a mailto: link you can basically have tapping the link send an email, and by constructing the link ‘programmatically’ using a calculate, you can actually make both the recipient, subject and even body variable (!) Although you do have to be very conscious of ensuring everything in the URL string is suitably URL escaped; eg spaces have to be replaced with the string “%20

Here’s a simple form the demonstrates this. Have a play and see if it can be adapted to your need. Again, it does require a user interaction to trigger the link, but this is about the most you will be able to readily accomplish directly within a form to send an email.


SimpleEmail.xlsx (14.6 KB)

Otherwise, as @osmanburcu says, you will probably need to setup something post-submission on your server to fire off an integration that sends an email when a submission comes in.

1 Like