Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
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 - Using Flows / How do I create a Flow...
Power Automate - Using Flows
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 chris-thompson 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?

  • chris-thompson Profile Picture
    chris-thompson 5 on at
    Re: How do I create a Flow Based off of a Form Created in the OneDrive of a Microsoft Team

    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.

  • ScottShearer Profile Picture
    ScottShearer 25,218 Most Valuable Professional on at
    Re: How do I create a Flow Based off of a Form Created in the OneDrive of a Microsoft Team

    @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?

     

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

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,708 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,030 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans