Auto response email to form responders with specific attachment - not within organization

%3CLINGO-SUB%20id%3D%22lingo-sub-2478176%22%20slang%3D%22en-US%22%3EAuto%20response%20email%20to%20form%20responders%20with%20specific%20attachment%20-%20not%20within%20organization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2478176%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22thread-message-content-body-text%20thread-full-message%22%3E%3CP%20class%3D%22%22%3EWe%20are%20hosting%20a%20PD%20event%20for%20teachers%20in%20which%20they%20evaluate%20each%20session%20they%20attended%20using%20Microsoft%20forms.%20I%20have%20created%20a%20flow%20that%20automatically%20sends%20responders%20an%20email%20once%20they%20submit%20their%20form%20and%20have%20that%20working%20properly.%20However%2C%20I%20want%20to%20attach%20a%20specific%20OneDrive%20file%20(PD%20Certificate)%20to%20the%20email%20based%20on%20what%20session%20they%20selected%20in%20the%20form%20(setup%20as%20a%20multiple%20choice).%20These%20are%20folks%20outside%20of%20our%20organization.%20How%20can%20I%20set%20that%20up%20in%20my%20flow%20as%20an%20email%20attachment%3F%20We%20are%20still%20virtual%2C%20so%20we%20need%20to%20send%20certificates%20via%20email%20and%20we%20would%20like%20for%20this%20to%20be%20automated.%20Thanks%20for%20any%20advice!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2478176%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

We are hosting a PD event for teachers in which they evaluate each session they attended using Microsoft forms. I have created a flow that automatically sends responders an email once they submit their form and have that working properly. However, I want to attach a specific OneDrive file (PD Certificate) to the email based on what session they selected in the form (setup as a multiple choice). These are folks outside of our organization. How can I set that up in my flow as an email attachment? We are still virtual, so we need to send certificates via email and we would like for this to be automated. Thanks for any advice!

 

3 Replies

@CynRes you will neeed to use the switch control in your flow based on the session they attended. In each case in the switch you'll need to add the email action with the specific file as the attachment.

switchDepartment.png

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott, Thank you! However, I have 12 certificates, and it seems I can't have more than 5 cases? I tried getting file metadata and content and then attaching the file name and file content into the email, but it just isn't working. There are no failures in my flow check, so I don't know what I am doing wrong. 

@RobElliott @RobElliott, Thank you. Please disregard my previous reply. I have been working with the switch case, and it seems to work okay, except I still can't get the file to attach to my email. Here are some screenshots. I really need to get the attachments to work. Thank you so much for your time.

Screen Shot 2021-06-24 at 5.06.19 PM.png

Screen Shot 2021-06-24 at 5.06.35 PM.png

Screen Shot 2021-06-24 at 5.06.50 PM.png