Forum Discussion
JP2Ro
Sep 22, 2022Copper Contributor
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"]...
RobElliott
Sep 22, 2022Silver Contributor
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)
JP2Ro
Sep 22, 2022Copper Contributor
RobElliott
Working in MS Forms is new to me .. so going to give this a shot 😊
Thank you very much
-
J
Working in MS Forms is new to me .. so going to give this a shot 😊
Thank you very much
-
J