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

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 174 members 5,414 guests
Please welcome our newest community members: