Adding specific attachments to email response, based on the form results

(0) Share

Report

Posted on by NebulaRoss

Hiya Community,

Could anyone provide me some assistance in regards to a flow I am trying to build?

I have an issue trying to attach a specific sharepoint file to an email response based on the microsoft form results. For example, I have a form with one of the questions results are Level 1 and Level 2. What i would like to do if send the responder an email with a specific PDF depending on which Level they selected.

Any replies will be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (2)

Verified answer

v-LilyW-msft on at

Like (0)

Report

Hi @NebulaRoss
I set up a flow, you can take a try with the screenshots below.
This is my test Form.
Flow in details:
When a new response is submitted and selected level1, the Responder will receive an email with Document.pdf
When a new response is submitted and selected level2, the Responder will receive an email with another Pdf file.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
NebulaRoss 21 on at

Like (0)

Report

Hiya LilyW,

Thank you ever so much on the reply. Unfortunately I am getting errors when running the flow.
I have proivded some screenshots below
I have done some research in reagrds to this issue. I have checked the connections and resigned into the sharepoint connection. Apart from that i am not sure what would be the issue as the file path is correct, and the rest is the same as your solution.

If you can let me know any solution to solve this. that will be brill.

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

Hi @NebulaRoss
From the pictures you shared, you seem to have typed the enter key in Switch action.
Please make sure that only "Level" is put in 'On' field in Switch action.
Best Regards.

Was this reply helpful? Yes No
NebulaRoss 21 on at

Like (0)

Report

Hiya LilyW,
Thanks again for the assistance with this flow.

I have reviewed the changes and a little confused regarding the 'Enter Key'.
Within my form, the question is Which Level this is why the dynamic content is 'Which Level' instead of 'Level' as shown in your flow and form.

This is my form
This is the Dynamic Responses available
There is no character input after 'Which Level' within the 'On' Switch. I just select the Dynamic Response and then move onto the next sections.
If you can assist any further, that will be greatly appreciated.

Was this reply helpful? Yes No
OliverR-82 619 on at

Like (0)

Report
Hi @NebulaRoss ,

What @v-LilyW-msft is saying is that, from your screenshots, it looks like the Switch case resolves to:
Level 2 <new line>
Notice that there seems to be a new (empty) line included. In your 'Case' and 'Case 2' actions you are evaluating on the strings 'Level 1' and 'Level 2' without that new line included. As a result, neither case will evaluate to true.

I would try to find out why the result is evaluating to 'Level 1/2 <new line>' and correct it so that it resolves to just 'Level 2', if possible. If that's not possible, you could try changing your 'Case' and 'Case 2' actions so that they check if the outcome is 'Level 1/2 <new line>'.

Does that make sense?

Was this reply helpful? Yes No
NebulaRoss 21 on at

Like (0)

Report

Hiya @OliverR-82
Thanks for your assistance. Unfortunately I am still learning power automate. I am not sure how/why there would we a new line in the code when applying the dynamic response within the Swtich. Also, how do you access the switch content as code. this may be a lot easier to see why errors occur.

Sorry for being a pain regarding this request.

Was this reply helpful? Yes No
OliverR-82 619 on at

Like (0)

Report

@NebulaRoss can you post a screenshot of how you have configured your Switch action? So, not a screenshot of a flow run (which shows the results of a flow run), but how you have configured it while editing your flow. That way, we can see if you (accidentally) added the new line yourself after the dynamic content, or if that is how the result is returned by MS Forms. So, this part of your flow:
It should look like that.

It should NOT look like this (note the added space, which indicates a new line):

Was this reply helpful? Yes No
OliverR-82 619 on at

Like (0)

Report
Oh I apologize, I just notice that you already provided a screenshot of that action in your earlier posts. You can ignore my request then.

So, judging from your other screenshots, it looks like what MS Forms is returning as a response is:
Level 2 <new line>
I don't know why it does that. But, if that's not something you can change, you could try adding a new line to the Switch action. So, after the Dynamic content, press enter so that it DOES look like this:

Was this reply helpful? Yes No
NebulaRoss 21 on at

Like (0)

Report

Hiya @OliverR-82
Not a problem.

I will give that a try and see if that makes any difference.

Was this reply helpful? Yes No
OliverR-82 619 on at

Like (0)

Report

Yes, I understand your confusion now. I have no explanation as to where the extra line comes from and if it is something that you can change or configure in your MS Forms configuration; I am not knowledgeable about MS Forms. You could try adding the extra line in the Switch action as per my previous post, and see if that works.

Was this reply helpful? Yes No