Forum Discussion
Creating a Custom/Unique ID
I would like to create a request form .. I would like each new request to have a unique id .. Example: M20220921-01 - Where the 1st character is the location [based on the input for "Location"]...
JP2Ro to do this you will need to create a flow in Power Automate to grab the form response, lookup the current maximum ID, add 1 to it, apply that to the form response then create a new list item in SharePoint (or possibly an Excel list although I always prefer SharePoint).
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)