How to Get Microsoft Form File Uploads Attached to an Email 📧
Vložit
- čas přidán 11. 07. 2024
- Do you struggle with attaching your Microsoft Form file uploads to Email?
Are you stumped when it comes to handling a response without any file uploads?
In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.
I’m not going to cover how to get the values from your form since I've already covered that in a different tutorial: • How to Get a Microsoft...
In an upcoming tutorial I’ll show you how you can apply this same logic to save your file uploads into a specific folder on SharePoint, how to add metadata to those files and how to add the file uploads to a SharePoint list. Don’t forget to subscribe so you don’t miss out on that tutorial! 👉 bit.ly/SubACreativeOpinion
#microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #techtips #techtipsandtricks #microsoftpowerautomate #sharepoint #sharepointonline #microsoftforms
---
LEVEL UP YOUR POWER AUTOMATE SKILLS:
▶️ ⚡️Automate Microsoft Planner Tasks: Create Tasks from SharePoint & Excel in Minutes: [ • OPTIMIZE your Power Au... ]( • ⚡️Automate Microsoft P... )
▶️ Are you using the Microsoft Power Automate Filter Array Action wrong?: • Are you using the Micr...
▶️ 3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow: • 3 Mistakes YOU 🫵 are M...
---
IN THIS VIDEO:
✅ Two types of MS Forms
✅ Where Microsoft Personal (OneDrive) Form File Uploads are Saved
✅ Where Microsoft Group Form File Uploads are Saved
✅ How to Add a File Upload Question to an MS Form
✅ How to get a Microsoft Form ID
✅ How to get a Microsoft Form Response
✅ How to Get the Dynamic Content Microsoft Form File Upload Content
✅ How to handle Single and Multiple Microsoft Form File Uploads
✅ How to use a Scope action to Organize and Group Your Flow Actions
✅ How to Get the File Content from an MS Form File Upload
✅ How to Collect All Files Uploaded to a MS Form and Attach to an Email
✅ How to Handle MS Form Response When a File Isn’t Uploaded
✅ How to Create an Email Key
✅ How to Send an Email to a Specific Recipient Based on Form Selection
✅ How to Create a Dynamic Output Based on Form Selection
----
SKIP AHEAD:
0:00 | Intro
0:46 | Group Forms vs OneDrive Forms
1:03 | File Upload Location
1:39 | Add File Upload Question to Form
2:16 | Build the Flow
4:52 | Get the File Upload Output
6:45 | Get Dynamic Content of File Uploads
9:06 | Group Your Actions
10:20 | Get the File Content
12:22 | Create a Dynamic File Name
19:07 | Collect Files to Attach
21:44 | When a File Isn’t Uploaded
23:32 | Send and Email
25:14 | Dynamic Output Based on Selection
28:22 | Replace the Trigger
SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 bit.ly/SubACreativeOpinion 👈
---
Teaching you how to make your workflows SUCK LESS.
Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.
Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.
Get curious. Be creative. Do better.
---
FOLLOW ME:
/ acreativeopinion
/ acreativeopinion
/ acreativeop
I love your style of teaching. So easy to follow. I would love to see one like this that includes an approval workflow before emailing the attachments.
Love this video. Simple yet very educative
Thank you so much for this video. easy to follow and use.
Amazing!
Very helpful! My flow worked perfectly the first time!
Thanks for watching!
Excellent ❤
You are my absolute favorite CZcamsr. I always learn so much and you have helped my productivity. Is there a video you have done that explains arrays? They confuse me
Thanks for watching! I haven't done a video on arrays specifically however many of my videos include working with arrays in the flow. Anytime a flow includes an Apply to Each action .. the Apply to Each action is used to loop though an array of items. In the meantime, you might find this tutorial on the Apply to Each action helpful: czcams.com/video/44Bk4JVMrD4/video.htmlsi=5Jx4A39eYyuyhcVa
THANK YOU! I was having trouble getting the file content for word documents - the item()?['link'] expression was only working for pdf, jpg, etc. not for word. Your method works perfectly!
Thanks for watching! Glad it you found the video helpful.
Hi instead of using the attachment in the email how do I add the link to view the picture in the sharepoint?
What other automations with Microsoft Forms are you looking to build? Let me know down below! 👇👇👇
Do you have a tutorial on adding form attachments to planner tasks?
I've tried following the above (which is great btw) but it doesn't look like its working the same way ...
Can you also please extend this to include the attachment in the Sharepoint list for each submission.
Thanks for watching! Please check out this tutorial: czcams.com/video/l9cK1HhbN3o/video.html
I keep getting an error trying to use ?[0] saying that the expression is invalid. Any help!?
nvm, I should of kept playing.
Changing the trigger to manual trigger for testing -> so smart.... I've wasted hours on this.
Thanks for watching!
I always build my flows with a manual trigger. Saves so much time when you don't need to leave the app!
Work smarter, not harder! 😉
Is anyone else having an issue with Sharepoint not being able to find the documents? I keep getting a File not found error message on this form.
Thanks for watching. It’s really hard to assist with troubleshooting specific issues in the comments. You need to ensure you are selecting the correct action to get the file. There are two Get File Content actions. Each action requires a different dynamic content to be used to get the file.
I would recommend posting in the Microsoft Power Automate Community: powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows
I got error on the second get file content "Action 'Get_file_content_using_path_2' failed: File not found clientRequestId: cf09af94-31c7-45bc-94bc-d3c2d5606408 serviceRequestId: a1233ba1-20db-0000-20c3-c97e961a9f52".