After going through 10+ forums Reponses and multiple different ways of trying to get Multiple Choice Values into SP List. this is the best and easiest way to do that. I've watched a few of your videos now and they are all amazing. Thank you Reza!
@@RezaDorrani How will this work if there are more than one multi-choice questions? Adding Compose - Select step for each multi-choice question does not seem to be working.
YES THANK YOU SO MUCH! I've watched a lot of other videos trying to get my Choice columns and attachments working but didn't get it right until this one.
My first ‘real’ flow was doing exactly this and the attachments were a real pain to figure out, wish this video was around then, you made it so much easier, but I have to say that’s mainly because of your excellent video that talks about JSON which when you start to understand makes Power Automate and Expressions make so much more sense. Another great video, every flow I make is better because of watching your videos, you’d definitely get top marks if I was filling out your survey 😊
Every time I get feedback I feel this is my best one to date. I have that same feeling right now 😊 Thank you for watching as always and hope to keep the momentum flowing.
Hi I found your better than most of the tutorial online but it is not easy to understand without visually knowing what am i aiming for or what i will achieve which makes it only for people who already familiar with the platform and not for people who have just begun will get lost and leave even though they can easily do it after following and understanding the reason behind it.
Thanks Hardik. Some videos are designed keeping beginners in mind while others are meant to cover a specific use case which does require some understanding of the tools. My goal for my videos is to keep it concise & simple to understand (true for most of my new videos). I also try to share the code (App/Flow) along with the video when possible.
@@RezaDorrani Thank you I would like to know do you have entry level for power platform tutorial that will allow me to learn without getting overwhelm by so many features and possibilities.
@@hardikgalaiya8834 I have playlists on my channel for beginners. I am working on training content for beginners. It will be out in the next few months.
This is absolutely amazing! thank you Reza for all the incredible content you create, I hope my TH-cam channel can someday be at least half great as yours!
Hi Reza, just want to say you are the best. I have learned a lot from you and your videos have helped me in my current role. Your videos are the best and just awesome. Thanks for all the content. You should add a Donate button on your channel :)
Wow, thank you for your kind words. I am working on my training content which will be out in Q1 2022 & that would be a paid subscription. I hope many join me there as I plan to truly go all out with content ranging from beginner to advanced.
This is a fantastic video and has made this a lot easier for a beginner. Thank you. Would you be able to provide instructions on how to add a second attachment questions and pass the upload through to lists. I have tried and tried with no luck. It is probably very simple.
Thanks for watching and liking the video. I do not have a video reference for multiple attachments. I can add the request to my backlog but chances of video being made is low as I would need a lot more folks requesting this topic. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Appreciate you doing the video!!! I am just fed up with office and Microsoft....just when ya think ya learned something they change it so now ya even more confused
Change is the only constant in this world :) Changes should not impact existing Apps/flows. If any change has broken your existing solution, you can raise a ticket with MSFT or highlight that on the forums at powerusers.microsoft.com/
Got this working, thanks a lot for your continuous effort, Reza. One question though, on my form attachments aren't required. When a submission gets made without an attachment(which is okay and will happen mostly) the flow runs and I get a new Sharepoint item...BUT Power Automate sees it as a failed run, I could launch it like this, but I don't want to run in the issue of the flow stopping due to a lot of failed runs. Can you send me somewhere to understand how to solve this?
@@RezaDorrani getting this: The execution of template action 'Apply_to_each_file' failed: the result of the evaluation of 'foreach' expression '@outputs('Files')' is of type 'Null'. The result must be a valid array. I know what it means, not how to solve it.:-)
Really good one.. I watched so many video and yours did help on the attachment. If possible, see if you can just slow down a bit. I need to pause in order to capture what you typed :P
Glad it was useful. Thanks for watching Tommy. I will work on slowing down or pausing for a moment after I type or show code. Thank you for the feedback.
Hello Reza, Thanks for great step by step tutorial! I have question, if I want to leave the upload file as an option, it gives me fail in flow when no attachment. Can we make it go next action regardless of file exists? Thank you!
Very nice presentation. Thank you a lot. Using a SharePoint based Forms I got a pb with attached files Excel or Word. I cannot display them. PDF files got no problem. Have you got a tip to fix that ?
Hi Reza, thanks for this amazing content. But I tried using a group form instead and if I swap out the one drive steps with sharepoint - Get file content and do what you have done here it keeps failing. Any idea how to fix that? It can't find the files. "Action 'Get_file_content' failed". Thanks!
Thanks so much! But this is what I get if I try to add a variable in the "Apply to each file" loop. "The operation 'Initialize variable' can only be used at top level."
@@RezaDorrani aah please excuse my ignorance but I'm trying to start this step after the 'Create item' step in your 'Power Automate Microsoft Forms Connector tutorial with Attachments' video. The idea is to pull attachment files from group forms in sharepoint, on to the sharepoint list. I'm not sure at what level I should initialize variable. Because if I create a loop after that I don't have any of my dynamic content available for the json expression. Thanks for bearing with me.
@@omermirza5994 It is difficult to understand here on chat. I would recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com/
Thank you ever so much Reza, my saviour! May I bother with a question? "Move Multi choice answers in Forms to SharePoint multi select choice column", the flow does not work if none is selected. Do you know a way to make it work when the selection is null? Thank you!
You would probably need to write an expression to perform the null check in flow. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Video was great - well explained. My form has 6 choice questions where user can input more then one answer or no answer if the question is not valid for them. When running the flow it works great when multiple answers are picked but fails when no answer is picked. Any thoughts?? I was thinking of using a control action but I would have to do that 6 times.
Thank you for watching and thanks for the feedback. I am working on trying to slow down. Hopefully improving video by video :) Meanwhile YT has a feature where you can change the watch speed. Slow it down to 0.75 and see if it works for you.
thank you very much for your video! I have a question. I have a form where the user can upload 1 attachment or 3 attachments. Unfortunately the flow does not work in this case, I have this error: The execution of the 'Apply_to_all' action of the model failed. The result of evaluating the expression 'foreach' '@outputs (' compose_output_ buffer ')' is of type 'Null'. The result must be a valid array. How can I do? thank you
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, your content is amazing. i have a question is there a way to get a microsoft forms response sent to the submiter in an email on a pdf format. eg. i fill the microsoft forms with the data requested, i would like to get an email with a pdf file that contains the info i submited in the form. this is bassically to create a form with the relevant invoices information and use this pdf on an email and attach this to the invoice as a front page.
Possible. Export to pdf - th-cam.com/video/Da4do2DxmJE/w-d-xo.html My video showcases exporting from power apps using flow. Same logic can be applied to Forms data.
Amazing ! Helped me a lot, many thanks. I need help whenever I click 'Open in Excel' in Responses Tab it creates and downloads a new excel file each time. How can I export Forms data to a single specific excel file?
hi Reza, many thanks for this clear and insightful video! I followed your steps using a simple form (2 fields to fill out, of which one file upload). The flow works, but I seem to be missing something: it returns 3 items in my sharepoint list, of which only one contains the attachment. Any advice on what I should correct in order to get only 1 Sharepoint list item?
Thanks Iris. It should create one line item per form submission. All attachments should go to that same list item. I will have to look at your flow in action to provide assistance. Difficult to do so here on chat. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you so much; created a ticket on there, really hope it's clear with all the screenshots: powerusers.microsoft.com/t5/Building-Flows/Flow-between-Forms-and-Sharepoint-List-file-upload/td-p/1370903
@@RezaDorrani no solution that works so far 😣 I exactly followed all of your steps, but my flow keeps on creating 3 Sharepoint items instead of 1 (only one of the 3 contains the attachment)
@@irisvandenbulcke327 You can try reposting your question on the forum. Or try and get on a Teams call with the person helping you out on the forums (if they are ok with it).
Loved this video it even answered some other questions I had, like the use of the 'FLOAT' expression. How would you handle writing to SharePoint from the Likert scale?
Likert scale should give a string value from 0-10 You can use expressions to convert it to number Int(val) I may have shown the Likert scale in this video th-cam.com/video/4eWGdi_C2hQ/w-d-xo.html
Great as always!! Thanks so much. I am trying to implement a Employee Application Process using this model but a need to upload documents from external users. Do you have any recommendations on what tool should I use?
@@RezaDorrani Thanks for your quick response. Can you be more specific please on this workaround. I need to request some documents prior to the resume evaluation
@@marienaalvarez8235 OneDrive has an option where you can create a folder and request files. This is something that you would have to check. I am just giving suggestions based on what I have heard/learnt from various community/ MSFT events.
I do not have a video reference on multi select columns scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
So good watch that! 👍 I´m learning.. is there any video in your channel about create word doc. using Power Automate with these answers from SharePoint?
Thanks. Not related to word. I did a video on export to pdf - th-cam.com/video/Da4do2DxmJE/w-d-xo.html For word related export, I will recommend to check on the forums at powerusers.microsoft.com
Hi Reza, ty so much for this video, is it possible to save the attachments from the Forms in sharepoint to another folder (Like in sharepoint you have the folder "documents"). Because at the moment the attachments get saved in my one drive cloud. I hope it was understandable :)..
Thank you very much Reza i had a problèm with an error with the upload file from form to SharePoint. Four days during i was looking for a solution and you show thé answer i would like to thank you
You can get data from Microsoft Forms and create table in flow. I did a video recently on creating a csv file in flow using data from Power Apps. Concept is similar - th-cam.com/video/tQCBWMR7T64/w-d-xo.html I have a video coming on creating html table in flow soon which would be useful for your scenario.
Thank you so much Is it possible to grab the uploaded file the people submitted via forms (which land on my personal sharepoint folder) and attach them as an automatic email i send via ms flow? as you say i get the answer in an string but i want to directly have the uploaded file as a attachment. Thank you and i would appreciate your help!
Yes, possible. Will have to generate the attachment array similar to the one showcased in the video and then send as an email. I am sure there will be folks who have done this. Check or post your request in the community forum - powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi I love the way you explain is really unique. Could you please have a Video explain how we can power flow Change request or incident from servicenow to the team. Appreciated
Thank you so much again Reza! May I ask you a question? I am making a flow exactly like this with the same SP Data Source. Although I need the user to only be able to submit the form once PER DAY...I am aware in the FORMS setting you can check mark that the user can only do one submission, although that prevents the specific user from submitting a second form forever. Would you have any tips on how to do a Form Response Once Per Day?
How long no see, haha I need to make the same thing that multi select, but in this case from a form to a dataverse, can you give me a way to go? Always grateful for your immense knowledge.
I would have to try it out with Dataverse myself to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
That was excellent. My attachment saving from Forms to SP using flow has stopped working, so I'll give this a go. A question, though. Does the flow break if there is no attachment?
Hello Rezza, Thank you for the re-direction. Everything works fine, but i get duplicate attachments each time I run the flow i.e. 2 attachments will have 4 attachments when I include the "Send_an_Email" Connector.
@@RezaDorrani Thank you. I had both "get attachments" and "Get attachment contents" in my flow. Deleted the "get attachments" connector and it worked. Big Up man. You have gained a loyal follower
Hmmn. The for loop would not run in that case since no files are uploaded. You could also check the length of the files array to ensure it is greater than 0 prior to uploading. You would need to use the expression function length.
Hello Reza! Thanks for sharing your knowledge. Please help me with the following question: Is there any way to add automatically users to 'specific people in my organisation can respond'?... I did not find a power automate action to do it... The idea is that only certain people can answer the form, but these respondents are increasing every day...
Hi Reza, as always your videos helped a lot for our everyday development! I have a flow that triggers when a new form is submitted and create a new item in SharePoint list. But when users edit their response in MS Form and resubmit I couldn’t find a solution to update a SP list. As you know there is only Single trigger option: You can only trigger a Power Automate flow from a Microsoft Form when a new response is submitted. No item-level modification trigger: There's no built-in option to trigger a flow based on changes made to individual questions or form settings within the Form itself. Do you have any recommendations or workarounds to solve this issue, like creating a unique identifier field in SP list (tried that one but no luck) Note: using MS Form is a requirement. Thanks!
I am not aware of what options are available for item modification for form. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza Thanks for the video, It was very helpful and easy to follow! I have one question, How we can update the existing sharepoint List item using Form data if I have a common reference?
Use the update item action - for that you would need the unique ID of the item to update. You can get that by query your list based on your unique reference. To query sharepoint list from flow, check - th-cam.com/video/yeAnuTB85eg/w-d-xo.html
Thank you Reza. If there is no file attachment, would the flow still work. I had a flow where it was failing and hence I had to include a condition to check the length of file attachment name. If length expression returns zero, flow assumes there is no file and goes ahead without attachment else it goes with attaching the file.
Reza, I was able to figure out how to handle multiple choices thanks to your video, but when it comes to attachments, I am unable to advance past the One Drive step. It seems as if the associated files for our form are in our group's shared SharePoint vs. One Drive. The end of the video eludes to there being similar steps, but I can't find them written or shown anywhere. Do you have this information available somewhere?
Foi um ótimo vídeo. Gostaria de saber se é possível coletar o tempo de preenchimento do formulário (ex 5 minutos para preencher) e inserir no sharepoint.
Im not sure if that property is exposed. I did a video where I query forms api and it provides the responses. You would need to check to see if the json response includes the time. th-cam.com/video/4eWGdi_C2hQ/w-d-xo.html
@RezaDorrani - What if you do not upload a file? I have tried and it give me this error; Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '27529': 'Required property 'content' expects a value but got null. Path ''.'.
Excellent video Reza! Thank you! I am actually doing a flow like this, but it is what you started to touch on at the end: Form that was created from a group SP site, so the attachments are going into the "apps" folder on the SP site where the List items are located. The Flow I created is working through the "FilesComposeAction", but fails in the "Apply to each File" -- "Get Attachment Content" section with a "Route did not match" error. I have dug into all kinds of documentation and forums for days and am simply stumped. Could you please provide some help?
I would have to try out the above with a group site to provide guidance. Forums would be your best bet. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@omermirza5994 Hi Omer, No, I tried 3 different techniques/approaches based on different tutorials and each method fails at the same point with the same error. I had to set this aside at the end of February due to other pressing issues and we are just going into the Apps folder to retrieve files for now. I'd like to return to this in the future but don't have time now. Good luck to you!
Thanks Reza for this.We have a requirement where, a scheduled Flow needs to be created and a mail needs to be sent to few team members with a questionnaire link (Microsoft Form) having dynamic values coming from dataverse, and response with files needs to be recorded in Dataverse.Please suggest.
I do not have a video on this scenario & would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I don't see any action in Power Automate to create the form. If the Form is created already and we have to store the response and files in Dataverse then I hope it can be done as explained in this video. Please confirm.
Hey Reza! I really enjoyed the video! I learned alot and you made it very easy to understand! I have a question. If I am interested in creating an automated weekly report of a clock in/out flow for employess that includes the time, date and hours worked that will send me a weekly email on Monday's totaling all hours per week per employee from previous week is this possible to do with power automate? And or with possibly Microsoft Forms? Thanks
Thank You. I do have a video idea I'm working on which will allow us to filter data stored in MSFT Forms. Maybe that video might help. Video will be out next week.
Possible but do not have a video on it. I know there are many posts about this on the community forum - powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@RezaDorrani Thanks for your reply, But I dont see any solution with free connectors. They use some third party connectors. I wanted to use the one drive for business.
Quick question... for using Form to capture information, is it possible to get the Form Submitter's name to Sharepoint? I used the Sharepoint default field of "Credited by" but it only capture the Form owner name (which is always my name) instead of the one who submitted the form response. Thanks a million Reza!
Flow runs under the context of its Owner/Connectors and hence Createdby would be the flow owners name. CreatedBy is an internal column in SharePoint. You can create an additonal column to store the submitters name.
Possible using Power Automate. I do not have a video reference on this though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you for the video Reza! it's clear and understand able, I have a question here, by any chance that we can have public upload the file/document by using the form? or is there any way that we can have public upload the file and recorded in sharepoint too? would appreciate for the answer
Forms file upload is only for internal users. One option for anonymous users would be for them to submit form, then create a folder in SharePoint for that user & share that folder path to user via flow.
Hi reza can we also use this for tagging metadata in a document library instead of a list? I am trying to get approvers to tag metadata in a library for invoice through the approvals request sent to them but not able to achieve it through approvals card power automate. any suggestions are most welcome.
Possible but I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello. Is it possible to use power automate to notify me when when Microsoft forms response reaches a certain limit? For example, I’m using forms as a registration to pick dates for meetings but we want to limit each meeting to 10 people. Can I use power automate to notify me when an answer reaches 10? I know forms doesn’t do this so I’ve been searching to see if power automate can. If it could notify me then I can go and remove that date from the forms survey
Possible. After every response received, flow can write that info to a list or excel file and update the counter. Once counter reaches a specific number, you can let flow notify you.
Hi Reza, great video. Your handling of Multiple Choice/Multiple Answer columns is pretty easy to understand. The only issue I have, my multiple choices still move to sharepoint as 1 expression. I followed everything perfectly from what I can tell. Even when I test my flow, I have the same outputs in the flow, formatted the same way yours are, but somehow my Sharepoint column is still showing my multiple options as 1 expression. Any ideas?
Check your column type to make sure it is a multi select choice column. Also ensure the expression output is in the right format. You can add a compose action and add that expression to check its outcome. I will have to look at your flow in action to provide any specific guidance. I will recommend to post your issue with screenshots on the forums at powerusers.microsoft.com
Have you made the video on automating the process of sending reminders thru outlook for employees reminding them to filling the feedback forms present in ms forms thru outlook mail
@rezadorrani can you point me in the direction of video to assist with following error: Action 'Parse_JSON_-_Extract_attachments_from_form' failed. In this scenario, my flow runs as long as a file is uploaded.. I cannot find the condition or trigger I need to used to say if there is no file uploaded, just do not look for one.
Basically you need to conditionally upload list item attachments when they exist else do not. I am assuming you are trying to add this to the approvals action. I have not seen any specific video on this. I will add this request to my backlog. I would also recommend to post your issue with screenshots on the community forum at - powerusers.microsoft.com/t5/General-Power-Automate/bd-p/MPAForum
facing an issue while creating an automated cloud flow when i use ms forms (when a response is submitted ) as a trigger, i get the following error "Test connection failed. Details: Did not find Forms licenses for current user" in flow checker the error is "invalid connection, please choose a connection" and then i went to the data tab and selected the connections tab and tries new connection option. it required me to sign in but then gave me an error after the adding connection message "Something went wrong. Please try again later." looking forward to help from you
Message suggests you don't have a valid Forms license. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has run into a similar issue.
Excellent video! What if I want to incluide another "question" to attach multiple attachments by tipe. For example, the first attachment question will be only pdfs, the next question only images. How can I upgrade the flow. By the way, thank you!
Thanks for the video. I need to understand little bit more here.. Why do we really need Microsoft forms here. Our goal is to saving the responses in sharepoint. In this case we can create canvas app and leverage all the options. Please share your inputs. I may be wrong.
MSFT Forms enable anonymous user access. Power Apps Canvas on the other hand cannot be accessed anonymously. Forms and Power Apps have different use cases. Check out this post to learn about the differences - powerusers.microsoft.com/t5/Building-Power-Apps/Difference-between-forms-and-PowerApps/td-p/259692
Great tutorial. However, I get an error when trying to add the Select output to the "Create item" in Sharepoint. I get the following error message: "Cannot create property 'item/Konsekvens/Value' on string '@'". The Select output seems to be in the correct format, and when I try to hard code the select output manually to the same field, it works just fine. Any idea of what I am doing wrong?
I will have to flow at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Raza, What is the solution for MS Form already submitted and attachments stored in OneDrive, But all the response i need to get from excel to Sharepoint with all rows and attachments. Need solutions for post submission for MS form responses. Please help on it.
Possible. I currently do not have a video on that though. I have a video planned in backlog for total score of a quiz based form. Meanwhile, I will recommend you check on the forums at powerusers.microsoft.com/
Woww Reza! Handling multiple choice columns and attachments using expressions you made it look simple. One of the best videos of yours. Thanks a lot.
Thank you Ramesh. Happy to know it was explained in an easy manner. That was the goal :)
After going through 10+ forums Reponses and multiple different ways of trying to get Multiple Choice Values into SP List. this is the best and easiest way to do that. I've watched a few of your videos now and they are all amazing. Thank you Reza!
Glad it helped!
Start with my videos 😉
@@RezaDorrani i will next time! thanks a million
After trying with many tutorials, I finally succeeded uploading files to list with this tutorial. Thank you very much
Glad to hear the video is useful. Thanks for watching
I couldn't figure out the multiple choice thing from several sources. Finally stumbled upon this video and solved it. Thank you once again!
Glad it was helpful!
@@RezaDorrani How will this work if there are more than one multi-choice questions? Adding Compose - Select step for each multi-choice question does not seem to be working.
@@close_this_window same concept but repeated. Not sure why it’s not working in your case.
@@RezaDorrani if there are four choices selected in the form, the automation result is four list items with each having one unique choice.
Figured it out, the list column had multi-choice option turned off. 🙃Thank you for the confirmation though. 🙏🏼
Been scratching my head as to why some things were missing from dynamic content! Well that solves that, Thanks Reza!
You’re most welcome
YES THANK YOU SO MUCH! I've watched a lot of other videos trying to get my Choice columns and attachments working but didn't get it right until this one.
Glad it helped!
Reza ...in two words AMA (wait for it) ZING
you safe me hour's. simple explanation, easy to follow. Manny manny thanks
So glad to hear that! Thanks Bruno
My first ‘real’ flow was doing exactly this and the attachments were a real pain to figure out, wish this video was around then, you made it so much easier, but I have to say that’s mainly because of your excellent video that talks about JSON which when you start to understand makes Power Automate and Expressions make so much more sense. Another great video, every flow I make is better because of watching your videos, you’d definitely get top marks if I was filling out your survey 😊
Every time I get feedback I feel this is my best one to date. I have that same feeling right now 😊
Thank you for watching as always and hope to keep the momentum flowing.
Yeah, I feel like I need to learn json in order to stop looking for Reza's videos every time I get stuck. 😝
This video is of another level with respect to the ones you can find around. Great!
Wow, thanks!
You’re a life saver! Been trying to find an efficient way to manage this type of flow. Thank you so much, Reza!
You are most welcome!
Thanks! I have tried several tutorials and this was the only one that has worked!
Glad to know the video was useful. Thanks for watching
Hello Reza, this video is gold, thank you for taking the time to show us.
You are most welcome
Excellent and brilliant. Covering all practical scenarios that one will face while handling this use case. Thanks Reza
My pleasure! Thank You for watching.
Hi I found your better than most of the tutorial online but it is not easy to understand without visually knowing what am i aiming for or what i will achieve which makes it only for people who already familiar with the platform and not for people who have just begun will get lost and leave even though they can easily do it after following and understanding the reason behind it.
Thanks Hardik.
Some videos are designed keeping beginners in mind while others are meant to cover a specific use case which does require some understanding of the tools.
My goal for my videos is to keep it concise & simple to understand (true for most of my new videos).
I also try to share the code (App/Flow) along with the video when possible.
@@RezaDorrani Thank you I would like to know do you have entry level for power platform tutorial that will allow me to learn without getting overwhelm by so many features and possibilities.
@@hardikgalaiya8834 I have playlists on my channel for beginners. I am working on training content for beginners. It will be out in the next few months.
Thank you for posting this awesome video! This is exactly what I was looking for and everything is clearly explained!! Can't thank you enough!!
You will need to add null check in flow. Check count of items and accordingly update.
This is absolutely amazing! thank you Reza for all the incredible content you create, I hope my TH-cam channel can someday be at least half great as yours!
Thank you!
Your channel just got a new subscriber!
@@RezaDorrani wow!!!!!!! thank you very much Reza, you are really the very best!!!!!
WaW , fantastic. every single information you gave is valuable.
Thank you!
Hi Reza, just want to say you are the best. I have learned a lot from you and your videos have helped me in my current role. Your videos are the best and just awesome. Thanks for all the content. You should add a Donate button on your channel :)
Wow, thank you for your kind words. I am working on my training content which will be out in Q1 2022 & that would be a paid subscription. I hope many join me there as I plan to truly go all out with content ranging from beginner to advanced.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
th-cam.com/users/rezadorranijoin
thank you sooooo much that helped me in such a short time to obtain my goal!
Most welcome!
Excellent Video! You make things look so simple! 👏👏
Thank you Daniel
Very nice video! Covered all I needed and much more! Very descriptive and objetive.
Happy to know that video is useful. Thanks for watching Bruno.
Well done!!!! Greetings from Germany ... Christoph :-)
Thank You
This is a fantastic video and has made this a lot easier for a beginner. Thank you.
Would you be able to provide instructions on how to add a second attachment questions and pass the upload through to lists. I have tried and tried with no luck. It is probably very simple.
Thanks for watching and liking the video.
I do not have a video reference for multiple attachments. I can add the request to my backlog but chances of video being made is low as I would need a lot more folks requesting this topic.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Great video, thanks for making this easy! Concise, well structured and engaging! Love it!
Thank you Luise
Very nicely explained
Thanks
Awesome. That covers almost all scenarios.. Thanks, Reza :)
My pleasure!
Thanks Reza for sharing your knowledge
Thank you Sundra
Thank you
Most welcome
Most welcome
Appreciate you doing the video!!! I am just fed up with office and Microsoft....just when ya think ya learned something they change it so now ya even more confused
Change is the only constant in this world :)
Changes should not impact existing Apps/flows.
If any change has broken your existing solution, you can raise a ticket with MSFT or highlight that on the forums at powerusers.microsoft.com/
You have been so helpful!! Thank you! How about if you have 2 multiple choice selections in your form?
You would need to repeat the logic multiple times.
Thank you, Reza! Amazing video! Do you have any video on how to set a flow with multiple branch answers? Thanks a lot!
I do not have a video with branching. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani , I have checked, and there is feedback for one branch, not multiple branches. Thank you.
@@CarloAbela Ok, but I do not have a video on branching.
@@RezaDorrani Thank you...maybe you will make one shortly!
@@CarloAbela I make videos when I get multiple requests on a topic. Very few requests on this topic.
Got this working, thanks a lot for your continuous effort, Reza. One question though, on my form attachments aren't required. When a submission gets made without an attachment(which is okay and will happen mostly) the flow runs and I get a new Sharepoint item...BUT Power Automate sees it as a failed run, I could launch it like this, but I don't want to run in the issue of the flow stopping due to a lot of failed runs. Can you send me somewhere to understand how to solve this?
Should not be the case. If no attachments then the apply to each loop would not run. Check count of items returned for the array of documents.
@@RezaDorrani getting this: The execution of template action 'Apply_to_each_file' failed: the result of the evaluation of 'foreach' expression '@outputs('Files')' is of type 'Null'. The result must be a valid array. I know what it means, not how to solve it.:-)
@@RezaDorrani Did that, curious what the solution will be. Thanks
Really good one.. I watched so many video and yours did help on the attachment. If possible, see if you can just slow down a bit. I need to pause in order to capture what you typed :P
Glad it was useful. Thanks for watching Tommy. I will work on slowing down or pausing for a moment after I type or show code. Thank you for the feedback.
Thank you for your videos!
Glad you like them!
Hello Reza,
Thanks for great step by step tutorial! I have question, if I want to leave the upload file as an option, it gives me fail in flow when no attachment. Can we make it go next action regardless of file exists?
Thank you!
You will need to add a condition in flow to check if attachment is empty.
@@RezaDorrani appreciate quick reply!
found it here :) thanks Reza, let me look for the solution! thanks!
👍
Very nice presentation.
Thank you a lot.
Using a SharePoint based Forms I got a pb with attached files Excel or Word. I cannot display them. PDF files got no problem. Have you got a tip to fix that ?
check if my most recent video helps th-cam.com/video/K-hiDOPAG-4/w-d-xo.html
Hi Reza, thanks for this amazing content. But I tried using a group form instead and if I swap out the one drive steps with sharepoint - Get file content and do what you have done here it keeps failing. Any idea how to fix that? It can't find the files. "Action 'Get_file_content' failed". Thanks!
Check th-cam.com/video/K-hiDOPAG-4/w-d-xo.html
Thanks so much! But this is what I get if I try to add a variable in the "Apply to each file" loop. "The operation 'Initialize variable' can only be used at top level."
@@omermirza5994 Initialize cannot be done in loops. I dont think I do that in the video either.
@@RezaDorrani aah please excuse my ignorance but I'm trying to start this step after the 'Create item' step in your 'Power Automate Microsoft Forms Connector tutorial with Attachments' video. The idea is to pull attachment files from group forms in sharepoint, on to the sharepoint list.
I'm not sure at what level I should initialize variable. Because if I create a loop after that I don't have any of my dynamic content available for the json expression.
Thanks for bearing with me.
@@omermirza5994 It is difficult to understand here on chat. I would recommend posting your query/issue with screenshots on the forums at powerusers.microsoft.com/
Thank you ever so much Reza, my saviour! May I bother with a question? "Move Multi choice answers in Forms to SharePoint multi select choice column", the flow does not work if none is selected. Do you know a way to make it work when the selection is null? Thank you!
You would probably need to write an expression to perform the null check in flow.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Video was great - well explained. My form has 6 choice questions where user can input more then one answer or no answer if the question is not valid for them. When running the flow it works great when multiple answers are picked but fails when no answer is picked. Any thoughts?? I was thinking of using a control action but I would have to do that 6 times.
You will need to add an expression to check if it is null
Reza great Video One suggestion Try to slow down to help us to absorb some of the awesome techniques you are sharing
Thank you for watching and thanks for the feedback. I am working on trying to slow down. Hopefully improving video by video :)
Meanwhile YT has a feature where you can change the watch speed. Slow it down to 0.75 and see if it works for you.
@@RezaDorrani thank u and keep doing what yu do best.
thank you very much for your video! I have a question. I have a form where the user can upload 1 attachment or 3 attachments. Unfortunately the flow does not work in this case, I have this error: The execution of the 'Apply_to_all' action of the model failed. The result of evaluating the expression 'foreach' '@outputs (' compose_output_ buffer ')' is of type 'Null'. The result must be a valid array. How can I do? thank you
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, your content is amazing. i have a question is there a way to get a microsoft forms response sent to the submiter in an email on a pdf format.
eg. i fill the microsoft forms with the data requested, i would like to get an email with a pdf file that contains the info i submited in the form.
this is bassically to create a form with the relevant invoices information and use this pdf on an email and attach this to the invoice as a front page.
Possible. Export to pdf - th-cam.com/video/Da4do2DxmJE/w-d-xo.html
My video showcases exporting from power apps using flow. Same logic can be applied to Forms data.
Amazing ! Helped me a lot, many thanks. I need help whenever I click 'Open in Excel' in Responses Tab it creates and downloads a new excel file each time. How can I export Forms data to a single specific excel file?
In forms responses - open in excel - will download all the data related to forms to a single excel file
hi Reza, many thanks for this clear and insightful video! I followed your steps using a simple form (2 fields to fill out, of which one file upload). The flow works, but I seem to be missing something: it returns 3 items in my sharepoint list, of which only one contains the attachment. Any advice on what I should correct in order to get only 1 Sharepoint list item?
Thanks Iris. It should create one line item per form submission. All attachments should go to that same list item.
I will have to look at your flow in action to provide assistance. Difficult to do so here on chat.
I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani thank you so much; created a ticket on there, really hope it's clear with all the screenshots:
powerusers.microsoft.com/t5/Building-Flows/Flow-between-Forms-and-Sharepoint-List-file-upload/td-p/1370903
Looks like you are getting help there.
@@RezaDorrani no solution that works so far 😣 I exactly followed all of your steps, but my flow keeps on creating 3 Sharepoint items instead of 1 (only one of the 3 contains the attachment)
@@irisvandenbulcke327 You can try reposting your question on the forum.
Or try and get on a Teams call with the person helping you out on the forums (if they are ok with it).
Loved this video it even answered some other questions I had, like the use of the 'FLOAT' expression.
How would you handle writing to SharePoint from the Likert scale?
Likert scale should give a string value from 0-10
You can use expressions to convert it to number
Int(val)
I may have shown the Likert scale in this video th-cam.com/video/4eWGdi_C2hQ/w-d-xo.html
@@RezaDorrani Thank you!!!!!!
Great as always!! Thanks so much. I am trying to implement a Employee Application Process using this model but a need to upload documents from external users. Do you have any recommendations on what tool should I use?
External users cannot upload docs in forms. You could create a folder in OneDrive or SharePoint and allow external users to upload files there.
@@RezaDorrani Thanks for your quick response. Can you be more specific please on this workaround. I need to request some documents prior to the resume evaluation
@@marienaalvarez8235 OneDrive has an option where you can create a folder and request files. This is something that you would have to check. I am just giving suggestions based on what I have heard/learnt from various community/ MSFT events.
@@RezaDorrani Thank you 😊
Hi, Great video! Thank you for this. However, I am new at this and would like to know how to handle forms with multiple, multiple choice columns?
I do not have a video reference on multi select columns scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you for your response. I will check out the forum.
So good watch that! 👍 I´m learning.. is there any video in your channel about create word doc. using Power Automate with these answers from SharePoint?
Thanks.
Not related to word.
I did a video on export to pdf - th-cam.com/video/Da4do2DxmJE/w-d-xo.html
For word related export, I will recommend to check on the forums at powerusers.microsoft.com
@@RezaDorrani very thanks!!!
Excellent video! There is a way a flow like this one, but with a forms created in a channel from a Teams Group?
Forms created in a channel are stored in SharePoint. You can trigger flow based on that as well.
Hi Reza, ty so much for this video, is it possible to save the attachments from the Forms in sharepoint to another folder (Like in sharepoint you have the folder "documents"). Because at the moment the attachments get saved in my one drive cloud. I hope it was understandable :)..
Possible. Check th-cam.com/video/K-hiDOPAG-4/w-d-xo.html
@@RezaDorrani Ty first time for me to work wiht Sharepoint and Power Automate :)
Thank you very much Reza i had a problèm with an error with the upload file from form to SharePoint. Four days during i was looking for a solution and you show thé answer i would like to thank you
So happy to know that this video helped. Thank you for watching.
HI Reza very helpful information, is possible to prepare table format till before submit using forms?? please advice.
You can get data from Microsoft Forms and create table in flow. I did a video recently on creating a csv file in flow using data from Power Apps. Concept is similar - th-cam.com/video/tQCBWMR7T64/w-d-xo.html
I have a video coming on creating html table in flow soon which would be useful for your scenario.
Thank you so much Is it possible to grab the uploaded file the people submitted via forms (which land on my personal sharepoint folder) and attach them as an automatic email i send via ms flow? as you say i get the answer in an string but i want to directly have the uploaded file as a attachment. Thank you and i would appreciate your help!
Yes, possible. Will have to generate the attachment array similar to the one showcased in the video and then send as an email. I am sure there will be folks who have done this. Check or post your request in the community forum - powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Hi
I love the way you explain is really unique. Could you please have a Video explain how we can power flow Change request or incident from servicenow to the team. Appreciated
Thanks for the feedback Rose.
Thank you so much again Reza! May I ask you a question? I am making a flow exactly like this with the same SP Data Source. Although I need the user to only be able to submit the form once PER DAY...I am aware in the FORMS setting you can check mark that the user can only do one submission, although that prevents the specific user from submitting a second form forever. Would you have any tips on how to do a Form Response Once Per Day?
I don't think MSFT Forms has the option of single request per day.
May be forms pro has that.
How long no see, haha
I need to make the same thing that multi select, but in this case from a form to a dataverse, can you give me a way to go?
Always grateful for your immense knowledge.
I would have to try it out with Dataverse myself to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks!
That was excellent. My attachment saving from Forms to SP using flow has stopped working, so I'll give this a go. A question, though. Does the flow break if there is no attachment?
The attachments loop only runs if files are added so the flow should not break.
Give it a try and let me know how it goes.
Add a condition: empty(uploaded file) = false => yes: your flow
Hello Rezza, Thank you for the re-direction. Everything works fine, but i get duplicate attachments each time I run the flow i.e. 2 attachments will have 4 attachments when I include the "Send_an_Email" Connector.
Check your flow run. See how many times the loop runs. Must be some issue with your flow or the formulas used.
@@RezaDorrani Thank you. I had both "get attachments" and "Get attachment contents" in my flow. Deleted the "get attachments" connector and it worked. Big Up man. You have gained a loyal follower
@@brianodhiambo4079 Glad to know it worked and welcome to my channel :)
Thank you Reza. How do I handle if no file attached when upload file is not mandatory? Any tip please?
Hmmn. The for loop would not run in that case since no files are uploaded.
You could also check the length of the files array to ensure it is greater than 0 prior to uploading.
You would need to use the expression function length.
Hello Reza! Thanks for sharing your knowledge. Please help me with the following question: Is there any way to add automatically users to 'specific people in my organisation can respond'?... I did not find a power automate action to do it... The idea is that only certain people can answer the form, but these respondents are increasing every day...
Never tried this so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, as always your videos helped a lot for our everyday development!
I have a flow that triggers when a new form is submitted and create a new item in SharePoint list. But when users edit their response in MS Form and resubmit I couldn’t find a solution to update a SP list. As you know there is only Single trigger option: You can only trigger a Power Automate flow from a Microsoft Form when a new response is submitted.
No item-level modification trigger:
There's no built-in option to trigger a flow based on changes made to individual questions or form settings within the Form itself. Do you have any recommendations or workarounds to solve this issue, like creating a unique identifier field in SP list (tried that one but no luck)
Note: using MS Form is a requirement.
Thanks!
I am not aware of what options are available for item modification for form. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks I will check that out.
Hi Reza
Thanks for the video, It was very helpful and easy to follow!
I have one question, How we can update the existing sharepoint List item using Form data if I have a common reference?
Use the update item action - for that you would need the unique ID of the item to update.
You can get that by query your list based on your unique reference.
To query sharepoint list from flow, check - th-cam.com/video/yeAnuTB85eg/w-d-xo.html
Thank you Reza. If there is no file attachment, would the flow still work. I had a flow where it was failing and hence I had to include a condition to check the length of file attachment name. If length expression returns zero, flow assumes there is no file and goes ahead without attachment else it goes with attaching the file.
The attachments loop will not execute if there are no attachments. So need to to even check an empty condition.
Reza, I was able to figure out how to handle multiple choices thanks to your video, but when it comes to attachments, I am unable to advance past the One Drive step. It seems as if the associated files for our form are in our group's shared SharePoint vs. One Drive. The end of the video eludes to there being similar steps, but I can't find them written or shown anywhere. Do you have this information available somewhere?
th-cam.com/video/K-hiDOPAG-4/w-d-xo.html
Foi um ótimo vídeo. Gostaria de saber se é possível coletar o tempo de preenchimento do formulário (ex 5 minutos para preencher) e inserir no sharepoint.
Im not sure if that property is exposed. I did a video where I query forms api and it provides the responses. You would need to check to see if the json response includes the time.
th-cam.com/video/4eWGdi_C2hQ/w-d-xo.html
@@RezaDorrani Muito obrigado, estou consultando.
@RezaDorrani - What if you do not upload a file? I have tried and it give me this error;
Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '27529': 'Required property 'content' expects a value but got null. Path ''.'.
You can add a null check using expressions.
Hi reza. Wow. Could i use create item instead add attachment. I don't like attachment because there is no versionning on the files.
I have just saw your last video - Are you reading in my mind ? Thank tou rezza th-cam.com/video/K-hiDOPAG-4/w-d-xo.html
That would be create files to store in doc lib. A list can only store files in attachments.
@@RezaDorrani it s exactly why i need. it s for à library. my client don t want to use PowerApps
Excellent video Reza! Thank you! I am actually doing a flow like this, but it is what you started to touch on at the end: Form that was created from a group SP site, so the attachments are going into the "apps" folder on the SP site where the List items are located. The Flow I created is working through the "FilesComposeAction", but fails in the "Apply to each File" -- "Get Attachment Content" section with a "Route did not match" error. I have dug into all kinds of documentation and forums for days and am simply stumped. Could you please provide some help?
I would have to try out the above with a group site to provide guidance. Forums would be your best bet. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Debbie, were you able to solve this issue? I don't want to link to a one drive form either.
@@omermirza5994 Here is the video for SP th-cam.com/video/K-hiDOPAG-4/w-d-xo.html
@@omermirza5994 Hi Omer,
No, I tried 3 different techniques/approaches based on different tutorials and each method fails at the same point with the same error. I had to set this aside at the end of February due to other pressing issues and we are just going into the Apps folder to retrieve files for now. I'd like to return to this in the future but don't have time now. Good luck to you!
@@debbiehintz3100 Oh I hope you find a solution. Thanks though. I had it working through my one drive, I'll just revert to that for now I guess.
Thanks Reza for this.We have a requirement where, a scheduled Flow needs to be created and a mail needs to be sent to few team members with a questionnaire link (Microsoft Form) having dynamic values coming from dataverse, and response with files needs to be recorded in Dataverse.Please suggest.
I do not have a video on this scenario & would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I don't see any action in Power Automate to create the form. If the Form is created already and we have to store the response and files in Dataverse then I hope it can be done as explained in this video. Please confirm.
@@subhmajumdar I'm not sure about it. I will recommend checking on the forums.
great video thanks
You are welcome!
Hey Reza! I really enjoyed the video! I learned alot and you made it very easy to understand! I have a question. If I am interested in creating an automated weekly report of a clock in/out flow for employess that includes the time, date and hours worked that will send me a weekly email on Monday's totaling all hours per week per employee from previous week is this possible to do with power automate? And or with possibly Microsoft Forms?
Thanks
Thank You.
I do have a video idea I'm working on which will allow us to filter data stored in MSFT Forms. Maybe that video might help. Video will be out next week.
@@RezaDorrani Hey Reza! That is perfect! Thank you so much for your quick response too. I am looking forward to watching this video.
Nice content , much appreciated. I am trying to get the attachment(docx) content directly into pdf. any way to do that?
Possible but do not have a video on it.
I know there are many posts about this on the community forum - powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@@RezaDorrani Thanks for your reply, But I dont see any solution with free connectors. They use some third party connectors. I wanted to use the one drive for business.
You are amazing thx for sharing !!!
You are so welcome!
Great video well explained. Instead of visual studio can we use say notepad plus? Thanks
Yes, absolutely. Any editor that will help you in working with JSON.
great video , i learned a lot from you
Glad you enjoyed!
Quick question... for using Form to capture information, is it possible to get the Form Submitter's name to Sharepoint? I used the Sharepoint default field of "Credited by" but it only capture the Form owner name (which is always my name) instead of the one who submitted the form response. Thanks a million Reza!
Flow runs under the context of its Owner/Connectors and hence Createdby would be the flow owners name.
CreatedBy is an internal column in SharePoint.
You can create an additonal column to store the submitters name.
Hi, anything on integrating JIRA in to Microsoft forms. like upon submission of queries from Microsoft form, it must land as issues in JIRA.
Possible using Power Automate. I do not have a video reference on this though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
amazing!! helped me a lot
Great! Thanks for watching.
V useful
👍
I have one question actually is there any connectors that make me update a form automatically when I add or modify a SharePoint list
Which form? MS form?
@@RezaDorrani ms forms
@@Tamilan6382 I dont even know if that’s possible.
Thank you for the video Reza! it's clear and understand able, I have a question here, by any chance that we can have public upload the file/document by using the form? or is there any way that we can have public upload the file and recorded in sharepoint too? would appreciate for the answer
Forms file upload is only for internal users.
One option for anonymous users would be for them to submit form, then create a folder in SharePoint for that user & share that folder path to user via flow.
Hi reza can we also use this for tagging metadata in a document library instead of a list? I am trying to get approvers to tag metadata in a library for invoice through the approvals request sent to them but not able to achieve it through approvals card power automate. any suggestions are most welcome.
Possible but I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great tutorial !!
Thank you
Hello. Is it possible to use power automate to notify me when when Microsoft forms response reaches a certain limit? For example, I’m using forms as a registration to pick dates for meetings but we want to limit each meeting to 10 people. Can I use power automate to notify me when an answer reaches 10? I know forms doesn’t do this so I’ve been searching to see if power automate can. If it could notify me then I can go and remove that date from the forms survey
Possible. After every response received, flow can write that info to a list or excel file and update the counter.
Once counter reaches a specific number, you can let flow notify you.
I have 17 - Multi-Choice fields in my form. Do I had a Compose/Select for each of these to get the values into my list?
I guess you would have to
Hi Reza, great video. Your handling of Multiple Choice/Multiple Answer columns is pretty easy to understand. The only issue I have, my multiple choices still move to sharepoint as 1 expression. I followed everything perfectly from what I can tell. Even when I test my flow, I have the same outputs in the flow, formatted the same way yours are, but somehow my Sharepoint column is still showing my multiple options as 1 expression. Any ideas?
Check your column type to make sure it is a multi select choice column. Also ensure the expression output is in the right format. You can add a compose action and add that expression to check its outcome.
I will have to look at your flow in action to provide any specific guidance. I will recommend to post your issue with screenshots on the forums at powerusers.microsoft.com
Thank you Reza!
Most welcome
Have you made the video on automating the process of sending reminders thru outlook for employees reminding them to filling the feedback forms present in ms forms thru outlook mail
No, I do not have any video references on this scenario.
Amazing stuff, thank you
Thanks Michael.
@rezadorrani can you point me in the direction of video to assist with following error: Action 'Parse_JSON_-_Extract_attachments_from_form' failed. In this scenario, my flow runs as long as a file is uploaded.. I cannot find the condition or trigger I need to used to say if there is no file uploaded, just do not look for one.
Basically you need to conditionally upload list item attachments when they exist else do not. I am assuming you are trying to add this to the approvals action.
I have not seen any specific video on this.
I will add this request to my backlog.
I would also recommend to post your issue with screenshots on the community forum at - powerusers.microsoft.com/t5/General-Power-Automate/bd-p/MPAForum
facing an issue while creating an automated cloud flow when i use ms forms (when a response is submitted ) as a trigger, i get the following error
"Test connection failed. Details: Did not find Forms licenses for current user"
in flow checker the error is "invalid connection, please choose a connection"
and then i went to the data tab and selected the connections tab and tries new connection option. it required me to sign in but then gave me an error after the adding connection message "Something went wrong. Please try again later."
looking forward to help from you
Message suggests you don't have a valid Forms license.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has run into a similar issue.
Excellent video! What if I want to incluide another "question" to attach multiple attachments by tipe. For example, the first attachment question will be only pdfs, the next question only images. How can I upgrade the flow. By the way, thank you!
Concept for that would be similar. Just associate it to the file upload question and accordingly post to the respective library.
Congrats!
👍
Thanks for the video. I need to understand little bit more here.. Why do we really need Microsoft forms here. Our goal is to saving the responses in sharepoint. In this case we can create canvas app and leverage all the options. Please share your inputs. I may be wrong.
MSFT Forms enable anonymous user access.
Power Apps Canvas on the other hand cannot be accessed anonymously.
Forms and Power Apps have different use cases.
Check out this post to learn about the differences - powerusers.microsoft.com/t5/Building-Power-Apps/Difference-between-forms-and-PowerApps/td-p/259692
Great video! @Ramesh Mukka
How can you build off this to send attachments(s) using the Start and Wait Approval?
Just use the attachment data showcased in the video and add it to the start and wait for an approval action.
Perfecto!!! Me sirvio mucho!!!
Your welcome
Great tutorial. However, I get an error when trying to add the Select output to the "Create item" in Sharepoint. I get the following error message: "Cannot create property 'item/Konsekvens/Value' on string '@'". The Select output seems to be in the correct format, and when I try to hard code the select output manually to the same field, it works just fine. Any idea of what I am doing wrong?
I will have to flow at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Raza, What is the solution for MS Form already submitted and attachments stored in OneDrive, But all the response i need to get from excel to Sharepoint with all rows and attachments. Need solutions for post submission for MS form responses. Please help on it.
Waiting for it..❤
I have a playlist on Microsoft Forms on my channel. Check that one out.
Reza, my attachment field from MS Form is not showing up in dynamic content, what should I do?
No idea as I have not experienced this.
Great video, Reza! I have a question. Can I get a total score from a form fillled with likerts or ranking?
Possible. I currently do not have a video on that though.
I have a video planned in backlog for total score of a quiz based form.
Meanwhile, I will recommend you check on the forums at powerusers.microsoft.com/