Forum Discussion
Change Request Form
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
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:
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.
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: