I know this video was published in 2020, but I am so glad I found it. My Microsoft Forms & Power Automate screens look very different, BUT, I was able to follow your tutorial and used it to trouble shoot why my list wasn't being populated correctly! Thank you!
Yassss! I'm learning a new job and this is helpful. I am a firm believer in working smarter and not harder. I'll be watching this a couple more times and save it so that i can make my job so much easier. :) Thank you!!!
Thank you! I need to do some more Power Automate videos. I'm adding that to my list once conference season is over and I can get some videos recorded again
Hey Hi, Thanks a Ton! I was using Forms to collect data for my organization and user complaining about data check after form submission, after looking at your video, and your step by step process, i was able to fix that issue. I cannot thank you enough for this. :)
Hi, When I want to setup the 'Record the Responses in Sharepoint' (7:30) and am choosing the Form IDs, the last box (Create List) only gives me one Sharepoint option for Web address connected to my Uni. There are no options under List Name. Can't continue! Help please!
@@AprilDunnam Might I also ask if there are videos within Power Automation to send interactive notifications to someone else (& not self) - if you have a video I will be grateful if a link can be shared, please.
Ok, at around 11:30 I had this great AHA moment what I was looking for the whole day while watching many tutorial videos but could not find the answer... Amazing! Creative = smart !
Great video once again! Thank you. It would have been great if you had covered how to get attachments from Form to List Item. And also different complex column types. It would have taken the vide to next level. Can you make one including different column types?
Ms. Dunham, with all the various platforms to store data, I need to collect standard data from employees i.e. Last Name, First Name, Car Type, License Plate, Make, Model etc. This list is updated annually. Would you recommend as the data input using MS Forms and storing into a MS List or MS Forms into MS Access?
Thank you for the Video, may i know how can i create multiple records with separate date on every row in list when Microsoft form response has Start date and end date.
Ok question, I followed your tutorial to the t. When it came to finding my form id, my forms wouldn’t populate. I googled what was going on and I tried copying and pasting the form in manually. My dynamic content window still wouldn’t create the different choice I had on the form or lists and I kept getting an error. Any idea what I’m doing wrong here. Is it something within my form? I didn’t create the form and it is one on a network sharepoint channel if that helps.
How's the connection between a list with columns that are for instance formatted as currency or Boolean reconciled with forms which you don't have that type of formatting or data type if you will. These columns don't show in the dynamic fields in the template you use in flows.
Hi April, how do I do this for multiple choices, some with 'multiple selection allowed' and some don't. With multiple selection allowed, responder also could also enter free text.
Hi @April Dunnam. The template in your video seems to be missing from Power Automate... I searched by title and template number and found nothing. Any chance this has been removed by Microsoft?
Additionally, it appears the "list of responses" is not available as a selection when using the "apply to all" in Power Automate (or anywhere else when using Form responses in Power Automate).
Hello! Does anyone know if it is possible to power automate a microsoft list to a microsoft form that you did NOT originally create but are a collaborator on?
Hello April, Thank so much for this video. I created my a Group MS Form, which responses are loaded on SharePoint Lib and my SharePoint list was also created. But some responses on my form are not showing up in the dynamic contents for me to match the responses to the list columns. Please How do I resolve this? Thank you.
Hi April. I see that the Responder Email is available as dynamic content. If the form is submitted by a user in my organization, how do I get the users name as dynamic content ro write to the sharepoint list?
If we have to take survey of employees every month and in second month we have to prepopulate the values to form from data submitted in first month from datasource how to do it.
Thank you so much for the video @April! Question, my company does not have permissions to use PowerAutomate just yet, how can I create the flow manually without using one of the "record responses in sharepoint" template.
When in the 'Record Form Responses in SharePoint", will the Form ID dropdown include/show Group Forms? It doesn't show the one that I created in Group Forms. Any suggestion?
Hey Clay - To use group forms in Power Automate you'll need to select the "Enter manual value" option in the flow action and copy/paste the form ID in there. It can be found in the form URL, should see a formID= and a big long number which is the ID
Great tutorial, but I need to know the quiz score in addition to the start time to calculate the duration of the assessment. Is there any way to get this data?
What a good video, I have a concern for a problem that I have, I need that when a user has already filled out the form the message that appears is "Your response has already been sent, This form only admits one response per person." My question is if this information can be customized so that a link to another page appears
Hi April, I have run into a issue hoping you can help me with. Someone shared the Microsoft form with edit access (which they created) with me. However when I try to use the form in my flow trigger dropdown, I cant seem to find the form. I understand this could be standard behaviour of shared forms. (If I created the form I can see it though). However requirement is that I need to use ONLY that shared form in my flow. I then tried to implement a workaround I saw in the forum discussions. The suggestion was to use the form id part (the portion after form id - xxxx) to use that ID as a custom value in the trigger. However when I do that way, I am unable to set the dynamic values to the the sharepoint list columns. All I see is only one dynamic item "list of response notification". Can you please suggest as I am stuck
How to put restriction on date field for restricting past dates? When creating a form to request something on a selected date, it would be useful if the date could be restricted so that only a present and future date can be selected. Thanks in advance. Please help me on that.
Hi April! I'm running into a problem, making every step up to minute 10, and just don't get it to work. I submit the response and it stays in Power Automate with no response. Just re-do a couple of steps and didn't work. Thanks for the video.
This is just what I needed, however, it doesn't seem to be able to match up the form option when someone submits a file, like a photo or logo, or word document. Any ideas?
This is a wonderful video! But, I am having trouble getting my existing reports into Lists. When I run the test, I get an error message that the input parameters of my Create Item action. it is saying it needs "to be of type 'String/uri'." Do you have any idea what my issue might be? I followed your steps exactly!
Dear April, is there a way to create a Microsoft Forms using a dropdown with information from a SQL Server for example taking information from an employees table in order to get the EmployeeNumber and EmployeeName, or what do you suggest to use this, my project is to make a Quiz but i need to get information from a database on SQLServer to show some catalogs.
Thank you so much for this great video. Question: what if my MS form has choices? When creating the list, do I add the choices or leave that blank? Thank you!
Me again - I got the new responses to show up in my list just fine but I can't get any of the data from the Excel spreadsheet. I was having trouble with the dates so I just removed it for testing purposes and while the flow runs and creates records, there is not data in the fields. Any ideas?
Great question - there are several. When we move to Lists we get lots of workflow capabilities built in to automate the data if need be with Power Automate. We also get the ability to easily collaborate, share and embed that data in a ton of places (Teams, SharePoint, Lists app, etc). And it's easy to report off of with creating views.
I updated my sharepoint lists BEFORe attempting to make the connection between forms and sharepoint list. But in the flow form (when I match the fields of sharepoint and the form) it always has the PRE-modified sharepoint list. I have no idea why or how to make it update and sync. I try hitting refresh, closing apps out, starting over with the flow and nothing changes. It happens with different sharepoint lists/forms. Have you ever seen this and know how to update? I finally learned so much from your video but can't move forward to try it!
Great video. My flow didn't work, I'm getting a message error: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Anyfeedbackfromtheclient_x003f_' is required to be of type 'Boolean'. The runtime value '"No"' to be converted doesn't have the expected format 'Boolean'. Does anyone know how to fix it?
Hi, Quick question on form sections. I have a survey with a number of different sections that are peoples names. The questions in each section are exactly the same, a scoring of 1-8. I need to have a column with "section" and then a column for the 5 questions and the values be the rating of 1-8. Any ideas?
April this is a great video as are all of your videos. Quick Question when wanting to pull in Quiz Results, how can we pull in the Final Score into the list?
Thank you for this tutorial! I am now trying to figure out how to get responses in multiple sheets-depending on what info is entered on my form. I can't find a tutorial on how to do that.
Hi, After selecting the template "Record form responses in SharePoint and click Continue, I got an error message: It looks like something went wrong t.some is not a function If you contact support, you may be asked to provide the following details: Time: Fri, 02 Feb 2024 02:51:56 GMT Session ID: a444a2c0-c175-11ee-b140-3d1003611557 Does it mean that the template got corrupted and is not usable anymore? Is there an alternative template?
Hey Michael - Yes that's one of the benefits of Microsoft forms. There's a "share to collaborate" option that lets anonymous/external users view and interact with your Microsoft Forms.
Hi Cliff - You can grab those file uploads but there are a few steps involved. This blog article actually explains it pretty well. I'll try to make a video about it too but this should help in the mean time: blog.encodian.com/2020/04/handling-files-provided-in-a-microsoft-forms-response/
Really helpful video, thank you! I've got a question. If I use the spreadsheet created by the Form, if I was to create more columns alongside it and input data, can I create a flow to send that data to the list also?
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
There aren't many people who explain better than you. Thank you.
Thanks Bernd!
I know this video was published in 2020, but I am so glad I found it. My Microsoft Forms & Power Automate screens look very different, BUT, I was able to follow your tutorial and used it to trouble shoot why my list wasn't being populated correctly! Thank you!
It doesn't work for me any tips ?
After many several videos this one was the right video. Thank you for the great video you have.
This my friend was a much needed lifesaver and earned you another subscriber. Thank you and God bless.
Thanks so much for the sub!
Yassss! I'm learning a new job and this is helpful. I am a firm believer in working smarter and not harder. I'll be watching this a couple more times and save it so that i can make my job so much easier. :) Thank you!!!
Glad this video is helping you work smarter not harder Sonya :) Thanks for watching!
All your videos about Flows are so much helpful...Thank you so much... looking for more and more
Thank you! I need to do some more Power Automate videos. I'm adding that to my list once conference season is over and I can get some videos recorded again
@@AprilDunnam Thank you April. Looking forward to watch and implement the same wherever that fits. Thank you again.
She-ro! Thank you soo much. You made creating an automatic flow for my event registration so easy! 🥰
Yay! You are so welcome! Glad I could help make it easy! 🙂
Hey Hi, Thanks a Ton! I was using Forms to collect data for my organization and user complaining about data check after form submission, after looking at your video, and your step by step process, i was able to fix that issue. I cannot thank you enough for this. :)
Yay! Great to hear that this video helped get your process working!
You are awesome! Finally found a video that is high quality and straighfoward.
Thank you!
Wooooaaaaaw! Just what I needed. Love you Dunnam!
Sweet!
Hi, This was very helpful.
I also liked the trimming of the video and that is presented at a steady pace. Thank you.
Glad you enjoyed it!
Excellent tutorial!!!! Very helpful....THANK YOU!!!!😊
Thanks so much! I'm very glad to hear it was helpful 🙂
why at part 7:11 , mine showed invalid parameters and when click the dropdown menu, it stated 'no item'
Awesome.. thanks i will try right away next week... easy to follow up..
Good luck!
Hi,
When I want to setup the 'Record the Responses in Sharepoint' (7:30) and am choosing the Form IDs, the last box (Create List) only gives me one Sharepoint option for Web address connected to my Uni. There are no options under List Name. Can't continue! Help please!
Thanks!
Thank you so much!!
unbelievable, excellent video. I'm really impressed.
Greetings from Brazil
Thank you! Cheers!
Awesome, thankyou so much, I've been stuck trying to get form data already entered into lists
Glad I could help get you unstuck!
Excellent video April! Top quality as everything you do! Thank you so much!
Thanks for watching Idael - glad you liked it!
April, much appreciate your content which is allowing me to effectively apply systems to master time efficiency. Keep up the good work.
I'm so happy to hear that! Thank you!
@@AprilDunnam Might I also ask if there are videos within Power Automation to send interactive notifications to someone else (& not self) - if you have a video I will be grateful if a link can be shared, please.
Best tutorial . Thank you so much.
Thank you!
Ok, at around 11:30 I had this great AHA moment what I was looking for the whole day while watching many tutorial videos but could not find the answer...
Amazing! Creative = smart !
Thank you! Glad this helped you find what you were looking for!
Great video once again! Thank you. It would have been great if you had covered how to get attachments from Form to List Item. And also different complex column types. It would have taken the vide to next level. Can you make one including different column types?
Thanks for the feedback Ramesh, I'll consider that for a future video
Very useful content. and easy to follow. Thank you, Thank you Thank you!
Thanks so much. I"m very glad to hear it was easy to follow 🙂
This was great and EXACTLY what I was looking for! Thank you!
Glad it was helpful!
Ms. Dunham, with all the various platforms to store data, I need to collect standard data from employees i.e. Last Name, First Name, Car Type, License Plate, Make, Model etc. This list is updated annually. Would you recommend as the data input using MS Forms and storing into a MS List or MS Forms into MS Access?
That's a brilliant video - many thanks for that, it's answered a few questions for me.
Glad it was helpful!
other then the website where the form is filled and results are stored is data somewhere on my onedrive or?
Thank you for the Video, may i know how can i create multiple records with separate date on every row in list when Microsoft form response has Start date and end date.
Thank you for helping find a better way!
Happy to help!
Hi, when you insert a response with multiple answers, in the list SP adds " " to each element, is there a way to remove them? Thanks!!
Ok question, I followed your tutorial to the t. When it came to finding my form id, my forms wouldn’t populate. I googled what was going on and I tried copying and pasting the form in manually. My dynamic content window still wouldn’t create the different choice I had on the form or lists and I kept getting an error. Any idea what I’m doing wrong here. Is it something within my form? I didn’t create the form and it is one on a network sharepoint channel if that helps.
How's the connection between a list with columns that are for instance formatted as currency or Boolean reconciled with forms which you don't have that type of formatting or data type if you will. These columns don't show in the dynamic fields in the template you use in flows.
How do you take other fields that aren't single line text (e.g. Numbers, and currency) currency in SPO Lists?
Hi April, how do I do this for multiple choices, some with 'multiple selection allowed' and some don't. With multiple selection allowed, responder also could also enter free text.
Hi @April Dunnam. The template in your video seems to be missing from Power Automate... I searched by title and template number and found nothing. Any chance this has been removed by Microsoft?
Additionally, it appears the "list of responses" is not available as a selection when using the "apply to all" in Power Automate (or anywhere else when using Form responses in Power Automate).
Hello! Does anyone know if it is possible to power automate a microsoft list to a microsoft form that you did NOT originally create but are a collaborator on?
Really helpful video! Do you have a video on how to get the attachments from Form to List item?
Hello April,
Thank so much for this video.
I created my a Group MS Form, which responses are loaded on SharePoint Lib and my SharePoint list was also created.
But some responses on my form are not showing up in the dynamic contents for me to match the responses to the list columns. Please How do I resolve this?
Thank you.
can you instaed doing workaround create a sharepoint list that will have form inside?
Hi April is there a function to digitally sign a form with one's signature?
Is there a way to move the columns in the form excel sheet that is generated?
Hi April. I see that the Responder Email is available as dynamic content. If the form is submitted by a user in my organization, how do I get the users name as dynamic content ro write to the sharepoint list?
Perfect explanation!!
Thank you ☺
So well explained, Thanks April
Thanks so much!
If we have to take survey of employees every month and in second month we have to prepopulate the values to form from data submitted in first month from datasource how to do it.
Thanks April, Very Helpful
You're welcome. Glad it was helpful!
Thank you so much for the video @April! Question, my company does not have permissions to use PowerAutomate just yet, how can I create the flow manually without using one of the "record responses in sharepoint" template.
Has anyone found a resource for examples with different data types? (Picklists in particular)
April, I'm having problems getting financial values and dates to work with the flow and populate the List, can you help?
Amazing video! You're a great teacher!
Thank you! 😃
I am very glad and grateful to you, that helped a lot. Thanks.
You are welcome! Glad it helped!
Fantastic. Is there a video you have on how to include the attachments from the form in the created list?
I have one question actually is there any connectors that make me update a form automatically when I add or modify a SharePoint list
Thank you for this. Quick question - How would I do this if my questions in MS Forms are radio buttons?
Thank you Just what I was trying to find.
You're welcome!
So helpful. Thank you!
Glad it was helpful!
does anyone know if i can power automate results from a MS Form to drop into MS Access?
Do you by any chance do one on ones? I am having an issue with Forms, Lists, Sharepoint
When in the 'Record Form Responses in SharePoint", will the Form ID dropdown include/show Group Forms? It doesn't show the one that I created in Group Forms. Any suggestion?
Hey Clay - To use group forms in Power Automate you'll need to select the "Enter manual value" option in the flow action and copy/paste the form ID in there. It can be found in the form URL, should see a formID= and a big long number which is the ID
The ability to have a table in forms would be great.
I agree!
Aguardando ansioso por esta melhoria!
This is just excellent. I was messing around with crappy Infopath to get some kind of sub-optimal result , but this rules.
Oh InfoPath, I remember those days :)
Great tutorial, but I need to know the quiz score in addition to the start time to calculate the duration of the assessment.
Is there any way to get this data?
Hi, how can I get Longitude & latitude of the person filling the form
What a good video, I have a concern for a problem that I have, I need that when a user has already filled out the form the message that appears is "Your response has already been sent, This form only admits one response per person." My question is if this information can be customized so that a link to another page appears
I created my first list workflow, thanks!
That's awesome!! Here's to many more workflows to come !
omg this was soooo good !! thank you very much !!👍
Glad you liked it!!
This was so helpful! Thank you!! I want the list to be private to just me and supervisors. How could I do that?
Hi April, I have run into a issue hoping you can help me with.
Someone shared the Microsoft form with edit access (which they created) with me. However when I try to use the form in my flow trigger dropdown, I cant seem to find the form. I understand this could be standard behaviour of shared forms. (If I created the form I can see it though). However requirement is that I need to use ONLY that shared form in my flow.
I then tried to implement a workaround I saw in the forum discussions. The suggestion was to use the form id part (the portion after form id - xxxx) to use that ID as a custom value in the trigger. However when I do that way, I am unable to set the dynamic values to the the sharepoint list columns. All I see is only one dynamic item "list of response notification". Can you please suggest as I am stuck
Hello April,
I want to know is it possible to add new Microsoft form in existing sharepoint list ??
If yes, could you please let me know ?
How to put restriction on date field for restricting past dates?
When creating a form to request something on a selected date, it would be useful if the date could be restricted so that only a present and future date can be selected.
Thanks in advance. Please help me on that.
Hi April! I'm running into a problem, making every step up to minute 10, and just don't get it to work. I submit the response and it stays in Power Automate with no response. Just re-do a couple of steps and didn't work.
Thanks for the video.
This is just what I needed, however, it doesn't seem to be able to match up the form option when someone submits a file, like a photo or logo, or word document. Any ideas?
Hey Jennifer! The process to extract files requires some additional steps that I outline in this video: ruclips.net/video/Xb_k8vOERpU/видео.html
Great video. I am getting an error if the data field is null in forms. can you guide how to handle this?
HELLO MAAM! CAN YOU HELP ME WITH MY FLOW? IF I ATTACH MY UPLOAD ATTACHMENTS IN FORMS THRU AUTOMATE TO OUTLOOK ITS NOT SHOWING AS ATTACHEMENT.
Great Video. How do I forward or send back the form to the individual for data correction and resubmit?
Thanks for walking us through that. really helpful
My pleasure! Glad it was helpful!
Is it possible to move MS Forms data to MS Lists if you don't have the template?
This is a wonderful video! But, I am having trouble getting my existing reports into Lists. When I run the test, I get an error message that the input parameters of my Create Item action. it is saying it needs "to be of type 'String/uri'." Do you have any idea what my issue might be? I followed your steps exactly!
Dear April, is there a way to create a Microsoft Forms using a dropdown with information from a SQL Server for example taking information from an employees table in order to get the EmployeeNumber and EmployeeName, or what do you suggest to use this, my project is to make a Quiz but i need to get information from a database on SQLServer to show some catalogs.
Why when I upload image in Microsoft Form but it didn't upload into Microsoft Lists ?
Thank you so much for this great video. Question: what if my MS form has choices? When creating the list, do I add the choices or leave that blank? Thank you!
Me again - I got the new responses to show up in my list just fine but I can't get any of the data from the Excel spreadsheet. I was having trouble with the dates so I just removed it for testing purposes and while the flow runs and creates records, there is not data in the fields. Any ideas?
Thank you for this video.
My pleasure!
Any advantage of migrating to List rather than Excel?
Great question - there are several. When we move to Lists we get lots of workflow capabilities built in to automate the data if need be with Power Automate. We also get the ability to easily collaborate, share and embed that data in a ton of places (Teams, SharePoint, Lists app, etc). And it's easy to report off of with creating views.
I updated my sharepoint lists BEFORe attempting to make the connection between forms and sharepoint list. But in the flow form (when I match the fields of sharepoint and the form) it always has the PRE-modified sharepoint list. I have no idea why or how to make it update and sync. I try hitting refresh, closing apps out, starting over with the flow and nothing changes. It happens with different sharepoint lists/forms. Have you ever seen this and know how to update? I finally learned so much from your video but can't move forward to try it!
Great video. My flow didn't work, I'm getting a message error: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Anyfeedbackfromtheclient_x003f_' is required to be of type 'Boolean'. The runtime value '"No"' to be converted doesn't have the expected format 'Boolean'. Does anyone know how to fix it?
Hi, Quick question on form sections. I have a survey with a number of different sections that are peoples names. The questions in each section are exactly the same, a scoring of 1-8. I need to have a column with "section" and then a column for the 5 questions and the values be the rating of 1-8. Any ideas?
and every row on the list be a different section - Thank you
April this is a great video as are all of your videos. Quick Question when wanting to pull in Quiz Results, how can we pull in the Final Score into the list?
You earned another subscriber
Thanks so much for the sub!
Thank you for this tutorial! I am now trying to figure out how to get responses in multiple sheets-depending on what info is entered on my form. I can't find a tutorial on how to do that.
Hi, After selecting the template "Record form responses in SharePoint and click Continue, I got an error message:
It looks like something went wrong
t.some is not a function
If you contact support, you may be asked to provide the following details:
Time: Fri, 02 Feb 2024 02:51:56 GMT
Session ID: a444a2c0-c175-11ee-b140-3d1003611557
Does it mean that the template got corrupted and is not usable anymore? Is there an alternative template?
great video, but i cant find the power automate template, is there a link to this template? tried to create, but couldnt
Is there a way that I can get the score from an MS Quiz to go to the SP list?
This was so amazing! Thank you
Glad it was helpful!
Can I send a Microsoft Form to someone external to my organization? I need a work around for using a PowerApp outside of my org...
Hey Michael -
Yes that's one of the benefits of Microsoft forms. There's a "share to collaborate" option that lets anonymous/external users view and interact with your Microsoft Forms.
Very informative. Question. One list is created and populated, is there a means to update an existing record? Or view a response in the Form format?
Hello April, how would you use the form file uploads to update the MS list? Thanks
Hi Cliff - You can grab those file uploads but there are a few steps involved. This blog article actually explains it pretty well. I'll try to make a video about it too but this should help in the mean time: blog.encodian.com/2020/04/handling-files-provided-in-a-microsoft-forms-response/
Really helpful video, thank you! I've got a question. If I use the spreadsheet created by the Form, if I was to create more columns alongside it and input data, can I create a flow to send that data to the list also?
Will try this out
Thank you 😊
You're welcome 😊