I am new to Power Automate so be patient with me. 😊 I created a cloud flow that uses information gathered in a Microsoft form to send emails to different individuals based on the answers in the form. This works fine if I set up the form in my OneDrive but what if I want to use a form created in Sharepoint? The drop down menu that asks for the Form Id only shows forms in my OneDrive. How can I direct the flow to use a form in Sharepoint?
Also, I have the form connected to an Excel spreadsheet in Sharepoint that is updated when someone responds. Maybe I need to work this backwords and find a way to create a form in OneDrive and a flow that emails and also saves the responses to the spreadsheet in Excel. Is that even possible?
