How to generate Auto Number

(0) Share

Report

Posted on by SumanKoduri

243

Hi,

Is there any Feature to generate Auto Number in the PowerApps Canvas App.

If exists could someone please explain how to generate Auto Number.

Regards

Suman

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

notj 782 on at

Like (0)

Report

Have you tried using the Autonumber functionality?
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/autonumber-fields

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Hi @SumanKoduri ,

Could you please share a bit more about your scenario?

Do you want to generate a Auto Number in PowerApps app?

Which data source do you use within your app?

I assume that you want to generate a Auto Number in your app, and then save it back to your data source, is it true? I have made a test on my side, please consider take a try with the following formula:

CountRows('YourDataSource') + 1 /* <-- Generate a Row Index Number based on your data source */

If you want to generate a unique number randomly, please check and see if the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Manually-Generating-UniqueId-Key-Values-or-how-is-it-generated/td-p/29522

In addition, if the data source you used in your app is a CDS Entity, I think the Autonumber type field could achieve your needs. You could consider add a Autonumber type field in your CDS Entity as below:

Please take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I want to generate unique Auto Purchase Order Number. When i click on create new purchase order in powerapps it would generate the Purchase order number automatically.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi, I am new to power Apps development. I need help in one of the scenario where i need to generate autogenerated number.
The Scenario is , when i click on a button it will navigate to next page and this next page contains a submit form and has 5 fields among those one is "Auto generated number" field , current date and time field and creator name(In this case my name ). So for this auto generated number there are some conditions:
1) it contains the current year and a unique number . Suppose my last auto generated number was 22-003 , where 22 is current running year(2022-> 22) and a unique number , so if a new from will appear on a button click this auto generated number should be 22-004.
2) If suppose , the current year (2022 ) is going to end and new year (2023)is going to start, so for this new year , the auto generated number should be 23-001 for the first entry.

kindly help on this scenario, would be appreciable. Thanks.

Was this reply helpful? Yes No