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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How do I create a Flow...
Power Automate
Unanswered

How do I create a Flow Based off of a Form Created in the OneDrive of a Microsoft Team

(0) ShareShare
ReportReport
Posted on by 5

I want to create a spreadsheet that is shared amongst other members of one of the Microsoft Teams that I am a member of. I am NOT the owner of this Microsoft Team. I want the spreadsheet to be connected to a Microsoft Form, and the spreadsheet to automatically update when new forms are completed. In that specific team's OneDrive, I created a Forms for Excel document and have created my Form and also did a test of the form, and my test result shows up in the spreadsheet that was created. Now I would like to create a flow for the Form that was created so that specific people are alerted when a new form has been submitted. I went into Power Automate and selected Instant Trigger from the completion of a Microsoft Form, and when it asks me to select the specific form in the dropdown menu, the title of my form does not show up on the list. How can I set-up a Flow for this particular form?

Categories:
I have the same question (0)
  • ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @chris-thompson 

    Can you tell me if the Form you created  was created from within a Team?

    If so,  

    • Open up the Form
    • Look at the URL - at the end of the URL, look for FormId=
    • Copy the form ID - the number after FormId=
    • In the When a Form is submitted trigger, select custom value and paste in the Form ID

    When you say " In that specific team's OneDrive", do you mean in the document library associated with the Team?

     

  • chris-thompson Profile Picture
    5 on at

    Hi Scott:

    I created a "Forms for Excel" document within the "Files" (document library) area of the Microsoft Team.  I think because I am technically not the owner of the Form, that may be why it doesn't show up on the list and I would need to use the CustomID.  Additionally, if I want people notified and include information from the form on the email sent to others I had forgotten that you need an additional step that says "Get response details" prior to making the email step and adding in the dyanmic content.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard