Another great video, Reza. This time, I actually created everything alongside as I was watching it. That hands-one practice actually embeds the knowledge even more as I've discovered. A strange thing I noticed though..... With the Training Survey Form (From a Group form), The Flow seemed to work only when I upload either an Image or PDF File. Once I added a Word or Excel File, it fails at the "Get the content using path" action... giving a file not found (404) error. it finds the image, PDF but couldn't find the Word/Excel file. What could be causing that? In the demo, you uploaded PDF's so you may not have noticed it or, I may be doing something wrong?? Will be interesting to find out your thoughts on that. Thanks again
You are spot on. It does not work for certain file types. Here is the fix. Use "get file content by path" SharePoint action. And for the path use the following expression: concat('YoursiteURL/Shared%20Documents/Apps/Microsoft%20Forms/Training%20Survey/Question/',item()?['name']) YoursiteURL - Your SharePoint Site URL Training%20Survey - Form Name
@@RezaDorrani What a relieve!! Stayed on it for a few hours just trying to figure it out until I tried the file combinations. I just thought I was missing something. Thanks for confirming.
@@RezaDorrani I tried the fix and this time, the Flow seems to be in perpetual "Running" mode. Was in that state for over 12min so had to cancel it. The files being uploaded are way below the Max size limit for each file as well. Just to reiterate; the concat(......expression) you provided as the fix should be the File Path's property value in the "Get the content using path" action within the Apply to each action, right?
@@dougydoe Max file size limits are hard limits and cannot be exceeded. The concat does not have any file path.Its your hardcoded doc library url and name of file which is dynamic.
I'm not the kind of person who is used to like and comment on videos but I had to surrender myself to this one because it helped me to solve a big problem related to this topic. Thank you very much for share this content we us!!! Like the video and follow you is the least we should do!
So timely. I spent time doing form attachments to both lists and email (in an approval request) but where mines was heavy at processing each attachment , including checking if null, Reza's code does it in 4-5 steps as opposed to mines which was 4 steps for each file processed. Guess whose spending time tonight to optimise his flow. Reza , you're brilliant.
Thank you SO much! This has been one of the most simple ways to do this. Other articles on the internet are much too complicated and I've used this many times. Thank you again!
This is THE best tutorial on how to handle Forms attachment in List. Thank you so, so much. I had spent countless hours trying to understand how to deal with optional or multiple Forms attachment, and this made it super easy. I managed to have the 4 different optional file uploads from my Forms saved to my List. Thank you, thank you, thank you!!!
Hello, can you please explain how you did this? Did you add 3 more fields for the respective documents in the condition? I have a document MS form with three different file upload dialogs and I'm having trouble realizing it. Thanks ;)
Thanks for all your videos! You have helped me so much in my career. This video ended a long search for a resolution of why my data wasn't uploading to SharePoint for all of my sites when they didn't add an attachment! You're the best! Keep them coming!
RUclips is amazing, I was having a very specific issue at work regarding form attachment and how to transfer them into a sharepoint list, and somehow, there's a really detailled and didactic video explaining every details of the process, walking me through the whole ordeal Thank you so much !
Great stuff! Your use of expressions to streamline the process is beautiful. As much as I practice, I really struggle with writing complex/compound expressions and nearly always resort to using a bunch of compose actions with much simpler formulas. Also, thanks for linking to my video on manipulating the file name to remove the submitter's name.
Great Videos from You both, Mates. Does @Chad's method also work to get rid of the wild Filname before the actual Filename? The attachment in MS Lists has the original Filename but in de SP Documentlibrary its kind of wild. Just as seen here: ruclips.net/video/K-hiDOPAG-4/видео.html in Minute 25:27 Also i am trying to find out, where exactly i need to put in the "Parse JSON"-Function in Rezas Workflow. Thanks so much for all your help.
What a fantastic video!! A genuine masterclass. Clear, structured, each grows on the next. The way you construct the flow is very intuitive - others say, "I'm going to create a variable, you'll see why later...". You say, "I need x but hold on, I need to loop through, so first I need to create a variable". This is far better for newbies that don't have that foresight yet. Brilliant! Quick question: in the Additional Documents demo, you created a condition to check whether Additional Documents was null before proceeding. Why not simply create varFiles and then append both Photos and Additional Documents to it? If the Additional Documents array is empty, it won't append anything to the varFiles array. No need for the conditional branch?
Thanks You for the awesome feedback David. Your point on the array being empty is right. I did a video on it earlier however for some reason the flow does not accept an empty array when calling the SharePoint actions. Hence those checks in the code.
Hey @davidadams421, can you please explain how you mean that? I have a document MS form with 3 different file upload dialogs and struggle with the logic. Thanks ;).
@@plcoin3355 Wow, this was a while back! I've slept since then!! If memory serves, in Reza's demo, he populated an array with a list of files, then checked whether additional files existed, if so, added them to the array. My point was he could just add everything to the array without the check, however this wouldn't work for the reasons he mentions.
This is unbelievable. I did a Google search for "microsoft forms store data from responses". This is the first returned video. It is crazy that this process is exactly what I needed. I have never had the first returned video ever be the perfect video for my needs. Wow. It covered both of my use cases - storing responses to my OneDrive and for a Group SharePoint. Thank you so much!
Thank you, Reza! I was able to use your very clear instructions to fix a critical flow which broke when my organisation changed an individually owned Microsoft form to a group form.
@@jordanseremy5763 The overall concept is that users fill in an MS Form with a mandatory photo upload question. The flow creates a new item in a SharePoint list, gets the attachments from the Team site Documents library and attaches them to the newly created item. Flow steps are: 1. Trigger is When a New Response is Submitted (add the form id as a custom value) 2. Add an Apply to Each loop, first action is Get Response Details. Second action is Create Item (SharePoint connector). 3. Add another Apply to Each loop to go get each attachment for the form from the Team site Document library. Output is json(outputs('Get_response_details')?[Dynamic content that relates to the upload question']). (11:21 to 11:46 in the vid). First action is Get content using path (SharePoint connector) with the site address being your Team site and the File Path being the expression Item()?['link'] (31: 58 to 32:05 in the vid). Second action is Add Attachment (SharePoint). id field is dynamic content ID (from the Create item property), File Name is expression item()?['name'] (12:20 to 13:04 in the vid) and File Content is expression body('Get_file_content_using-path'). Hope that helps!
Thank you Reza, once again you have successfully shown me how to solve a power automate puzzle where many others fail. I should have known to check your channel first. I am grateful for all the help you so generously provide. 🙏
Many thanks indeed Reza. I the begining I did not like very much your assertive way of speaking, but after getting used to it, your clear ste by step approach has help me a lot. I have seen many other power automate youtubers, and none of them was able to explain as well as you just did, following each step clearly, moving the scree slow enough to capture the formilas!!, just great!! Yes please if you set up a training portal, just le me know, happy to join!!
@@RezaDorrani Actually, I like this manner of expression (or "tone"). It is very focused on the key concepts that one needs to grasp, making the video concise yet fully edifying. It is quite evident that Reza invests a great deal time and effort in preparing each video, so that it demonstrates and conveys exactly the critical points necessary in the most economical way. This is in contrast to some RUclipsrs in this topic (whom I shall not name) who make videos where they babble on and on with low-value chit-chat for over an hour and just waste the viewer's time.
@@EMiller500 Thanks so much. I wish I could share how seriously I take each and every video I put out. My goal is to give value to the listener for every minute they watch. Spend hours editing to ensure there is no fluff.
Correction 24:30, when you paste the link of your doc lib into the code provided for View Document column, also change the "IncidentID" in the link with the column name you given into your doc library for referencing.
Thanks for this. I needed some quick help to show me how to handle attachments, so I had to skip to the relevant parts. But it was exactly what I needed. Awesome!
Man, you are a diamond! I love your videos. I would like to hear you advise on a topic on a case, however I am aware that you are most probably very busy. All the best for you Reza!
@@RezaDorrani I would like to have your opinion on a ticket system that I want to build almost like you. Each ticket/form should contain all informations for a material. A reviewer will either accept, reject the form or set it to status pending, because further information is needed for this form. Now my questions: 1. How can the requestor give the reviewer the information, that some of his requests (tickets) belong together? 2. Is it possible to create a MS form template or a copy of an older filled out form, where a bunch of fields are already filled out to make the filling out of the new request easier? 3. How to collect the missing information for the ticket, that is pending and how to connect it in the SharePoint list in order to have a history? Thank you for your response in advance!
Dear Reza. Thanks a lot for your service to human kind. You deserve a lot!! 2 questions 1. Can I rename the file so that my name is removed? 2. How do I get a unique url to the form submitted by user so that I will include the same in list item for anyone to access the filled form.
@@RezaDorrani question. I have an incident tracking form that creates a sharepoint list, following the steps you outlined in your video. One of the questions ask the user about the urgency of the issue being reported, so that our tech team knows how to properly respond. Instead of using high, medium, low, we've chosen to use human readable options, like "help me, everything isn't working". My question, is there a way to display the human readable version and then transform what they've selected back to a high, medium and low designation in the sharepoint list? Essentially I want the list to show high when the customer selects the form option "help me, everything isn't working".
Great instructive video as usual - one issue with myself though is that when I select the template to create the flow I don't get the same template as you - it doesn't have the 'Apply to each' section?
Hi Reza! Been watching and learning a lot from your videos and very thankful for your content. Do you know if there is any way to collect files from outside of your organization in any convenient way? I'm currently trying to collect information, including three pictures, from customers and add it all to a sharepoint list in as few steps on the customer side as possible. I cannot find a way to easily have the customer provide files of any kind via teams. I know you're a very busy guy, but any help would be greatly appreciated.
MS Forms supports files for internal users only. I am not aware of any other method. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Another awesome video! This is very similar to my current project, so your timing is impeccable! I am doing a faculty appointment form where the user has to upload verification documents. I added branching and a final document upload at the end. With this video, I can now go back and add multiple file uploads. Thank you so much!!!
Hola a todos! Primero que todo agradecer a Reza por su increíble video, me ayudó mucho. Tuve el error en el cuál la automatización se quedaba en un bucle perpetuo, solo paso a recordarles que primero que todo revisen los permisos de adjuntar archivos de su lista de SharePoint, pase horas investigando y probando diversas maneras y simplemente era ese permiso. 😁
Your a star and make it look so easy, mind you I have used a lot of your videos to get my head around things. So well explained and thank not just for this video but all the others, please don't ever stop we need you
Vide description has link to download sample flow. You can check the code there. As for your issue, I will have to look at your flow in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
This was really helpful. Just getting started with Power Automate etc. and Reza laid it out very clearly, especially the attachments part which was really complex in some examples
Thank you very much for your great Videos. I've learned a lot. I wonder if it is necessary to do the "get content using path" to add option attachment(s) to email? My form is not a group form and I can't get the path right. FYI, my path has another language mixed with English and therefore, it converted into a very long line of letter.
Most welcome! Its a been a while since I did this video & hence do not remember if a step is necessary or not. I recommend posting your query on forums in case someone has a workaround for the language mix issue powerusers.microsoft.com
2 года назад+1
Thanks for sharing 🙏 As always a ton of great tips and clear guidelines.
Amazing video - It's so great to learn the way you explained the smoothness while creating so many loops in power automate. I have a similar kind of task to link MS form (with almost multiple branching questions and almost 10 attachment questions comprising of 48 questions) to azure in a way that I can create work items directly per the responses received. thank you for this video it is quite beneficial.
Thank you for this, it was a great help! I am running into an issue however with emailing more than one attachment from different different forms upload questions. How do I route more than 1 question attachment to email?
You can collect all attachments in a variable and then send it in email. I do not have a video reference on it though hence only the idea. You can try checking on forums in case someone has done something similar powerusers.microsoft.com
You would need to repeat the steps for the attachments step, multiple times in flow. I do not have a specific video on it though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great video! Since MS Lists does not allow multiple attachment columns that would help with categorizing file uploads, how would you use Power Automate to grab each file from MS Lists and add them to separate categorized folders within a SharePoint document library? Thanks!
@RezaDorrani Thank you so much for your prompt and kind reply. I'm new to flows, but I will look for the "Upload Files to Folders" flow as you've referenced. Thank you.
Great video, thanks so much and just what I needed. After the step where the uploaded files are saved to the sharepoint library (from the list) I then want to email them as attachments. Can this follow on from the flow at that point? The bit in your video about sending email is a different scenario. Many thanks.
Hi Reza, this is a great video, thank you. I am not an IT person and tried following your guidance step-by-step, but hit a wall and thought to reach out. The example you're using in your video is very simple, but I have a form with 50 questions, including 12 attachments. All I need is to achieve that the Sharepoint list records attachments against an entry so that the attachment show in the pane that opens up when you double click on any sharepoint list entry. However, I followed your example and I only achieved that the first of the mandatory attachment and the first of the optional attachment are attached, but not the rest. What additional steps would I need to add to the Flow so that all mandatory and optional attachments show in my sharepoint list? Any guidance would be much appreciated.
Thank you Reza 🙏 for your content. Please I need some help... I try to upload files to a folder to create in SharePoint and name it with a specific response from a Form. Thanks again 👍
Welcome! I don’t think I have done a specific video on this. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
This is excellent, very detailed - question - is it possible to print the form - with a print control upon a completion of the form - the point when you get a screen the survey is completed. In a Healthcare environment discrete data definitely required for reporting but we need to give hard copy of the form to patients/employees
Awesome video as usual🤝. Big fan of useful hacks that you cover in your content (providing link of document using list formatting , just excellent !!) - THANK YOU
Thank you very much for this video! I was attempting to duplicate everything, as this is exactly what I need. Yesterday things appeared exactly as in your video, but this evening when I went to finish the flow, there is no longer a dynamic content box. There are selections below the input box now, but no way to enter a JSON expression. Have you seen this? Do you have any way to let us know what that step looks like now? Any insight would be greatly appreciated! Thank you!
Most welcome. I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@RezaDorrani I found the issue. I had the screen split so I could work on the automation while watching the video. In the smaller screen size it shows what I am guessing is a tablet sized view which doesn't have the options pop out to the right side, but rather show a large amount of options under the input box (where it says "the unique identifier of the file") but does not have any way to enter the Expression (json() anything). I'll just expand the window back to desktop size to finish. Sorry about the confusion.
This was awesome. Thank you! Subscribed and liked for this one video alone. Question I have now is the flow fails if there are no attachments. How do I resolve?
ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_attachment' failed: the result of the evaluation of 'foreach' expression '@json(outputs('Get_response_details')?['body/r5a05f5af2652402e8bb634c03c04c39a'])' is of type 'Null'. The result must be a valid array.
Reza, this is awesome, love your tutorials. I struggle though with a specific scenario - my job ends up failing when I don't have a photo attachment. My photo attachment is optional, but I'm not sure how to add the conditional statement. How do I get around this? My solution is exactly the same as your up to 13:18 of your tutorial.
There have been a few comments on this one. Idea would be to perform a null check inside of flow. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza! First of all thank you for this amazing flow. It works great in the onedrive environment. I have a question if the form lives in ashared sharepoint environment. I thought in that case I would use the "get file content" function with sharepoint, and my flow would work. But that has not been the case. I have not been able to find the file ID in my sharepoint site. and that is very strange since I can locate the file in the sharepoint directory. I would appreciate your time and assistance on this. Thanks in advance.
Most welcome! I did this video a while ago and have not run into any issues with SharePoint hosted forms. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
For anyone else who may be having trouble with getting attachments to open properly, make sure that there are no quotes around the second part of the ContentBytes property after the colon (33:24). I had tried all kinds of encoding and decoding on the file content, but still none of the attachments were opening properly. It wasn't until I had the dynamic file content without quotes that the files were attaching properly.
Hi Reza, great explanation and it is wonderful for you to break it into steps by steps. I really enjoyed it and it helps me a lot. I wonder if instead the response save into the sharepoint list, can the steps you mentioned be use if I want to save the response into the Excel file located in the sharepoint?
@@RezaDorrani thank you for your respond. What will happen if the owner of the form leave the company or the account become inactive? Would this be affecting the flow?
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Another great video, Reza. This time, I actually created everything alongside as I was watching it. That hands-one practice actually embeds the knowledge even more as I've discovered. A strange thing I noticed though..... With the Training Survey Form (From a Group form), The Flow seemed to work only when I upload either an Image or PDF File. Once I added a Word or Excel File, it fails at the "Get the content using path" action... giving a file not found (404) error. it finds the image, PDF but couldn't find the Word/Excel file. What could be causing that? In the demo, you uploaded PDF's so you may not have noticed it or, I may be doing something wrong?? Will be interesting to find out your thoughts on that. Thanks again
You are spot on. It does not work for certain file types.
Here is the fix.
Use "get file content by path" SharePoint action.
And for the path use the following expression:
concat('YoursiteURL/Shared%20Documents/Apps/Microsoft%20Forms/Training%20Survey/Question/',item()?['name'])
YoursiteURL - Your SharePoint Site URL
Training%20Survey - Form Name
@@RezaDorrani What a relieve!! Stayed on it for a few hours just trying to figure it out until I tried the file combinations. I just thought I was missing something. Thanks for confirming.
@@dougydoe Thank You for highlighting this!
@@RezaDorrani I tried the fix and this time, the Flow seems to be in perpetual "Running" mode. Was in that state for over 12min so had to cancel it. The files being uploaded are way below the Max size limit for each file as well.
Just to reiterate; the concat(......expression) you provided as the fix should be the File Path's property value in the "Get the content using path" action within the Apply to each action, right?
@@dougydoe Max file size limits are hard limits and cannot be exceeded.
The concat does not have any file path.Its your hardcoded doc library url and name of file which is dynamic.
Spent half a day trying to get this working with other vids, only took 15min once I found yours. Bravo sir!
Perfect!
I'm not the kind of person who is used to like and comment on videos but I had to surrender myself to this one because it helped me to solve a big problem related to this topic. Thank you very much for share this content we us!!! Like the video and follow you is the least we should do!
Thank You so much for the appreciation!
So timely. I spent time doing form attachments to both lists and email (in an approval request) but where mines was heavy at processing each attachment , including checking if null, Reza's code does it in 4-5 steps as opposed to mines which was 4 steps for each file processed. Guess whose spending time tonight to optimise his flow.
Reza , you're brilliant.
Thanks for sharing your scenario, Manish. So glad to hear the technique showcased in video is effective. Good luck with improving your flow :)
Thank you SO much! This has been one of the most simple ways to do this. Other articles on the internet are much too complicated and I've used this many times. Thank you again!
You're very welcome!
The reason I made this video were the other articles :)
This is THE best tutorial on how to handle Forms attachment in List. Thank you so, so much. I had spent countless hours trying to understand how to deal with optional or multiple Forms attachment, and this made it super easy. I managed to have the 4 different optional file uploads from my Forms saved to my List. Thank you, thank you, thank you!!!
You are most welcome Veronique!
Thank You so much for the awesome feedback.
Means a lot.
Hello, can you please explain how you did this? Did you add 3 more fields for the respective documents in the condition? I have a document MS form with three different file upload dialogs and I'm having trouble realizing it.
Thanks ;)
@@plcoin3355 same question here how to handle 3 or more document upload question :)
Thanks for all your videos! You have helped me so much in my career. This video ended a long search for a resolution of why my data wasn't uploading to SharePoint for all of my sites when they didn't add an attachment! You're the best! Keep them coming!
Thank You so much!
Best tutorial for handling attachments. Reza has thought of many different scenarios and has clearly shown how to handle each one. Bravo!
Glad it was helpful!
Clearly not excel attachments though 🙄
RUclips is amazing, I was having a very specific issue at work regarding form attachment and how to transfer them into a sharepoint list, and somehow, there's a really detailled and didactic video explaining every details of the process, walking me through the whole ordeal
Thank you so much !
You’re most welcome
Great stuff! Your use of expressions to streamline the process is beautiful. As much as I practice, I really struggle with writing complex/compound expressions and nearly always resort to using a bunch of compose actions with much simpler formulas. Also, thanks for linking to my video on manipulating the file name to remove the submitter's name.
Thank you very much and your video on file naming is very good!
Great Videos from You both, Mates. Does @Chad's method also work to get rid of the wild Filname before the actual Filename? The attachment in MS Lists has the original Filename but in de SP Documentlibrary its kind of wild. Just as seen here: ruclips.net/video/K-hiDOPAG-4/видео.html in Minute 25:27
Also i am trying to find out, where exactly i need to put in the "Parse JSON"-Function in Rezas Workflow. Thanks so much for all your help.
I watched this in 1.5 speed and bang! I got more than I asked for. Fantastic tutorial! Thank you!!!
Thanks Jay
What a fantastic video!! A genuine masterclass. Clear, structured, each grows on the next. The way you construct the flow is very intuitive - others say, "I'm going to create a variable, you'll see why later...". You say, "I need x but hold on, I need to loop through, so first I need to create a variable". This is far better for newbies that don't have that foresight yet. Brilliant! Quick question: in the Additional Documents demo, you created a condition to check whether Additional Documents was null before proceeding. Why not simply create varFiles and then append both Photos and Additional Documents to it? If the Additional Documents array is empty, it won't append anything to the varFiles array. No need for the conditional branch?
Thanks You for the awesome feedback David.
Your point on the array being empty is right. I did a video on it earlier however for some reason the flow does not accept an empty array when calling the SharePoint actions. Hence those checks in the code.
Hey @davidadams421, can you please explain how you mean that? I have a document MS form with 3 different file upload dialogs and struggle with the logic.
Thanks ;).
@@plcoin3355 Wow, this was a while back! I've slept since then!! If memory serves, in Reza's demo, he populated an array with a list of files, then checked whether additional files existed, if so, added them to the array. My point was he could just add everything to the array without the check, however this wouldn't work for the reasons he mentions.
This is unbelievable. I did a Google search for "microsoft forms store data from responses". This is the first returned video. It is crazy that this process is exactly what I needed. I have never had the first returned video ever be the perfect video for my needs. Wow. It covered both of my use cases - storing responses to my OneDrive and for a Group SharePoint. Thank you so much!
Thanks to Google :)
Glad to hear the video covers most scenarios. Thank You so much for watching.
Finally, instructions that do work. Thank you Sr!
You're most welcome
Bro you're the best
Thanks bro
Thank you, Reza! I was able to use your very clear instructions to fix a critical flow which broke when my organisation changed an individually owned Microsoft form to a group form.
You're most welcome!
hey how did you make it run with the Group Forms???
@@jordanseremy5763 The overall concept is that users fill in an MS Form with a mandatory photo upload question. The flow creates a new item in a SharePoint list, gets the attachments from the Team site Documents library and attaches them to the newly created item. Flow steps are:
1. Trigger is When a New Response is Submitted (add the form id as a custom value)
2. Add an Apply to Each loop, first action is Get Response Details. Second action is Create Item (SharePoint connector).
3. Add another Apply to Each loop to go get each attachment for the form from the Team site Document library. Output is json(outputs('Get_response_details')?[Dynamic content that relates to the upload question']). (11:21 to 11:46 in the vid). First action is Get content using path (SharePoint connector) with the site address being your Team site and the File Path being the expression Item()?['link'] (31: 58 to 32:05 in the vid). Second action is Add Attachment (SharePoint). id field is dynamic content ID (from the Create item property), File Name is expression item()?['name'] (12:20 to 13:04 in the vid) and File Content is expression body('Get_file_content_using-path').
Hope that helps!
I wish I could give you more upvotes. I automatically upvote your videos as they start because I know I will learn something.
Wow! Thank You Grant
Thank you Reza, once again you have successfully shown me how to solve a power automate puzzle where many others fail. I should have known to check your channel first. I am grateful for all the help you so generously provide. 🙏
Most welcome
Reza actually inspires confidence and trust. When autoplay is on and I come across one of his videos, I know to put my food down and pay attention.
Thanks so much. I hope to keep working hard and provide valuable content. Its all about maintaining the trust.
My goodness! Another dynamic video! I learn something every week from you, Reza. Please keep the videos coming.
Thanks so much.
Video description has link to download sample flow. Give that a try.
@@RezaDorrani, I did figure it out. Thank you so much.
Thank you reza, all your power automate tutorial is really helpful. The least I can do is subscribing and giving like. Cheers
Hey, thanks so much.
Appreciate the sub.
Thank you for this very instructive video
I managed to complete a project only 10 days after discovering power automate.
Awesome
Thanks so much! Solved an afternoon of troubleshooting in 10 mins!
Great to hear!
Many thanks indeed Reza. I the begining I did not like very much your assertive way of speaking, but after getting used to it, your clear ste by step approach has help me a lot. I have seen many other power automate youtubers, and none of them was able to explain as well as you just did, following each step clearly, moving the scree slow enough to capture the formilas!!, just great!! Yes please if you set up a training portal, just le me know, happy to join!!
Thank You Emilio for the excellent feedback! I will try my best to get rid of that assertive tone. Hopefully improving video by video.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ruclips.net/user/rezadorranijoin
@@RezaDorrani Actually, I like this manner of expression (or "tone"). It is very focused on the key concepts that one needs to grasp, making the video concise yet fully edifying. It is quite evident that Reza invests a great deal time and effort in preparing each video, so that it demonstrates and conveys exactly the critical points necessary in the most economical way. This is in contrast to some RUclipsrs in this topic (whom I shall not name) who make videos where they babble on and on with low-value chit-chat for over an hour and just waste the viewer's time.
@@EMiller500 Thanks so much. I wish I could share how seriously I take each and every video I put out. My goal is to give value to the listener for every minute they watch.
Spend hours editing to ensure there is no fluff.
Wow rezza. This video is kinda like a lemon cake for me. it's delicious. I'm so impressed. You're a genius
Wow, thank you so much!
Hi Reza - Thank you for this really great step-by-step tutorial. This was great!!!
You're very welcome!
Easy explanation of many different use scenarios, much appreciated.
Glad to hear that! Thanks for watching.
Correction 24:30, when you paste the link of your doc lib into the code provided for View Document column, also change the "IncidentID" in the link with the column name you given into your doc library for referencing.
Thanks for the tip
Yes, I was using "problemID". Just replaced and all performed well! Thanks, Reza!
Following this tutorial made me do a happy dance every time something worked on the first try 🎉 thank you Reza!!
You're so welcome! Makes me happy to know that the video is helping others
Brilliant, thank you. It's taken me hours to try and do this. Without your help I couldn't have done it.
You are most welcome!
Thank you very much! Great explanations, and the walk thru was the perfect pace! You've saved me yet again!!!
Most welcome
Thanks for this. I needed some quick help to show me how to handle attachments, so I had to skip to the relevant parts. But it was exactly what I needed. Awesome!
Glad it helped!
Thank you Reza! Your videos are very clear and covers various scenarios. It helped me a lot. Thank you so much!❤
You're most welcome
Man, you are a diamond! I love your videos. I would like to hear you advise on a topic on a case, however I am aware that you are most probably very busy. All the best for you Reza!
Thanks so much.
Busy - Yes.
As long as the question is around the video, feel free to post it here.
@@RezaDorrani I would like to have your opinion on a ticket system that I want to build almost like you. Each ticket/form should contain all informations for a material. A reviewer will either accept, reject the form or set it to status pending, because further information is needed for this form. Now my questions:
1. How can the requestor give the reviewer the information, that some of his requests (tickets) belong together?
2. Is it possible to create a MS form template or a copy of an older filled out form, where a bunch of fields are already filled out to make the filling out of the new request easier?
3. How to collect the missing information for the ticket, that is pending and how to connect it in the SharePoint list in order to have a history?
Thank you for your response in advance!
@@michael_wellington This is more of project requirements :)
I would recommend posting your queries one by one on forums powerusers.microsoft.com
@@RezaDorrani Thanks dear!
your content is golden and scary comprehensive. you are god send my friend !
Wow, thank you!
Hi ReZa! love how your video is always packed with knowledge and various scenarios! Thanks for this guide, i will be useful for my organisation!❤
Glad to hear that!
You always be the best teacher for me , Thank you again
Thanks so much
You Reza.. you are a genius... !!! Super fan of yours..!!
Thanks so much
Thanks!
Thank You
I learn much more knowledge for adapt and improve my work. Thank you and please more clip!
Thanks so much. A lot more to come!
wonderful step by step video, everybody is able to follow, even me!!!! thanks so much
You are most welcome! Thank You for watching.
@@RezaDorrani please, keep on creating such great videos. Thanks
@@valeriafilolungo2187 I will keep trying my best
Amazing! I appreciate your video and taking the time to show us. Thank you so much - it worked perfectly!
You're most welcome!
Dear Reza. Thanks a lot for your service to human kind. You deserve a lot!!
2 questions
1. Can I rename the file so that my name is removed?
2. How do I get a unique url to the form submitted by user so that I will include the same in list item for anyone to access the filled form.
Thanks so much!
Check my latest video on forms. It may help answer your questions - ruclips.net/video/Aerky9hiYDo/видео.html
Thanks a lot ❤
Fantastic job with this video! Very helpful! Thank you!
Most welcome
This helped me so much! Thank you so much for putting the time into making this tutorial!
You're most welcome!
@@RezaDorrani question. I have an incident tracking form that creates a sharepoint list, following the steps you outlined in your video. One of the questions ask the user about the urgency of the issue being reported, so that our tech team knows how to properly respond. Instead of using high, medium, low, we've chosen to use human readable options, like "help me, everything isn't working". My question, is there a way to display the human readable version and then transform what they've selected back to a high, medium and low designation in the sharepoint list? Essentially I want the list to show high when the customer selects the form option "help me, everything isn't working".
@@kylee5033 Possible. Write if condition in flow to check the value in form and accordingly set value in SP list.
@@RezaDorrani Awesome! Thanks again for the help!
Great instructive video as usual - one issue with myself though is that when I select the template to create the flow I don't get the same template as you - it doesn't have the 'Apply to each' section?
Video description has link to download sample flow. You can try that.
Hi Reza!
Been watching and learning a lot from your videos and very thankful for your content. Do you know if there is any way to collect files from outside of your organization in any convenient way? I'm currently trying to collect information, including three pictures, from customers and add it all to a sharepoint list in as few steps on the customer side as possible. I cannot find a way to easily have the customer provide files of any kind via teams. I know you're a very busy guy, but any help would be greatly appreciated.
MS Forms supports files for internal users only. I am not aware of any other method. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
This was perfect and solved my problem. Very easy to follow! Thank you!
Great to hear!
Another awesome video! This is very similar to my current project, so your timing is impeccable! I am doing a faculty appointment form where the user has to upload verification documents. I added branching and a final document upload at the end. With this video, I can now go back and add multiple file uploads. Thank you so much!!!
Glad it was helpful! Thanks for sharing your scenario. Good luck!
Outstanding video, thank you for sharing. It helped me greatly.
Glad it helped!
Thank you so much for step-by-step explanation! I was looking for the same use-case. Thanks again!! Great Content!!
You’re most welcome
Worked like a charm, Reza thank you for all the time you put into these videos. You are a champ.
You are most welcome. Thank You for watching.
Great session. Very useful 🙂
Glad it was helpful!
Awesome video!! Very helpful. I am just learning this stuff. Thank you!
Great! Thanks Mark.
Wish you the best in your learnings
Hola a todos! Primero que todo agradecer a Reza por su increíble video, me ayudó mucho. Tuve el error en el cuál la automatización se quedaba en un bucle perpetuo, solo paso a recordarles que primero que todo revisen los permisos de adjuntar archivos de su lista de SharePoint, pase horas investigando y probando diversas maneras y simplemente era ese permiso. 😁
Thanks for sharing.
Excellent Reza, your content is awesome
Thank you so much!
This information is golden. Thanks a lot.
Most welcome
These videos are perfect. Thank you so much
Glad you like them!
Your a star and make it look so easy, mind you I have used a lot of your videos to get my head around things. So well explained and thank not just for this video but all the others, please don't ever stop we need you
Wow, thank you! Il try my best to keep going!
As always Reza there are nuggets of information i hadn't even thought of. Thanks so much !
Awesome! Glad to hear that. Thanks for watching.
Excellent tutorial. Thank You!
Most welcome
a year leater, it still works. Thanks!!
Glad to hear
Build works perfectly, I just require that link for the json code mentioned at 24:08, if its not to much trouble to provide
I believe link to download all artifacts should be in video description
Thanks for making it easy @reza. You are my new favorite.
Awesome!
Now no more changing favorites :)
Thank you for the detailed video. I might be missing something where is the JSON code mentioned in SharePoint List Formatting?
Vide description has link to download sample flow. You can check the code there.
As for your issue, I will have to look at your flow in action to know the cause of your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I got the code from your Github.👍
Reza, You are a rock star. This video really helped me.
Happy to hear that
This was really helpful. Just getting started with Power Automate etc. and Reza laid it out very clearly, especially the attachments part which was really complex in some examples
Glad to hear that
Thank you very much for your great Videos. I've learned a lot. I wonder if it is necessary to do the "get content using path" to add option attachment(s) to email? My form is not a group form and I can't get the path right. FYI, my path has another language mixed with English and therefore, it converted into a very long line of letter.
Most welcome!
Its a been a while since I did this video & hence do not remember if a step is necessary or not.
I recommend posting your query on forums in case someone has a workaround for the language mix issue
powerusers.microsoft.com
Thanks for sharing 🙏 As always a ton of great tips and clear guidelines.
Glad it was helpful!
Awesome! Thank you so much for this guide...
Most welcome
Amazing video - It's so great to learn the way you explained the smoothness while creating so many loops in power automate. I have a similar kind of task to link MS form (with almost multiple branching questions and almost 10 attachment questions comprising of 48 questions) to azure in a way that I can create work items directly per the responses received. thank you for this video it is quite beneficial.
Glad it was helpful!
+10. Greetings from Costa Rica. this video is great!
Thanks so much
Super reza fantastic idea 💡 👏 👍 👌
Thank you! Cheers!
Thank you for this, it was a great help! I am running into an issue however with emailing more than one attachment from different different forms upload questions. How do I route more than 1 question attachment to email?
You can collect all attachments in a variable and then send it in email. I do not have a video reference on it though hence only the idea. You can try checking on forums in case someone has done something similar powerusers.microsoft.com
Amazing. it's been a while since I've had a very deep and thorough tutorial. Nothing like this. good luck to you sir and thank you!
Thank You so much for the amazing feedback.
Great video!! Help me a lot. And about two or more question type with attachments in forms? and saved in list? How i can do this? Tks
You would need to repeat the steps for the attachments step, multiple times in flow. I do not have a specific video on it though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great video! Since MS Lists does not allow multiple attachment columns that would help with categorizing file uploads, how would you use Power Automate to grab each file from MS Lists and add them to separate categorized folders within a SharePoint document library? Thanks!
There are actions in flow to do that which is upload files to folders. Try using those.
I don’t have a specific video reference on this scenario
@RezaDorrani Thank you so much for your prompt and kind reply. I'm new to flows, but I will look for the "Upload Files to Folders" flow as you've referenced. Thank you.
Thank you for this great video, very helpful.
Most welcome
Reza, you are amazing! You continue to impress :)
Thanks man
Great video, thanks so much and just what I needed. After the step where the uploaded files are saved to the sharepoint library (from the list) I then want to email them as attachments. Can this follow on from the flow at that point? The bit in your video about sending email is a different scenario. Many thanks.
Yes that is possible. I do not have a video reference on it though.
Awesome video as usual, great effort 👌
Thank You
Hi Reza, this is a great video, thank you. I am not an IT person and tried following your guidance step-by-step, but hit a wall and thought to reach out. The example you're using in your video is very simple, but I have a form with 50 questions, including 12 attachments. All I need is to achieve that the Sharepoint list records attachments against an entry so that the attachment show in the pane that opens up when you double click on any sharepoint list entry. However, I followed your example and I only achieved that the first of the mandatory attachment and the first of the optional attachment are attached, but not the rest. What additional steps would I need to add to the Flow so that all mandatory and optional attachments show in my sharepoint list? Any guidance would be much appreciated.
For optional attachments scenario I did a separate video
Here it is ruclips.net/video/Aerky9hiYDo/видео.htmlsi=52VSvVrAvPtX22v2
Thanks again! You’ve got very good kit!
Most welcome!
Thank you Reza 🙏 for your content. Please I need some help... I try to upload files to a folder to create in SharePoint and name it with a specific response from a Form. Thanks again 👍
Welcome!
I don’t think I have done a specific video on this. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Ok. Thank you 👍
This is excellent, very detailed - question - is it possible to print the form - with a print control upon a completion of the form - the point when you get a screen the survey is completed. In a Healthcare environment discrete data definitely required for reporting but we need to give hard copy of the form to patients/employees
Check ruclips.net/video/4eWGdi_C2hQ/видео.html
I think I show how to generate PDF which can be printed :)
great video. microsoft should make this much more simple and no-code since it's such a common use case in my opinion
Hopefully, it gets simpler
4/9/2024 this flow still work well. Thanks for your video, Reza
It stood the test of time
This is amazing. If only MS Forms allowed "external" users to submit attachments. Huge limitation. Any workarounds would be greatly appreciated
Thanks!
I am not aware of any workarounds to allow external users to submit attachments via MS Forms
Awesome video as usual🤝. Big fan of useful hacks that you cover in your content (providing link of document using list formatting , just excellent !!) - THANK YOU
Glad you like them!
Thank you very much for this video! I was attempting to duplicate everything, as this is exactly what I need. Yesterday things appeared exactly as in your video, but this evening when I went to finish the flow, there is no longer a dynamic content box. There are selections below the input box now, but no way to enter a JSON expression. Have you seen this? Do you have any way to let us know what that step looks like now? Any insight would be greatly appreciated! Thank you!
Most welcome.
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@RezaDorrani I found the issue. I had the screen split so I could work on the automation while watching the video. In the smaller screen size it shows what I am guessing is a tablet sized view which doesn't have the options pop out to the right side, but rather show a large amount of options under the input box (where it says "the unique identifier of the file") but does not have any way to enter the Expression (json() anything). I'll just expand the window back to desktop size to finish. Sorry about the confusion.
@@WendyWestbrook No worries
This was awesome. Thank you! Subscribed and liked for this one video alone. Question I have now is the flow fails if there are no attachments. How do I resolve?
ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_attachment' failed: the result of the evaluation of 'foreach' expression '@json(outputs('Get_response_details')?['body/r5a05f5af2652402e8bb634c03c04c39a'])' is of type 'Null'. The result must be a valid array.
Thanks for the sub!
If no attachments, watch this ruclips.net/video/Aerky9hiYDo/видео.htmlsi=sWI48tDBe8WoQOUZ
Thank you so much! If both of the document fields are mandatory, do you not have to add the condition?
Which condition?
If doc fields are NOT mandatory, then condition would be needed. I have done a video on that as well
Reza, this is awesome, love your tutorials. I struggle though with a specific scenario - my job ends up failing when I don't have a photo attachment. My photo attachment is optional, but I'm not sure how to add the conditional statement. How do I get around this? My solution is exactly the same as your up to 13:18 of your tutorial.
There have been a few comments on this one. Idea would be to perform a null check inside of flow. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza! First of all thank you for this amazing flow. It works great in the onedrive environment. I have a question if the form lives in ashared sharepoint environment. I thought in that case I would use the "get file content" function with sharepoint, and my flow would work. But that has not been the case. I have not been able to find the file ID in my sharepoint site. and that is very strange since I can locate the file in the sharepoint directory. I would appreciate your time and assistance on this. Thanks in advance.
Most welcome!
I did this video a while ago and have not run into any issues with SharePoint hosted forms.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thank for sharing. One of the best. keep it up.
Most welcome
Thanks
Thank You
Thank you for sharing information.
Most welcome
For anyone else who may be having trouble with getting attachments to open properly, make sure that there are no quotes around the second part of the ContentBytes property after the colon (33:24). I had tried all kinds of encoding and decoding on the file content, but still none of the attachments were opening properly. It wasn't until I had the dynamic file content without quotes that the files were attaching properly.
Thanks for sharing
Hi Reza, great explanation and it is wonderful for you to break it into steps by steps. I really enjoyed it and it helps me a lot. I wonder if instead the response save into the sharepoint list, can the steps you mentioned be use if I want to save the response into the Excel file located in the sharepoint?
Most welcome!
Possible but I do not have a specific video reference on it.
@@RezaDorrani thank you for your respond. What will happen if the owner of the form leave the company or the account become inactive? Would this be affecting the flow?
@@mohdkhairilakub8064 Typically the form owner would need to add you as co-owner.
Excellent explanation
Thank You