cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

[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
Highlighted
Advocate II
Advocate II

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.

Highlighted
Helper II
Helper II

Re: [URGENT] Registration Form Generate Auto Reference Number

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

GUID()

@JonathanWest

Highlighted
Advocate II
Advocate II

Re: [URGENT] Registration Form Generate Auto Reference Number

Can you explain what you are trying to accomplish? 

Highlighted
Helper II
Helper II

Re: [URGENT] Registration Form Generate Auto Reference Number

Need ResultNeed 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

Result need to be generateResult need to be generateHopefully you can understand the flow....

Really appreciate your help.

 

Thank you

AzzamNizam

 

Highlighted
Advocate II
Advocate II

Re: [URGENT] Registration Form Generate Auto Reference Number

So it looks like you are using SharePoint lists as a datasource is that correct?
Highlighted
Helper II
Helper II

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

Highlighted
Helper II
Helper II

Re: [URGENT] Registration Form Generate Auto Reference Number

UP need HELP

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,471)