How To Save Microsoft Form Responses To A SharePoint List

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

This Power Automate tutorial will demonstrate how to create SharePoint list item from Microsoft form and how to use MS forms to populate SharePoint list. Specifically, this tutorial will demonstrate a complete
ms form to SharePoint list, MS form to SharePoint and MS form to SharePoint list flow solution. This video will present all of the steps to send Microsoft form response to SharePoint list and to save Microsoft form responses to SharePoint list. It is important to note that this video will also cover the steps to transfer MS form to SharePoint list with attachment. This MS form to SharePoint list power automate workflow can be used to populate SharePoint columns with the responses provided to Microsoft Form questions. This Microsoft form to SharePoint list power automate workflow solution will also cover how to use Expressions in Power Automate to access properties of Microsoft Form attachments that can be passed to the SharePoint list item. The
Microsoft form to SharePoint list example covered in this video considers the scenario where an organization is using Microsoft Forms to intake project proposals from employees and pass the Microsoft form response to SharePoint list. Also note that you can follow the steps in this video to save Microsoft forms multiple answers to SharePoint list. Lastly, this video will answer the following questions: how do i save Microsoft form responses to SharePoint list, how do I send Microsoft forms responses to SharePoint list, Can Microsoft Forms feed into SharePoint list?, Can you move Microsoft Forms to SharePoint?, How do I get data from Microsoft Forms to SharePoint list?, How do I create a form to populate a SharePoint list?, Can Microsoft Forms connect to SharePoint list? And How do I store Microsoft form responses in SharePoint list?.
Found this video helpful? Say thanks by "Buying Me a Coffee": bit.ly/4bgKxE3
🔔SIGN UP FOR MY SHAREPOINT LIST FUNDAMENTALS COURSE🔔:
bit.ly/3W1rkQC
GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE:
bit.ly/3Q921sH
WATCH NEXT:
How To Remove The Title Column From a SharePoint List: • How To Remove The Titl...
How To Create A Planner Task When A Microsoft Form Is Submitted: • How To Create A Planne...
Where Are Microsoft Forms Attachments Stored?: • Where Are Microsoft Fo...
How To Add Email Notifications To A SharePoint List: • How To Add Email Notif...
Timeline
0:00 - Intro
0:19 - How To Create A Microsoft Form
2:47 - How To Create A SharePoint List
7:02 - Create MS Form To SharePoint List Power Automate Workflow
11:15 - Create Power Automate workflow to pass MS form attachments to SharePoint List item
12:08 - Explanation for use of Power Automate expressions
17:43 - Testing the workflow
#microsoft #powerautomate #microsoft365
MORE ABOUT ME
Become a Channel Member & Get Access To Awesome Perks:
bit.ly/3wEuXQq
LOOKING FOR TRAINING OR CONSULTING - CONTACT ME AT:
bit.ly/3OLDmbh
LETS BE FRIENDSI
🔔Instagram: / luigiiacobellis
🔔LinkedIn: / liacobe
🔔Twitter: / luigiiacobellis
🔔TikTok: / luigiiacobellis
🔔Reddit: / owndirector1326
🔔Website: luigiiacobellis.com/
🔔Linktree: linktr.ee/Liacobellis
GOT A VIDEO IDEA? FILL OUT THIS FORM:
bit.ly/3yjEewm
SIGN UP FOR MY MONTHLY NEWSLETTER
📧 landing.mailerlite.com/webfor...

Пікірлер: 51

  • @LuiIacobellis
    @LuiIacobellis20 күн бұрын

    🔔SIGN UP FOR MY SHAREPOINT LIST FUNDAMENTALS COURSE🔔bit.ly/3S7pSLk

  • @donnygison3257
    @donnygison32578 күн бұрын

    Learned a lot in this tutorial. 👍

  • @nilp2000
    @nilp200012 күн бұрын

    awesome - many thank for the tutorial :)

  • @elizabethreyes9758
    @elizabethreyes97584 ай бұрын

    I'm not one to leave YT comments but I NEEDED to thank you!! I've been on this for weeks and kept getting error after error! The way you broke this down and explained every single step was awesome!! Again, Thank you so much for this great tutorial! You have a new subscriber 🙂

  • @LuiIacobellis

    @LuiIacobellis

    4 ай бұрын

    It's comments like these that keep me going. I'm glad you found this video helpful. Thank you for the kind words and for catching

  • @justinheath2189

    @justinheath2189

    Ай бұрын

    Same here. He is a great teacher lol

  • @TheFilipinaExpat
    @TheFilipinaExpat4 ай бұрын

    I just really wanted to say thank you because your tutorial is really helpful and super easy to understand!! Been watching tons of tutorials and i don't comment regularly but you made it very easy for a first timer to understand this!!!

  • @LuiIacobellis

    @LuiIacobellis

    3 ай бұрын

    I'm glad I could help and thank you so much for the kind words

  • @bob-kp1cf
    @bob-kp1cf6 ай бұрын

    Awesome tutorial! Not sure if it’s mentioned in your other video however it’s important to note that this won’t work if you are using a “Group Form” as was the case for me. After switching to a personal form, it worked no problem.

  • @LuiIacobellis

    @LuiIacobellis

    5 ай бұрын

    Thanks for sharing this limitation. I hadn't tested it out with a group form.

  • @blackberry233
    @blackberry2334 ай бұрын

    Great tutorial! worked like a charm.

  • @LuiIacobellis

    @LuiIacobellis

    4 ай бұрын

    Glad you found this video helpful

  • @Lopesjus
    @Lopesjus5 ай бұрын

    Best tutorial ever!

  • @LuiIacobellis

    @LuiIacobellis

    5 ай бұрын

    Glad it helped!

  • @ahpek199
    @ahpek1992 ай бұрын

    Thank you so much. It really helps a lot. Most important it is working for attachment.

  • @LuiIacobellis

    @LuiIacobellis

    Ай бұрын

    @ahpek199 You're very welcome! Thanks for watching!

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

    Amazing. Thank you so nuch for an easy to follow tutorial. Straight to the point with info on other useful linked videos. Top guy! :)

  • @LuiIacobellis

    @LuiIacobellis

    Ай бұрын

    @justinheath2189 You're very welcome! Thanks for watching!

  • @JM-oo3rb
    @JM-oo3rb5 ай бұрын

    Very informative. Just what I was looking for. It would be good to have a yes or no added to the attached file column (if added) so you can tell whether something has been uploaded.

  • @donykong1
    @donykong15 күн бұрын

    Hi Lui, thank you for the video, very informative and easy to follow. I created form and list in a shared group. However, when I set up Power Automate, I am unable to find the Group Form to add to the flow. Do you know what might have caused me to be unable to find the form? Thank you.

  • @user-uq8dq3td5g
    @user-uq8dq3td5g5 ай бұрын

    Hi Lui, Thank you for the tutorial. Helped me a lot. How do we cater for form that does not contain a file attachment as it might not be mandatory to attach it? My workflow fails at Apply to each if there is no file attached to the form.

  • @apurvapatel2623
    @apurvapatel26235 ай бұрын

    Very easy to understand. 😊

  • @LuiIacobellis

    @LuiIacobellis

    5 ай бұрын

    Glad you found it useful

  • @LuiIacobellis
    @LuiIacobellis2 ай бұрын

    Found this video helpful? Say thanks by "Buying Me a Coffee": bit.ly/4bgKxE3

  • @Maddy0616
    @Maddy06162 ай бұрын

    Great tutorial video, but in this tutorial you explained for one attachment, but in my forms I have 10 attachment questions, so in this case, what do I have to do to store all attachments on my list?

  • @blackberry233
    @blackberry2334 ай бұрын

    Do you have a tutorial on how to create a folder in sharepoint with the attachements from the MS form?

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

    Hi. I am following your tutorial and it is very helpful. I want to know the steps after Apply to Each has been selected. You move into the instructions about attachments which ae not relevant for me. At the Get file content box, which file do I select?? I cannot seem to locate any files from this Get File Contents box. Any suggestions?? Cheers J

  • @chrisvibe5146
    @chrisvibe514612 күн бұрын

    Good tutorial. Only way it works for me, however, is to toogle the "New Designer" feature everytime i run into problems. Seems power automate is a bit buggy...

  • @user-io8vq2lq6j
    @user-io8vq2lq6j8 ай бұрын

    Hi there, can you make a video teaching how to make from forms to booking to making event in shared calendar through power automate? Forms is used for multiple conditions, booking is used for time slot and event created from booking to shared calendar and its detail are from forms

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

    Hello, I am having an issue where I am unable to access the attachment question from the expressions tab

  • @rogehrify
    @rogehrify15 күн бұрын

    Unfortunately I cant use dynamic content in the bracken JSON function, program says there´s no Dynamic content Any idea how to fix it?

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

    now what about get file content from SharePoint instead of Onedrive?

  • @draushaus912
    @draushaus9125 ай бұрын

    At 8:48 in the video, you show that the dynamic content includes "Response ID". Mine says "List of response notifications". Why the difference? Why do I not have "Response ID"??

  • @LuiIacobellis

    @LuiIacobellis

    5 ай бұрын

    Are you using the new Microsoft Power Automate interface? If so, some of the connector actions operate slightly differently. I'd suggest reverting to the old interface and trying once more.

  • @Nockepilo
    @Nockepilo8 ай бұрын

    Hi! There has been a change in Power Autmation for Office 365. When im trying to choose "Get response details" and pick "Response Id" it doesn't show up. The only option that appear is "List of response notification Response Id". If i continue with this option the flow will fail. What am I doing wrong?

  • @laramartin6870

    @laramartin6870

    7 ай бұрын

    If you can, set up the flow from scratch. I had the same issue when I used a templated flow. Apparently, "List of response notifications Response Id" is for old flows which may be how the templated flow was set up.

  • @LuiIacobellis

    @LuiIacobellis

    7 ай бұрын

    Unfortunately, I am not experiencing this issue but as the comment above wrote, you want to ensure you are starting from scratch and not a template.

  • @Tom70898

    @Tom70898

    6 ай бұрын

    @@LuiIacobellisI have this same issue yet the flow is built from scratch

  • @jemimaland
    @jemimaland3 ай бұрын

    if the user does not add an attachment to the form the flow fails, what is the best way to fix this? thanks

  • @LuiIacobellis

    @LuiIacobellis

    3 ай бұрын

    There are multiple ways this can be done . One way would include updating the flow to incorporate condition or branch where there is an attachment.

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

    how to get responder name and not email?

  • @LuiIacobellis

    @LuiIacobellis

    5 ай бұрын

    Add the 'Get response details action for your form to retrieve the submission details. Use the 'Get user profile (V2) action from the office 365 Users connector. In the 'User (UPN)' field of the 'Get user profile (V2)' action, insert the dynamic content for the responder's email that you get from the 'Get response details' action. After the 'Get user profile (V2)' action, you can use the Display Name field, which will contain the name of the person corresponding to the email address of the responder This method assumes that the form is set to record the responder's name and email, which is typically the case for forms shared within an organization.

  • @tiffanybrown-singleton2931
    @tiffanybrown-singleton2931Ай бұрын

    I got no dynamics when trying to adding json to each one step. I'm new to power automate so I can't find the disconnect.

  • @paulwilliams9755

    @paulwilliams9755

    Ай бұрын

    Same problem

  • @tiffanybrown-singleton2931

    @tiffanybrown-singleton2931

    Ай бұрын

    He did skip around, mixing 2 different process steps. So frustrating but that's what get activity for comments

  • @LuiIacobellis

    @LuiIacobellis

    Ай бұрын

    Unfortunately, I've not experienced this issue. I can assure you that I don't intentionally try to make things complicated to drive comments. My goal is to try and help people solve problems as fast and clearly as I can. I have the flow package I build in this tutorial available as a free download with a doc to show you how to import it. I'd suggest trying that and see if it works.

  • @ArtVandelay1996

    @ArtVandelay1996

    Ай бұрын

    I had this same issue, were you ever able to fix it? I’m not sure what I missed.

  • @tiffanybrown-singleton2931

    @tiffanybrown-singleton2931

    29 күн бұрын

    ​@ArtVandelay1996 no, I didn't.

  • @stevep4209
    @stevep42094 ай бұрын

    Could you have just used a document library instead?

  • @LuiIacobellis

    @LuiIacobellis

    4 ай бұрын

    It's technically possible to accomplish something similar with a library. With a library however there would have to be a file attached to every response as libraries can't store data absent a file

Келесі