Forum Discussion

Copper Contributor

Sep 22, 2022

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"]...

microsoft forms

RobElliott

Silver Contributor

Sep 22, 2022

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)

Bradleyjp
Copper Contributor
Feb 26, 2024
Hey RobElliott

I'm trying to create something similar, but don't have a clue how to do this, can you share instructions or do you know where I can find the resources?

Much appreciated.

Kind regards
Bradley
- HelpfulHarriett
  Copper Contributor
  Mar 20, 2024
  Bradleyjp MSFT PowerAutomate (either on your microsoft365 homepage or the downloaded version) and the Co-Pilot feature should be able to help you; you can choose from templates if one exists already and edit as needed. I found this YT helpful when I was getting started: https://www.youtube.com/watch?v=kbqXsKPTmZk
JP2Ro
Copper Contributor
Sep 22, 2022
RobElliott
Working in MS Forms is new to me .. so going to give this a shot 😊
Thank you very much
-
J