I am using MS Forms.
I have created a form for queries, and this is shared far and wide and is working beautifully. However, now, each time there is a new response, I must manually copy the responses to an excel sheet in a shared drive so that everyone can see it and comment on progress.
I have moved the form out of my own personal "forms" into the Teams domain (so that the team can see it) MISTAKE...
I want to use power automate to make a connector so that every time a form is completed, the data collates to a spreadsheet that the team can then see and add notes.
NOW...I have done this a few times with my own forms and power automate is working successfully to take the completed form data and put into a spreadsheet. I've even managed to automate sending e-mails to external parties so that notifications take care of themselves.
The problem I have and I CAN'T FIND A RESOLUTION ANYWHERE is that as I have moved the form into a Teams Group - when I come to create the power automate, the desired form isn't available from the drop down menu. I've searched/googled. You can't move the forms out of a group (so I can't move it back to me) I can't recreate and start again as the whole world has access to the link and associated QR form to complete this form.
How can I create an automated flow to get data from a form that sits within a MS Teams drive (for Forms?). If you can help…non tech language! thanks