cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
azzamnizam
Level: Powered On

[URGENT] Registration Form Generate Auto Reference Number

Hello Guys,

 

Im creating a registration form. But I need the form have a reference number. The number must be auto generate in every new form created, what formula needed if I am develop this kind of apps in PowerApps. 

 

kindly appreciate your help

 

cc @Jeff_Thorpe  @CarlosFigueira   @mabolan  @Hemanth 

Thank you

azzamnizam

7 REPLIES 7
JonathanWest
Level: Powered On

Re: [URGENT] Registration Form Generate Auto Reference Number

If I understand your question right. You can use the guid function.

GUID() 

 To create a random ID number that can be stored and retrieved later.

 

That being said the GUID should only be used if you can't use an indexed ID.

azzamnizam
Level: Powered On

Re: [URGENT] Registration Form Generate Auto Reference Number

Where should I put this function in text box or button?

GUID()

@JonathanWest

JonathanWest
Level: Powered On

Re: [URGENT] Registration Form Generate Auto Reference Number

Can you explain what you are trying to accomplish? 

azzamnizam
Level: Powered On

Re: [URGENT] Registration Form Generate Auto Reference Number

1.PNGNeed Result

@JonathanWest

 

Okay. Above is the dummy result I needed to be recorded as table....

First thing all the table header are the form required to be filled by user.

After submit the form the result goes to be above that can generate ID or any Reference Number

Examples on first row:

CSO/CIR/NOV/2018/17

Need to be generate like below

2.pngResult need to be generateHopefully you can understand the flow....

Really appreciate your help.

 

Thank you

AzzamNizam

 

JonathanWest
Level: Powered On

Re: [URGENT] Registration Form Generate Auto Reference Number

So it looks like you are using SharePoint lists as a datasource is that correct?
azzamnizam
Level: Powered On

Re: [URGENT] Registration Form Generate Auto Reference Number

@JonathanWest

 Appreciate for your swift response.

 

Currently yes.. but when I create app using PowerApps from SharePoint the layout become different and there a no access contorl for the item list....and the reference number not like this -> CSO/CIR/NOV/2018/17

azzamnizam
Level: Powered On

Re: [URGENT] Registration Form Generate Auto Reference Number

UP need HELP