web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / microsoft forms and excel
Power Automate
Suggested Answer

microsoft forms and excel

(0) ShareShare
ReportReport
Posted on by KC-30060708-0
i have created a forms and the excel spreadsheet. i have been instruxcted to use power automate to link the 2 but i don't seem to have that app. i need some guidance on brining in the data from forms to the excel spread sheet please
Categories:
Power Automate Desktop
I have the same question (0)
  • Suggested answer
    CU01071221-2 Profile Picture
    CU01071221-2 2 on at

    You can link Microsoft Forms to an Excel spreadsheet using Power Automate by creating an automated cloud flow. Select the Microsoft Forms – When a new response is submitted trigger, choose your form, then add the Microsoft Forms – Get response details action. Next, add the Excel Online (Business) – Add a row into a table action, select the location, Excel file, and table, and map each Forms question to the corresponding Excel column. Save the flow and test it by submitting a new form response. Each new submission will then be added automatically as a new row in the Excel table.

     

    Note: The Excel worksheet must contain an Excel Table (not just a range of cells).

  • Suggested answer
    David_MA Profile Picture
    David_MA 14,956 Super User 2026 Season 1 on at
    You will need to check with your organization to see what licensing has been assigned to you. Otherwise, you can get to Power Automate from this link:
    1. Power Automate: https://make.powerautomate.com/
      1. From here you can view your assigned licenses under settings:
    You'll need an E3, E5 or E7 license to use Power Automate, or been assigned a Power Automate premium license. Although, even with a license, you'll need to be added as a maker to a Power Platform environment to create anything, which is done by one of your organizations Power Platform admins.
     
    Once you have access to the tools and the correct licensing, you would use the trigger when a When a new response is submitted followed by Get response details. This YouTube video will show you what you need to do including saving the response to Excel: https://youtu.be/zbUH6a8K7bM?si=N0YsmhlvM0R51TqK

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans