Unanswered

Emailing files based on selection on a Microsoft Form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all, I'm a beginner with Power Automate and was wondering if I'd be able to get some assistance. I've looked around at previous answers, and I've found folks that needed to get several files off of OneDrive or Sharepoint and attach them all to an email, but my case is a little different, and I'm not sure how to go about it.

Scenario:

I have a Microsoft Form where a user has ten options (they can select one, or multiple). The ten options each correspond with a different file on OneDrive (all the files are in the same folder). If the user selects in the form that they want File 1, File 5, and File 10, how would I create a flow to get and attach only those files to an email?

Thank you!

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

This is a blog Post I wrote on how to email files that are uploaded to an MS Form.

Emailing File Attachments from Forms with Power Automate – What Me Pa..Panic? (dontpapanic.com)

What you want to do is similar, but in steps 2 & 3 you'll need to use the selections provided in the form to create the path to the file they selected. Then in Step #4 you get the file content using that Path instead of the file ID.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Great to meet you Mr. Stork! It's funny, you're actually the reason why I tried out Power Automate... I didn't even know it existed before, until I was googling around and found your blog!

Can you provide a little more guidance in terms of "you'll need to use the selections provided in the form to create the path to the file they selected"? Right now in the (very basic) stuff I've been doing, I've been creating a bunch of individual Condition: Control where it looks at the question, sees if they checked off "General" and then creates an email and sends the "General" file. And so on and so forth for all the other files. Which is clearly not the best way to be doing it! 😄
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Since the files are all in the same folder, and there are only 10. You can just hard code the file paths for each file. Then use a switch to choose which file out of the ten the user is requesting. Then retrieve content using the path and append it to the array as the blog shows. Do that in the loop based on the multiple choices made and you'll have the array to add to the email.