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?
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.
Can you tell me if the Form you created was created from within a Team?
If so,
When you say " In that specific team's OneDrive", do you mean in the document library associated with the Team?
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional