Forum Discussion
Change Request Form
dmistry21 what you need to do is to setup your flow so that each form response is saved into a SharePoint list in your Teams site. Then have an action to send the email to the people you want to receive it.
So create your list with one column for each question in your form making sure that for a any long answer in the form that you use a multiple lines of text column. I always use the Title column for the responder's email address but you don't have to do that.
Next, in Power Automate your trigger will be "When a new response is submitted" followed immediately by the first action which is "Get response details". In my example I'm going to personalize the email so I add an Office 365 Users "Get user profile (V2) action.
Next we add the answer from each form question into the SharePoint list using the SharePoint "Create item" action.
We always add our company logo into our emails the next is to get the logo from our SharePoint document library with "Get file content using path" and you select the location of the image.
Finally we send an email In my example we're sending the email back to the respoinder and copied to a shared mailbox, but you could send it to a number of different recipients separated by a semi-colon. Because I'm adding the image and other HTML tags I've turned on the code view </> which allows for more control over the email result.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Thankyou for getting back - Think I followed the steps however may have an incorrect value somewhere. I created the list directly in MS Lists as doesn't look to be integrated directly in our Sharepoint or I don't have access.
I created the flow as per the below:
When running a test, it appears with the following error:
Drilling into the detail it shows the following:
I did change the "When is the change to be implemented" to be both date and text in case there was an input restriction but the same error. I tested at this stage and didn't proceed to setting up the email option.
Is this a step in automate that's been missed ?
Thanks