Sending links based on MS Form Results

(1) Share

Report

Posted on by NonProfitEmploy

So, the scenario is that there are protected curriculum that must be requested.

The end users would provide their email and select their requested curriculum in the form.

There are links for each selected curriculum and each of those links would go out to their provided email.

So if they selected Curriculum 1, 5, and 3, then they would be emailed the links that provide access to those Curriculum.

The reason for the links rather than the documents is that the links are restricted and monitored.

How would I build this flow? I've never really used Power Automate before, so please ELI5.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

trice602 15,329 Super User 2025 Season 2 on at

Like (1)

Report

Re: Sending links based on MS Form Results

Hi @NonProfitEmploy ,

Here's one way and the easiest way to do it.

Flow actions and details:

Again, the easiest way to do it and for me to show you your first flow, I am just going to check and see if "curriculum 1" was selected in the multiple-choice question. If true, I have a compose statement that is the URL to that curriculum.

condition 2:

condition 3:

condition 4:

condition 5:

Lastly, send email (V2) action:

Again, there are probably at least 3 other ways I can think how to do this and they are more complex involving parse json and other actions that may be difficult for your first flow. This solution is designed to work and also easy to understand.

Was this reply helpful? Yes No
NonProfitEmploy 22 on at

Like (1)

Report

Re: Sending links based on MS Form Results

@trice602

I followed every step, and most of this worked!
The trouble that I'm having now is the "compose" parts and the email part.
I ran a test just now and got an error stating "Bad Request", and also got errors for every Compose section.
Looks like it couldn't collect the "email" response from my form, since it's resulting in null.

Example of Compose errors (all the same type of error):
Example of email error:

Was this reply helpful? Yes No
trice602 15,329 Super User 2025 Season 2 on at

Like (1)

Report

Re: Sending links based on MS Form Results

Hi @NonProfitEmploy ,

On the email action error, there are two dynamic content values available, I am selecting the one that is a question in my form, shown below.

To resolve your errors, please for a screenshot of your Send Email (V2) action, shown above and also show your conditional action and your compose action on the Yes side for Curriculum 1 please.

Was this reply helpful? Yes No
NonProfitEmploy 22 on at

Like (1)

Report

Re: Sending links based on MS Form Results

@trice602

This is the Email function:

I couldn't find the option that looks exactly like yours since I'm working with the online version (don't have the paid desktop version).
Below is what I made for Curriculum 1. I blacked out my actual text for privacy, but replaced it with it's function.

Was this reply helpful? Yes No
trice602 15,329 Super User 2025 Season 2 on at

Like (1)

Report

Re: Sending links based on MS Form Results

Hi @NonProfitEmploy ,

Conditions first. If you look at my original example, I am selecting the dynamic content for my Form question named 'Question' - I see you typed in Question which will not work.

Select your dynamic content for the question asks for the curriculum choices. Also note my question is a multiple-choice question and more than one choice can be selected. Notice here I am checking if the word "Curriculum 1" was selected. Do this for all your curriculum choices.

For the email address, make sure you selected the dynamic content for the 2nd one, shown below.

Was this reply helpful? Yes No
NonProfitEmploy 22 on at

Like (0)

Report

Re: Sending links based on MS Form Results

@trice602

Followed, here's the new error:

Was this reply helpful? Yes No
NonProfitEmploy 22 on at

Like (1)

Report

Re: Sending links based on MS Form Results

@trice602

Ah, wait, I found my issue!
I had been using two different Forms to in the first two functions and then had to go through each Condition and Email functions to correct them so that they were all sourced to the correct document.
It works!
Now I just want to links to not show up back to back, they look like this:

www.randomlink.comwww.randomlink.comwww.randomlink.com www.randomlink.com

I need them to look like this:

www.randomlink.com
www.randomlink.com
www.randomlink.com

Was this reply helpful? Yes No
trice602 15,329 Super User 2025 Season 2 on at

Like (1)

Report

Re: Sending links based on MS Form Results

Hi @NonProfitEmploy ,

Perfect! Please mark my original post as a solution to help others find it quickly too! Ok, so to get the links on a separate line, notice how I have mine in the email vs yours. Compose (press enter), Compose 2 (press enter)....

Glad you got this figured out! Well done 😀

Was this reply helpful? Yes No