How to Sync Microsoft Excel with Microsoft Forms Responses Using Power Automate

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 19

  • @CavalierNSN
    @CavalierNSN 4 дні тому

    Your video was my gateway into PowerAutomate, and I don't think I've seen so many of my root questions addressed and explained in one place before your presentation! Thank you for sharing and it looks like I have a lot of homework to do throughout your video library!!

  • @techscoville
    @techscoville 3 дні тому

    Sir you're the best 😊😊

  • @alexrosen8762
    @alexrosen8762 2 місяці тому +2

    Great example that can be useful in many scenarios 👌

  • @IainMace
    @IainMace 6 місяців тому

    quick, simple and useful... many thanks

  • @faheemzafar9572
    @faheemzafar9572 6 місяців тому

    Absolute legend. Cheers mate! That fixed my problem

  • @bryanvilla189
    @bryanvilla189 5 місяців тому

    The most perfect video ever, question, how can I add more forms to the same flow?

  • @bcgibson22
    @bcgibson22 7 місяців тому +4

    The new interface (December 2023) looks nothing like this. Dynamic content options don't seem to be available any more either.

    • @shelbylofthus1985
      @shelbylofthus1985 7 місяців тому +1

      you can switch to the old style in the top right corner. Took me forever to find this.

    • @taronate
      @taronate 6 місяців тому

      @@shelbylofthus1985 thank you so much! i was having a headache doing this because the dynamic content window was not popping up at all and there is no up to date info in the forums about this. they really need to fix this.

  • @lilpixielaura
    @lilpixielaura 9 місяців тому +1

    Thank you for this video. I was able to set up a form with automated responses to Excel. But I'm wondering how I can pull the name field from the form to Excel? I had set up the form not to ask for the name and email as it automatically populates for the user. But the name field isn't showing up as an option in the flow. The email is there but not the name.

  • @vladimirherceg3826
    @vladimirherceg3826 8 місяців тому

    Thanks for the great video. I am just wondering if you had old data that you wanted presented in the Forms dashboard. Could you update the synced excel sheet manually with a bunch of line items and have those items appear on the Forms dashboard?

  • @TheMrNinzy
    @TheMrNinzy 9 місяців тому

    Hi Chester, Very helpful! - what exactly is the purpose of syncing to excel? Doesn’t response able to extract raw data? Thanks again

  • @3066961
    @3066961 5 місяців тому

    useful !

  • @DarioDoZZannini
    @DarioDoZZannini 8 місяців тому

    thanks for the useful tutorial! Do you think is possible to populate excel rows based only on keywords via email? Eg: if an email arrives to a given address then power automate check its body for keywords and then populate an excel row if it finds them?

  • @meuliaiso5749
    @meuliaiso5749 7 місяців тому

    Thanks for the video. I have a question though: I am interested in having the respondents able to edit their responses after they submit and Microsoft forms have some limitations here. Can you please help me achieve that using the same logic?

  • @HJay
    @HJay Місяць тому

    Is there a befit to doing it this way rather than with the excel file that MS Forms generates?

  • @peterctbrownuk
    @peterctbrownuk 9 місяців тому

    Hi Chester, great video - it seems that there has been an update to the process since your video - there are now two additional details required after you select the table - requesting "Key Column" and "Key Value" - and I've tried to work out what on earth it means to no avail! :( Do you have the same issue?

  • @Jennifer-bn4iy
    @Jennifer-bn4iy 3 місяці тому

    How would you filter entries with null/ empty answers

  • @shelbylofthus1985
    @shelbylofthus1985 7 місяців тому

    Is there a way to upload an image from the form to excel? I've seen tutorials on how to do these as attachments, but just want to upload the image to excel so it is visible.