Change Request Form

Question

Hi All,&nbsp;This is my first post, hoping you can help - My objective is&nbsp; for a form to be created for IT Changes that users can complete and then a select audience is notified when a form has been submitted, also the forms will need to be stored so we they can be reviewed if need in the future.&nbsp;I have created a change form within MS Forms and linked it to a new MS Teams Channel so when responses are received an alert is received within the channel and also linked it to to Power Automate so responses go to multiple users.&nbsp; This hasn't quite achieved as it's the same form i'm receiving responses for.&nbsp; Is there any advice on how I can provide a seperate change form for every request and then also have this stored and with pre-defined notifications ?&nbsp;Many Thanks

robelliott · Answer

dmistry21&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;&nbsp;Next we add the answer from each form question into the SharePoint list using the SharePoint "Create item" action.&nbsp;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.&nbsp;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 &lt;/&gt; which allows for more control over the email result.&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User&nbsp;

dmistry21 · Answer

RobElliott&nbsp;Thankyou for getting back - Think I followed the steps however may have an incorrect value somewhere.&nbsp; 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.&nbsp;I created the flow as per the below:When running a test, it appears with the following error:&nbsp;Drilling into the detail it shows the following:&nbsp;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.&nbsp; I tested at this stage and didn't proceed to setting up the email option.&nbsp;Is this a step in automate that's been missed ?&nbsp;Thanks&nbsp;&nbsp;

robelliott · Answer

You've got it wrong at the beginning as you've got an "Apply to each" after the trigger of "When a new response is submitted". This is wrong but is common if you use a Power Automate template to create your flow. Don't do this, create from a blank flow. You don't need the the Apply to each and it is wrong to use it. You will see in my flow that I don't have that but just go straight to the "Get response details action".

So don't use a template but create your flow from scratch and follow the steps I gave you.

Rob
Los Gallardos

dmistry21 · Answer

Perfect, that was the error, manually creating the workflow has worked. There's a couple of minor tweaks I need to make, do you know if the following is possible ?1) For every new form submission, is it possible when stored in Sharepoint there is a column option that gives the entry a unique identifier automatically - eg Chg001 for the first submission, CHG002 for the next etc2) One of my form questions is for a date/time to be entered however MSForms only gives a date option and no time, anyway to get around this ? I tried 'text' but in sharepoint it doesn't like the numerical values. You can go into Sharepoint after and manually enter the date/time manually however was hoping there was a way to do this directly from the form.Many thanks for the help so far.

robelliott · Answer

dmistry21&nbsp;yes this can be done in your flow and will give the following result:&nbsp;The InvNumber column is a single line of text column.&nbsp;For an incrementing unique identifier with text ahead of it you would first of all need a second list which would only ever have 1 item in it: in the title column the item is Next. There is then a number column to hold the next number.&nbsp;The your flow is as follows and sets the number in the main list with CHG in front of it and adds 1 to the increment list:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User&nbsp;&nbsp;

Forum Discussion

Change Request Form

Resources