Forum Discussion

Copper Contributor

Apr 29, 2021

Change Request Form

Hi All, This is my first post, hoping you can help - My objective is 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 s...

dmistry21

Copper Contributor

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.

RobElliott

Silver Contributor

May 04, 2021

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 User

dmistry21
Copper Contributor
May 05, 2021
Thanks 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:
- RobElliott
  Silver Contributor
  May 05, 2021
  They are just what I have renamed the actions to to make them more understandable! So ComposeNext is just a Compose control renamed. renaming is always a good idea if you have a complex flow or many actions and you might not remember what each one is, particularly in expressions.
  - dmistry21
    Copper Contributor
    May 05, 2021
    Got it - so my sticking point is at the 'Update item' stage where I get the following error. Here i'm selecting my main list in the screenshot however it only accepts the new list that's been created: