Power Automate - Insert MS Forms Responses to Excel Table in SharePoint!

Поделиться
HTML-код
  • Опубликовано: 31 янв 2025

Комментарии • 31

  • @jibbsautomations
    @jibbsautomations  2 года назад +3

    Check out the next video which builds off of this flow! ruclips.net/video/UzRe2T0ii8o/видео.html
    🤝 Need help implementing this flow? Let’s connect! www.jeremybarden.com/automation-consulting

  • @oviefredericksimon9483
    @oviefredericksimon9483 Год назад +2

    Thank you, this video was massively helpful. I was stranded for 2 hours at work

  • @constable905
    @constable905 4 месяца назад +1

    This helped to fill in a gap for me. Thanks!

  • @ranjithlanka8800
    @ranjithlanka8800 Год назад +1

    Useful video. I am struggling at one point to download everytime I had new responses. Now with Power Automate, things make very easier.

  • @constantinadrianpopescu6155
    @constantinadrianpopescu6155 Год назад +1

    Great video! Thanks so much for your help!

  • @calendil
    @calendil 5 месяцев назад +1

    thank you, I was stuck for a couple of ours.

  • @alvesthearthur
    @alvesthearthur Год назад +1

    Thks a lot!

  • @ingridlee6095
    @ingridlee6095 9 дней назад

    Is it possible to popluate data from Excel into dropdown list on MS forms?
    If yes, how to do it?

  • @reneenyong4638
    @reneenyong4638 Год назад +1

    hii! thanks for the great video! wanted to ask is there any way to generate template based on user choice
    1. user fill up a microsoft form to select which template they want
    2. there is a sharepoint that will locate over 1000 of word templates
    3. based on user choice, the word template will be populated with their information
    And the placeholder for all templates is the same
    i am facing trouble to handle the dynamicfileschema, it would be great if you can do a vid on this topic! thanks a lot

    • @jibbsautomations
      @jibbsautomations  Год назад +1

      Hi! Thanks for posting. I can somewhat visualize that flow. I'm working through some other projects atm, but if you can get something started and shared in the PA community we can probably get you the rest of the way. All the best!

  • @vickyforthune5541
    @vickyforthune5541 Год назад +1

    Hello. Please it is posible to direct Microsoft reponses from differents forms directly in an excel excel

    • @jibbsautomations
      @jibbsautomations  Год назад +1

      Hi! Thanks for posting. Yes, that is possible, you just need to have the right headers in your excel table to accomodate all of the various fields from your forms.

  • @jpsville
    @jpsville 3 месяца назад +1

    When I select the table name, for some reason I am not getting the prompt to map the headers. Can anybody help me with this please. I have tried everything I could but can't seem to fix this issue

    • @jibbsautomations
      @jibbsautomations  Месяц назад +1

      Hi, sorry for the late reply. Did you get this sorted out? Did you try switching to classic designer? Sometimes that solves buggy things with power automate.

  • @carlacarapaica1944
    @carlacarapaica1944 Год назад +1

    Hello! I followed these steps and I was able to create the flow. Nonetheless, the new row I´m getting is not going to the last row but to a random one. Do you know how to fix this?

    • @jibbsautomations
      @jibbsautomations  Год назад +1

      Hi Carla, thanks for reaching out. Can you post on Power Automate Community with screenshots of your issue and tag @jibbs ? I will take a look over there!

  • @anashassan1
    @anashassan1 Год назад +1

    Hello. I just found your video. Really hoping you can help me. I failed on the first step to link the Form ID. First issue, I am the creator of the form, but for some reason, the system did not detect the form in the list of forms. Secondly, I tried to copy & paste the Form ID (the code after '=' in address bar) into the action box, but the system return with 'Invalid connection, please update your connection to load complete details' notice.

    • @jibbsautomations
      @jibbsautomations  11 месяцев назад

      Hi, thanks for posting. Were you able to find a solution? If you can post over in the PA Community with screenshots, I think we can resolve your issue.

  • @danteoneplusone2977
    @danteoneplusone2977 Год назад +1

    Hello. And what about when response is editted?

    • @jibbsautomations
      @jibbsautomations  Год назад +1

      Hi, this will only add the responses to the table once submitted. If someone wanted to edit their response, they would have to submit the form again.

  • @ardikasulistija5541
    @ardikasulistija5541 Год назад +1

    I have everything set up the same way. The flow runs successfully, but the excel sheet never gets updated :( any idea??

    • @jibbsautomations
      @jibbsautomations  Год назад +1

      thanks for posting. If you can post with more details in Power Automate Community and tag @jibbs, I can take a look over there.

  • @surachetsripaoraya1387
    @surachetsripaoraya1387 6 месяцев назад

    If it possible to add all responses to emal at once without mapping field I have about 200 fields 😢

    • @jibbsautomations
      @jibbsautomations  6 месяцев назад

      You can skip the mapping to table and put the responses directly into an email, yes. But I believe you would still have to insert the values one by one into the email.

    • @surachetsripaoraya1387
      @surachetsripaoraya1387 6 месяцев назад

      @@jibbsautomations sorry my bad, i mean add all to excel not email 😭🙏🏻 thank you so much

  • @Almond-u3i
    @Almond-u3i 7 месяцев назад

    tried this but the responses is not automatically syncing to the excel file. can you help me?

    • @jibbsautomations
      @jibbsautomations  6 месяцев назад

      Hi, thanks for posting. If you haven't already, I recommend posting for help in Community, as that way we can see screenshots of your flow. All the best!

  • @MP-kj5ur
    @MP-kj5ur 10 месяцев назад

    Yes, i did all of that but the excel sheet is not updating with the new data.

    • @jibbsautomations
      @jibbsautomations  10 месяцев назад

      Hi, can you post a screenshot of your flow, and any additional details as well, in the Community and tag Jibbs?

    • @MP-kj5ur
      @MP-kj5ur 10 месяцев назад +1

      Found the issue to be the filter on the excel sheet.