Forum Discussion
Change Request Form
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
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
- 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 etc
2) 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.dmistry21 yes this can be done in your flow and will give the following result:
The InvNumber column is a single line of text column.
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.
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:
Rob
Los Gallardos
Microsoft Power Automate Community Super UserThanks again - Following the steps I'm tripping up with some of the options, notably I don't see the 'ComposeNext' option, only 'Compose' is listed and also 'Update Increment' doesn't appear listed, could this be a permissions issue or am I looking in the wrong place ?
I created a new list called 'Change Increment' and edited my original flow so it now looks like this: