This my friend was a much needed lifesaver and earned you another subscriber. Thank you and God bless.
@AprilDunnam
2 жыл бұрын
Thanks so much for the sub!
@kirankumarl3111
3 жыл бұрын
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. :)
@AprilDunnam
3 жыл бұрын
Yay! Great to hear that this video helped get your process working!
@ResponsibleXI
4 жыл бұрын
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?
@AprilDunnam
4 жыл бұрын
Thanks for the feedback Ramesh, I'll consider that for a future video
@mararamitchpeace
Жыл бұрын
She-ro! Thank you soo much. You made creating an automatic flow for my event registration so easy! 🥰
@AprilDunnam
Жыл бұрын
Yay! You are so welcome! Glad I could help make it easy! 🙂
@idaelrey26
4 жыл бұрын
Excellent video April! Top quality as everything you do! Thank you so much!
@AprilDunnam
4 жыл бұрын
Thanks for watching Idael - glad you liked it!
@deniseortiz8567
3 жыл бұрын
FAN GIRL! Thank you! Women in TECH ROCK!!
@AprilDunnam
3 жыл бұрын
Thanks Denise! I agree, women in tech rock, we need more :)
@SS-cd1dl
3 жыл бұрын
The ability to have a table in forms would be great.
@AprilDunnam
3 жыл бұрын
I agree!
@12agora
3 жыл бұрын
Aguardando ansioso por esta melhoria!
@ruthypaulgreenwood6210
2 жыл бұрын
Really helpful video! Do you have a video on how to get the attachments from Form to List item?
@marlontorres956
2 жыл бұрын
unbelievable, excellent video. I'm really impressed. Greetings from Brazil
@AprilDunnam
2 жыл бұрын
Thank you! Cheers!
@soosnatachowdhury8974
Жыл бұрын
April, much appreciate your content which is allowing me to effectively apply systems to master time efficiency. Keep up the good work.
@AprilDunnam
Жыл бұрын
I'm so happy to hear that! Thank you!
@soosnatachowdhury8974
Жыл бұрын
@@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.
@accmasmali
Жыл бұрын
I am very glad and grateful to you, that helped a lot. Thanks.
@AprilDunnam
Жыл бұрын
You are welcome! Glad it helped!
@gigi5gls
9 ай бұрын
Excellent tutorial!!!! Very helpful....THANK YOU!!!!😊
@AprilDunnam
9 ай бұрын
Thanks so much! I'm very glad to hear it was helpful 🙂
@spongebobby188
3 ай бұрын
Anything that takes more than 1 min to watch or implement is too complex and off-putting. I'll stick with accessing my data by downloading from Forms direct into Excel.
@Moker2012
Жыл бұрын
This is just excellent. I was messing around with crappy Infopath to get some kind of sub-optimal result , but this rules.
@AprilDunnam
Жыл бұрын
Oh InfoPath, I remember those days :)
@toarahie
3 жыл бұрын
This was great and EXACTLY what I was looking for! Thank you!
@AprilDunnam
3 жыл бұрын
Glad it was helpful!
@lucaslegz
2 жыл бұрын
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!
@debbieramirez2463
3 жыл бұрын
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.
@DianaLopez-ow4wq
2 жыл бұрын
omg this was soooo good !! thank you very much !!👍
@AprilDunnam
2 жыл бұрын
Glad you liked it!!
@davidcooper-nx4yg
3 жыл бұрын
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?
@davidadams421
3 жыл бұрын
Great video. RE importing existing Excel data, copy/paste in Grid view would be easier and a lot quicker than using a workflow. Not sure if there are any clipboard limits but I just tested 100 rows with 5 columns and it worked just fine. Hope this helps.
@AprilDunnam
3 жыл бұрын
Thanks for the suggestion David
@tolulopeesho852
8 ай бұрын
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.
@kimkiefer4210
2 жыл бұрын
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?
@GavinScrimgeour
3 жыл бұрын
That's a brilliant video - many thanks for that, it's answered a few questions for me.
@AprilDunnam
3 жыл бұрын
Glad it was helpful!
@brinnleach-wilson5768
Жыл бұрын
A video on different column types would have been great because my form has dropdowns and radio buttons and none of those fields populated on the list.
@oluwatobiyusuf
Жыл бұрын
Thanks for this awesome content
@AprilDunnam
Жыл бұрын
Thank you for the support!
@bukmba
3 жыл бұрын
There aren't many people who explain better than you. Thank you.
@AprilDunnam
3 жыл бұрын
Thanks Bernd!
@anraki013
3 жыл бұрын
Thanks April, Very Helpful
@AprilDunnam
3 жыл бұрын
You're welcome. Glad it was helpful!
@olahenningsson6949
3 жыл бұрын
Another great video, thank you April. I've got a Forms shared in a Teams and can't find it in Power Automate, only Forms that is mine. Am I missing something or isn't it possible?
@AprilDunnam
3 жыл бұрын
Hey Ola - Great question and probably something I should have mentioned in the video come to think of it... By default only forms you've created show in the dropdown in Power Automate BUT you can reference Teams forms by clicking on the "Enter manual value" dropdown option and copying and pasting in the Form ID in. You can get the form ID by opening the form and copying what's after the "ID" parameter
@SusanKelly05
Жыл бұрын
How do you take other fields that aren't single line text (e.g. Numbers, and currency) currency in SPO Lists?
@criticalwill5875
2 жыл бұрын
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?
@criticalwill5875
2 жыл бұрын
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).
@reidmyers5922
3 жыл бұрын
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!
@markmoscosa2371
3 жыл бұрын
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.
@Kocopelli11
3 жыл бұрын
Thank you for your tutorials. They help a lot! I'm stuck trying to get two different forms to complete a record in in a SharePoint list. I know I may not be the only one with this type of problem. Can you help us?
@PearlHarborNationalMemorial
2 жыл бұрын
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.
@jeetbains8888
Жыл бұрын
Hi, how can I get Longitude & latitude of the person filling the form
@sanjjoyrio3745
Жыл бұрын
I have one question actually is there any connectors that make me update a form automatically when I add or modify a SharePoint list
@carlosm5591
Жыл бұрын
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!!
@Barbara-xz6nm
Жыл бұрын
Is it possible to move MS Forms data to MS Lists if you don't have the template?
@monterrosa64
3 жыл бұрын
Hi April. it is a wonderful presentation and very helpful. Question: How can I move MS forms data including points, total points and feedback for Quiz type of questions? appreciate your response
@ensarguler7684
Жыл бұрын
Good question. Did you find the answer?
@monterrosa64
Жыл бұрын
@@ensarguler7684 no, i didnt
@diarmuid9866
3 жыл бұрын
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!
@robwin0072
7 ай бұрын
Hello, April. Can you refer the company or person who created your fly-in laptop computer with the specific Video Name on the laptop screen?
@sergiomogollon9777
8 ай бұрын
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?
@dodoitdave1346
3 жыл бұрын
Any advantage of migrating to List rather than Excel?
@AprilDunnam
3 жыл бұрын
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.
@testingcommissioning7556
3 жыл бұрын
This is great! one question, how can I move Group Form instead of personal Form to Microsoft List?
@KevinLaw091
2 жыл бұрын
Yes this was my exact question. I don’t mind using personal forms but the issue is when I’m posting attachments like photos collected in the form the the MS list… the photos are stored in my personal one drive vs the SharePoint directory
@tbone536
3 жыл бұрын
Excellent video! Now, how can we build in the automation to take this list data, and generate a printable .pdf document for for archiving purposes? I have seen other examples, but none that have really knocked my socks off yet. :)
@AprilDunnam
3 жыл бұрын
So to do that you pretty much have to use the OneDrive connector in Power Automate. You can add an Apply to each and add the data into a table in Power Automate as HTML. Then use the OneDrive connector to create an HTML file from that table data then convert that to a PDF with the OneDrive connector as well.
@linejungpedersen9514
3 жыл бұрын
Great guide. Do you know if it is possible to share who has filled in the forms, in the list? At work Microsoft registers who we are from our MS-profile, so it would be great if we didn't have to write our name or initials as part of the forms' questions. We share who is attending certain events, and there it would be nice to directly share who has responded to the forms in a list. Does the question make sense?
@adelangel777
3 жыл бұрын
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.
@lencastro8109
5 ай бұрын
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.
@coopertichenor7912
2 жыл бұрын
Has anyone found a resource for examples with different data types? (Picklists in particular)
@TheDizzleChannel
Жыл бұрын
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!
@PatsSpats
Жыл бұрын
It amazes me how utterly complicated Microsoft makes processes like this. How might Microsoft take some cues from Airtable and just create form views in their Lists solution that can be shared externally and completely erase the middle man (Power Automate) to instantly retrieve data? So annoying.
@alexlam5766
2 жыл бұрын
Thank You!! it would be great if you can show us How to send SharePoint List Item Attachment in Email Notification using Microsoft Flow
@robh2489
2 жыл бұрын
April, I'm having problems getting financial values and dates to work with the flow and populate the List, can you help?
@vvaassaanntthh
Жыл бұрын
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
@clayfisher3194
3 жыл бұрын
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?
@AprilDunnam
3 жыл бұрын
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
@24zomaar
2 ай бұрын
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.
@christinepowers2357
2 жыл бұрын
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.
@skrappappap2130
8 ай бұрын
Why when I upload image in Microsoft Form but it didn't upload into Microsoft Lists ?
@sunilg7648
3 жыл бұрын
This is a helpful video for us. Is it possible to get all the data from Microsoft forms like google drive? One more question some times SharePoint list is not updating from Microsoft forms. Is it possible to debug without power Auto access?
@piroskaszandi3048
2 жыл бұрын
Hi April, You video is really helpful, thank you very much for sharing it. I went through the whole thing step by step. I have a couple of responses from my Form and I wanted to move them to my List, but at the very end my test failed. These are the error details I've got: "The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Reportingdeadline_x003a_' is required to be of type 'String/date'. The runtime value '"44804"' to be converted doesn't have the expected format 'String/date'." At the very last step I added my SP List URL to the site address (it was a custom value, not from the drop down, because I didn't find a suitable option there) and in only that case I could choose the particular list from the drop down. Was that the problem? Do you have an idea how can I fix it? Thank you very much for your response in advance.
@techdrift73
Жыл бұрын
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?
@tejashulawale5092
Жыл бұрын
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 ?
@JohnGoodwin0426
2 жыл бұрын
Yes no and crop down/check lists do not seem to map at all. Also what about extra field that are part of the Form's Excel file that are extraneous? Great video BTW
@GinoFerreri
11 ай бұрын
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.
@austynries
Жыл бұрын
This was so helpful! Thank you!! I want the list to be private to just me and supervisors. How could I do that?
@angadm27
2 жыл бұрын
Thank you for this. Quick question - How would I do this if my questions in MS Forms are radio buttons?
@juancarlosolartecorrea6479
3 жыл бұрын
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
@theodorelai4694
Жыл бұрын
MY GOAT
@AprilDunnam
Жыл бұрын
😍
@KayleighCarrillo
Жыл бұрын
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?
@kanwalsingh2802
Жыл бұрын
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.
@JenniferHilgendorf
3 жыл бұрын
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?
@AprilDunnam
3 жыл бұрын
Hey Jennifer! The process to extract files requires some additional steps that I outline in this video: kzitem.info/news/bejne/uZiV0WysiHeDo4o
@RolandoQuinteroF
3 жыл бұрын
The proposed power automate template is not longer available.
@AprilDunnam
3 жыл бұрын
I still see it in my tenant. I wonder if it's a region issue
@tytyterrell
2 жыл бұрын
It is truly ridiculous that there isn’t integration within Forms to direct the data to a List. Way too many hoops to accomplish something that should be easily integrated to their existing products
@gabrielferreiraguimaraes2092
11 ай бұрын
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?
@ajayv2632
2 жыл бұрын
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.
@CedesHawkins
11 ай бұрын
Do you by any chance do one on ones? I am having an issue with Forms, Lists, Sharepoint
@shiningfever3476
4 ай бұрын
why at part 7:11 , mine showed invalid parameters and when click the dropdown menu, it stated 'no item'
@FenixFenix-p5p
7 ай бұрын
can you instaed doing workaround create a sharepoint list that will have form inside?
@louiseanderson7802
2 жыл бұрын
Awesome, thankyou so much, I've been stuck trying to get form data already entered into lists
@AprilDunnam
2 жыл бұрын
Glad I could help get you unstuck!
@45rangers67
3 жыл бұрын
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?
@marzannerautenbachoccupati5546
2 жыл бұрын
Hi April is there a function to digitally sign a form with one's signature?
@newell63
3 жыл бұрын
does anyone know if i can power automate results from a MS Form to drop into MS Access?
@carlosfarace6889
3 жыл бұрын
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?
@shahidrasool1052
Жыл бұрын
Great video. I am getting an error if the data field is null in forms. can you guide how to handle this?
@leeannwiggins520
3 жыл бұрын
Hi April, Great video! I have an issue with MS forms and dates that are not required. Trying to automate to my Sharepoint list and receive an error because the date field is blank. I'm a beginner, any specific instructions how to get around it?
@AprilDunnam
3 жыл бұрын
Hi Lee Ann - When you're using the "Create Item" action for SharePoint in Power Apps it does force it to where you have to fill in any required fields in your list. The only way around this is to go to your SharePoint lists and make those fields not required or to put in a placeholder value in those required fields. You can see how to set/unset required fields in SharePoint with this article : lydonsolutions.com/2017/04/21/configure-required-fields-sharepoint/
@jenruel6068
2 жыл бұрын
You are a great presenter and easy to learn from! Can you tell me how I can fix the following error? "This may indicate invalid input parameters. Error response: The form ID in request URL is invalid.'. I was able to use the connector at first but then had to delete the Teams channel and List button from the SharePoint Site. Did I ruin the flow by doing that? I keep trying to recreate the form and list but Power Automate can't find the Form ID.
@sonya5568
3 жыл бұрын
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!!!
@AprilDunnam
3 жыл бұрын
Glad this video is helping you work smarter not harder Sonya :) Thanks for watching!
@gordonresquer4604
2 жыл бұрын
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?
@FenixFenix-p5p
7 ай бұрын
other then the website where the form is filled and results are stored is data somewhere on my onedrive or?
@eliace5677
3 жыл бұрын
Awesome.. thanks i will try right away next week... easy to follow up..
@AprilDunnam
3 жыл бұрын
Good luck!
@storiesstudio24
Жыл бұрын
Hello April, Your knowledge and sessions are really very effective. I would like to take your support on one of my Queries. Could you please let me know, how to set autofill option in MS Forms while taking details of an employee? Like, Just enter the UIN Number and rest his information gets autofilled, like, Name, Email Address etc.. Looking forward your help on it. Thanks
@bastis3008
Жыл бұрын
Hi, great video. Is it also possible to fill the form with multiple people based on certain entries within the form? So as example the form should go through a whole department consisting of 6 groups and each group needs to fill in information in the form and then the form is send to the next group until all 6 groups have entered their information. It could also be that based on certain form entries that only lets say 4 out of the 6 groups need to enter information, so there should be also different branches to steer the form through the needed groups. Thanks in advance!
@carlhollier9182
Жыл бұрын
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?
@findthetruth3021
3 жыл бұрын
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.
@srahimi5007
2 жыл бұрын
22 Questions : 1 - do you need to do some kind of conversion to move a from a form (DATE) into a field in a SharePoint List (TEXT) ? For attachments s that have been attached in the Form , how do you deal with that in the Power App ?
@bublb2992
3 жыл бұрын
thank you :) earn a sub. :)
@AprilDunnam
3 жыл бұрын
Awesome thanks for the sub!
@kofi-tawiahagyeman
3 жыл бұрын
Wooooaaaaaw! Just what I needed. Love you Dunnam!
@AprilDunnam
3 жыл бұрын
Sweet!
@JimHall-k1p
Күн бұрын
perfect
@mnabutovsky
3 жыл бұрын
This video was very helpful! I'm trying to add a another column to calculate the number of times a word (ex: yes) appears within a row. (Important not column but row). In Excel I would use the countif. How can I do this in sharepoint lists?
@SplendidMoose
3 жыл бұрын
Will this work with forms that do not have open lines of text? Most of our forms use choices instead.
@AprilDunnam
3 жыл бұрын
Hey Martin - yes this will work for forms that have choice fields as well. The process is the same, just map the field in the form to an associated field in your Microsoft list. Obviously you'll just need to make sure that the choice values in your Microsoft list field match what's in the form
Пікірлер: 251