Skip to main content

Notifications

Community site session details

Community site session details

Session Id : nfOD9i7LAPGvd0hBOzY/f9
Power Automate - Using Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 4 Apr 2023 13:57:48 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?

  • chris-thompson Profile Picture
    5 on 10 Apr 2023 at 14:19:49
    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
    25,218 Most Valuable Professional on 04 Apr 2023 at 17:12:51
    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

Quick Links

Understanding Microsoft Agents - Introductory Session

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

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow
Loading started