Move Microsoft Forms Data to Microsoft Lists

Ғылым және технология

#MicrosoftForms #MicrosoftLists
Microsoft Forms is a great tool for creating simple input forms for scenarios such as surveys, sign ups, and quizzes. In this video you'll learn how you can take your Microsoft Forms data and put it in Microsoft Lists for easy collaboration, automation and reporting.
I'll show how you can leverage Power Automate to take new forms responses and add them to your Microsoft Lists, as well as how you can take existing forms responses and add those to your list.
Table of Contents:
00:00 - Intro
01:21 - Microsoft Forms 101
02:25 - Viewing Forms Responses
03:00 - Exporting Forms Responses to Excel
03:32 - Creating a List in Microsoft Lists
05:45 - New Form Response to Lists Flow
09:29 - Testing the New Form Response to List Fl
10:31 - Get Existing Responses to Lists with Flow
Resource - Microsoft Lists in Teams 10 Minute Overview: • Microsoft Lists for Te...

Пікірлер: 249

  • @idaelrey26
    @idaelrey263 жыл бұрын

    Excellent video April! Top quality as everything you do! Thank you so much!

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Thanks for watching Idael - glad you liked it!

  • @bukmba
    @bukmba3 жыл бұрын

    There aren't many people who explain better than you. Thank you.

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Thanks Bernd!

  • @wezjy
    @wezjy4 ай бұрын

    After many several videos this one was the right video. Thank you for the great video you have.

  • @blackchristiangeek
    @blackchristiangeek Жыл бұрын

    This my friend was a much needed lifesaver and earned you another subscriber. Thank you and God bless.

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Thanks so much for the sub!

  • @kirankumarl3111
    @kirankumarl31113 жыл бұрын

    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

    @AprilDunnam

    3 жыл бұрын

    Yay! Great to hear that this video helped get your process working!

  • @sonya5568
    @sonya55683 жыл бұрын

    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

    @AprilDunnam

    3 жыл бұрын

    Glad this video is helping you work smarter not harder Sonya :) Thanks for watching!

  • @toarahie
    @toarahie3 жыл бұрын

    This was great and EXACTLY what I was looking for! Thank you!

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Glad it was helpful!

  • @kofi-tawiahagyeman
    @kofi-tawiahagyeman3 жыл бұрын

    Wooooaaaaaw! Just what I needed. Love you Dunnam!

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Sweet!

  • @mindyskidder
    @mindyskidder3 ай бұрын

    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!

  • @sverkerleschzyk2993

    @sverkerleschzyk2993

    Ай бұрын

    It doesn't work for me any tips ?

  • @mararamitchpeace
    @mararamitchpeace Жыл бұрын

    She-ro! Thank you soo much. You made creating an automatic flow for my event registration so easy! 🥰

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Yay! You are so welcome! Glad I could help make it easy! 🙂

  • @missahfly
    @missahfly2 жыл бұрын

    You are awesome! Finally found a video that is high quality and straighfoward.

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Thank you!

  • @superimager3105
    @superimager31053 жыл бұрын

    Thanks for walking us through that. really helpful

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    My pleasure! Glad it was helpful!

  • @dnbtexas
    @dnbtexasАй бұрын

    Thank you for helping find a better way!

  • @AprilDunnam

    @AprilDunnam

    26 күн бұрын

    Happy to help!

  • @gacekigor1068
    @gacekigor10682 жыл бұрын

    Hi, This was very helpful. I also liked the trimming of the video and that is presented at a steady pace. Thank you.

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Glad you enjoyed it!

  • @browndindy5069
    @browndindy50693 жыл бұрын

    This was so amazing! Thank you

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Glad it was helpful!

  • @challasubrahmanyam2900
    @challasubrahmanyam2900 Жыл бұрын

    All your videos about Flows are so much helpful...Thank you so much... looking for more and more

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    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

  • @challasubrahmanyam2900

    @challasubrahmanyam2900

    Жыл бұрын

    @@AprilDunnam Thank you April. Looking forward to watch and implement the same wherever that fits. Thank you again.

  • @Happykay5722
    @Happykay5722 Жыл бұрын

    So helpful. Thank you!

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Glad it was helpful!

  • @gigi5gls
    @gigi5gls7 ай бұрын

    Excellent tutorial!!!! Very helpful....THANK YOU!!!!😊

  • @AprilDunnam

    @AprilDunnam

    6 ай бұрын

    Thanks so much! I'm very glad to hear it was helpful 🙂

  • @soosnatachowdhury8974
    @soosnatachowdhury8974 Жыл бұрын

    April, much appreciate your content which is allowing me to effectively apply systems to master time efficiency. Keep up the good work.

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    I'm so happy to hear that! Thank you!

  • @soosnatachowdhury8974

    @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.

  • @eliace5677
    @eliace56773 жыл бұрын

    Awesome.. thanks i will try right away next week... easy to follow up..

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Good luck!

  • @dineetamang1709
    @dineetamang17092 жыл бұрын

    Thank you Just what I was trying to find.

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    You're welcome!

  • @GavinScrimgeour
    @GavinScrimgeour2 жыл бұрын

    That's a brilliant video - many thanks for that, it's answered a few questions for me.

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Glad it was helpful!

  • @accmasmali
    @accmasmali Жыл бұрын

    I am very glad and grateful to you, that helped a lot. Thanks.

  • @AprilDunnam

    @AprilDunnam

    11 ай бұрын

    You are welcome! Glad it helped!

  • @ivanrobles6360
    @ivanrobles63603 ай бұрын

    Very useful content. and easy to follow. Thank you, Thank you Thank you!

  • @AprilDunnam

    @AprilDunnam

    3 ай бұрын

    Thanks so much. I"m very glad to hear it was easy to follow 🙂

  • @fannybrisker5797
    @fannybrisker5797 Жыл бұрын

    I created my first list workflow, thanks!

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    That's awesome!! Here's to many more workflows to come !

  • @Lucas-qp7ey
    @Lucas-qp7ey2 жыл бұрын

    Thank you for this video.

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    My pleasure!

  • @markoepolo8835
    @markoepolo88352 жыл бұрын

    Amazing video! You're a great teacher!

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Thank you! 😃

  • @Bodywreath
    @Bodywreath2 жыл бұрын

    This works! thank you so much!!!

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Awesome! You're welcome!

  • @Jayjayvn
    @Jayjayvn2 ай бұрын

    Perfect explanation!!

  • @AprilDunnam

    @AprilDunnam

    2 ай бұрын

    Thank you ☺

  • @itsRohitJain
    @itsRohitJain Жыл бұрын

    So well explained, Thanks April

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Thanks so much!

  • @anraki013
    @anraki0132 жыл бұрын

    Thanks April, Very Helpful

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    You're welcome. Glad it was helpful!

  • @ResponsibleXI
    @ResponsibleXI3 жыл бұрын

    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

    @AprilDunnam

    3 жыл бұрын

    Thanks for the feedback Ramesh, I'll consider that for a future video

  • @marlontorres956
    @marlontorres9562 жыл бұрын

    unbelievable, excellent video. I'm really impressed. Greetings from Brazil

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Thank you! Cheers!

  • @DianaLopez-ow4wq
    @DianaLopez-ow4wq2 жыл бұрын

    omg this was soooo good !! thank you very much !!👍

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Glad you liked it!!

  • @renzokouken9781
    @renzokouken97813 жыл бұрын

    Will try this out Thank you 😊

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    You're welcome 😊

  • @Moker2012
    @Moker2012 Жыл бұрын

    This is just excellent. I was messing around with crappy Infopath to get some kind of sub-optimal result , but this rules.

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Oh InfoPath, I remember those days :)

  • @paolovr1970
    @paolovr197011 ай бұрын

    ILY thanks again April

  • @AprilDunnam

    @AprilDunnam

    11 ай бұрын

    You're welcome!

  • @parazita109
    @parazita1093 жыл бұрын

    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 !

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Thank you! Glad this helped you find what you were looking for!

  • @louiseanderson7802
    @louiseanderson78022 жыл бұрын

    Awesome, thankyou so much, I've been stuck trying to get form data already entered into lists

  • @AprilDunnam

    @AprilDunnam

    2 жыл бұрын

    Glad I could help get you unstuck!

  • @oluwatobiyusuf
    @oluwatobiyusuf Жыл бұрын

    Thanks for this awesome content

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Thank you for the support!

  • @ITsEasyTraining1st
    @ITsEasyTraining1st3 жыл бұрын

    Very good explantion

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Thanks!

  • @ruthypaulgreenwood6210
    @ruthypaulgreenwood62102 жыл бұрын

    Really helpful video! Do you have a video on how to get the attachments from Form to List item?

  • @lachiaralandrum7271
    @lachiaralandrum7271 Жыл бұрын

    Thanks!

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Thank you so much!!

  • @jacqueskagabo928
    @jacqueskagabo928 Жыл бұрын

    You earned another subscriber

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Thanks so much for the sub!

  • @SS-cd1dl
    @SS-cd1dl3 жыл бұрын

    The ability to have a table in forms would be great.

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    I agree!

  • @12agora

    @12agora

    3 жыл бұрын

    Aguardando ansioso por esta melhoria!

  • @anilkodakkadan
    @anilkodakkadan3 жыл бұрын

    Excellent video

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Thank you very much!

  • @kimkiefer4210
    @kimkiefer42102 жыл бұрын

    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?

  • @davidcooper-nx4yg
    @davidcooper-nx4yg3 жыл бұрын

    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?

  • @HinaGeo
    @HinaGeo2 жыл бұрын

    Thank you for the great video. Can you please guide how we import attachments along with responses data? Thanks

  • @brad4d2
    @brad4d22 жыл бұрын

    April, this was great! It's going to help a lot. One question... Is there a way I can group by the title field in my list?

  • @PearlHarborNationalMemorial
    @PearlHarborNationalMemorial2 жыл бұрын

    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.

  • @theodorelai4694
    @theodorelai4694 Жыл бұрын

    I LOVE YOU THANK YOU

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Thank you!

  • @leoheidner215
    @leoheidner2153 жыл бұрын

    Thank you for this great tutorial. Is there a way to create a form to be used by all members of my team so they can send the form to our clients and collect the responses in the same microsoft lists? or each team member will have to have to setup this flow separately?

  • @deniseortiz8567
    @deniseortiz85673 жыл бұрын

    FAN GIRL! Thank you! Women in TECH ROCK!!

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Thanks Denise! I agree, women in tech rock, we need more :)

  • @jamesluc4138
    @jamesluc4138 Жыл бұрын

    Fantastic. Is there a video you have on how to include the attachments from the form in the created list?

  • @Kocopelli11
    @Kocopelli113 жыл бұрын

    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?

  • @linejungpedersen9514
    @linejungpedersen95143 жыл бұрын

    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?

  • @lucaslegz
    @lucaslegz2 жыл бұрын

    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!

  • @austynries
    @austynries Жыл бұрын

    This was so helpful! Thank you!! I want the list to be private to just me and supervisors. How could I do that?

  • @rahelwubshet2797
    @rahelwubshet27973 жыл бұрын

    Excellent presentation. I followed the instruction, but my data from the form not populated in the list. with Instant flow as well; though the run was a success.

  • @debbieramirez2463
    @debbieramirez24632 жыл бұрын

    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.

  • @rajshunmugavelu8281
    @rajshunmugavelu82812 жыл бұрын

    Great Video. How do I forward or send back the form to the individual for data correction and resubmit?

  • @mnabutovsky
    @mnabutovsky3 жыл бұрын

    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?

  • @davidadams421
    @davidadams4213 жыл бұрын

    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

    @AprilDunnam

    3 жыл бұрын

    Thanks for the suggestion David

  • @bublb2992
    @bublb29923 жыл бұрын

    thank you :) earn a sub. :)

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Awesome thanks for the sub!

  • @gordonresquer4604
    @gordonresquer4604 Жыл бұрын

    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?

  • @adelangel777
    @adelangel7773 жыл бұрын

    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.

  • @carlhollier9182
    @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?

  • @rafaelaldape6711
    @rafaelaldape6711 Жыл бұрын

    Fue tan perfecta la explicación que aun que no sepas ingles entiendes jeje

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    Estoy feliz de que haya sido fácil de seguir sin importar el idioma que hables 🙂

  • @alexlam5766
    @alexlam57662 жыл бұрын

    Thank You!! it would be great if you can show us How to send SharePoint List Item Attachment in Email Notification using Microsoft Flow

  • @theodorelai4694
    @theodorelai4694 Жыл бұрын

    MY GOAT

  • @AprilDunnam

    @AprilDunnam

    Жыл бұрын

    😍

  • @sleepycmo
    @sleepycmo3 жыл бұрын

    Can’t thank you enough for this video! Question, now that I have it stored into Lists, I want to view the information in a graphical way. How would I do this ? Power BI? And how would I create a flow that adds additional information after it has been submitted? I know I ask a lot but you have a clear and easy to understand tutorial and would love to see this in action . Thanks again!!!!

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    You're very welcome! As far as viewing the data, PowerBI is probably the easiest approach. You could also leverage SharePoint list formatting to show custom visuals in the list itself as shown here: github.com/pnp/sp-dev-list-formatting/tree/master/view-samples/column-graph-format As far as getting additional info there after it's submitted, there's a second flow you would want to create for that. There's actually a template for it that you can search for to setup. I think it's something like "Forms data to SharePoint". That will create an item in the SharePoint list every time a new entry is added in the Forms. I'll see about creating a video on the scenario at some point too.

  • @reidmyers5922
    @reidmyers59223 жыл бұрын

    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!

  • @YeshuKaChela
    @YeshuKaChela Жыл бұрын

    Thank you for this. Quick question - How would I do this if my questions in MS Forms are radio buttons?

  • @kanwalsingh2802
    @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.

  • @storiesstudio24
    @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

  • @juancarlosolartecorrea6479
    @juancarlosolartecorrea64792 жыл бұрын

    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

  • @bastis3008
    @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!

  • @45rangers67
    @45rangers673 жыл бұрын

    Is there a way that I can get the score from an MS Quiz to go to the SP list?

  • @olahenningsson6949
    @olahenningsson69493 жыл бұрын

    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

    @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

  • @CedesHawkins
    @CedesHawkins9 ай бұрын

    Do you by any chance do one on ones? I am having an issue with Forms, Lists, Sharepoint

  • @jenruel6068
    @jenruel6068 Жыл бұрын

    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.

  • @mr.mrs.gebeyehou674
    @mr.mrs.gebeyehou6742 жыл бұрын

    Is there a way to move the columns in the form excel sheet that is generated?

  • @tolulopeesho852
    @tolulopeesho8526 ай бұрын

    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.

  • @brinnleach-wilson5768
    @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.

  • @marzannerautenbachoccupati5546
    @marzannerautenbachoccupati5546 Жыл бұрын

    Hi April is there a function to digitally sign a form with one's signature?

  • @mazlinadiuk
    @mazlinadiuk3 жыл бұрын

    great video, but i cant find the power automate template, is there a link to this template? tried to create, but couldnt

  • @user-pe9gf3zd2l
    @user-pe9gf3zd2l5 ай бұрын

    other then the website where the form is filled and results are stored is data somewhere on my onedrive or?

  • @marienaalvarez8235
    @marienaalvarez82353 жыл бұрын

    Hi April. This is great. How do I save a quiz points in Sharepoint

  • @monterrosa64
    @monterrosa643 жыл бұрын

    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

    @ensarguler7684

    Жыл бұрын

    Good question. Did you find the answer?

  • @monterrosa64

    @monterrosa64

    Жыл бұрын

    @@ensarguler7684 no, i didnt

  • @tbone536
    @tbone5363 жыл бұрын

    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

    @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.

  • @sunilg7648
    @sunilg76482 жыл бұрын

    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?

  • @fiqahhamed8549
    @fiqahhamed85493 жыл бұрын

    Great video. Can I know, if there is possible to download in excel form through Microsoft list?

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Hey - yes Microsoft Lists have built-in functionality that enables you to export to Excel. You should see in the toolbar an option called "Export to CSV" to do that

  • @carlosm5591
    @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!!

  • @user-pe9gf3zd2l
    @user-pe9gf3zd2l5 ай бұрын

    can you instaed doing workaround create a sharepoint list that will have form inside?

  • @christinepowers2357
    @christinepowers23572 жыл бұрын

    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.

  • @ChuckSteel
    @ChuckSteel3 жыл бұрын

    Another way to process existing form responses is to grab them directly from the Common Data Service using the List Records action. Use Entity Name of Customer Voice survey responses with the following filter query: msfp_sourcesurveyidentifier eq '' The results can be used in an apply to each control to get the form response details.

  • @AprilDunnam

    @AprilDunnam

    3 жыл бұрын

    Hi Chuck - Isn't that just for Microsoft Forms PRO?

  • @ChuckSteel

    @ChuckSteel

    3 жыл бұрын

    @@AprilDunnam I'm fairly certain it will work for both Forms and Forms Pro (now Customer Voice).

  • @KayleighCarrillo
    @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?

  • @gabrielferreiraguimaraes2092
    @gabrielferreiraguimaraes20928 ай бұрын

    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?

  • @shahidrasool1052
    @shahidrasool105211 ай бұрын

    Great video. I am getting an error if the data field is null in forms. can you guide how to handle this?

Келесі