Auto increment with Prefix In Power Apps

Подписаться 346

Просмотров 20 тыс.

50% 1

In this tutorial we look at the Auto Numbering or Automatic increment of a Column in Power Apps:
- How to Perform the Increment where the column is of Number Type
If(Form1.Mode=FormMode.New,First(Sort(ZA_Hardard_List,ID,Descending)).ID+1,Parent.Default)
- Where it a combination of Text and Number; thus a Prefix Auto Increment
If(Form1.Mode=FormMode.New,"ABC-"&First(Sort(AddColumns(ZA_Hardard_List,"NewColID",Trim(Substitute(ID2,"ABC-",""))*1),NewColID,Descending)).NewColID+1, Parent .Default)

Опубликовано:

4 апр 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@brendanv666 2 года назад

Thank you Eric. Saved me on this one to create a new number for each from created to be displayed.

@Rapha.777 Год назад

Show de bola resolveu aqui legalll 😎

@waleedvlogging822 2 года назад

Amazing you are the Man !

@ericentsie4015 2 года назад

Thank you

@entsiepatricia4849 Год назад

Awesome

@danielcecil951 28 дней назад

Thank you so much Eric. This is fantastic. Please one quick question. This works for me if there is only one prefix type (ABC-1), but if there are different types e.g. XYZ-1, etc in the same SharePoint List, if only works for the first prefix. Other prefix shows error message "cannot convert ABC-1 to number". Please can you help?

@MrAbueslam 2 года назад

thanks you Eric , great work. this is coming from id autoincremented column. But If i create a variable to generate 4 to 5 digit length and add a prefix to it, this result in an invoice number that I increment by 1 everytime I press new form . in my case this number is created and consumed regardless of I created / saved a record or not. Can you please tips me how I can conserve used invoice number in my case and the generated invoice is consumed when I save it to data source.

@sakshitiwari4085 Год назад

Hi Eric, Thank you so much this amazing video. This solution helped a lot in one of my problem statement. I need your 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, Thanks.

@charleschen7508 Год назад

Thanks Eric. Very useful and helpful. One question. if in form edit mode, how does this ID change accordingly?

@ericentsie4015 9 месяцев назад

If in edit mode, it means the number already exist in your database. In that case, you have to manually edit it on your form.

@QuangPham-hd3wj 2 года назад

Hi Eric, thank you for the instructions. For my app I want to reset the numbering daily. For example, on day 1 the ID would be 0101 0102... next day it would be 0201 0202... Do you have any suggestion on how to do that?

@ericentsie4015 2 года назад

Thanks for the request. I would get back to you but can you explain the logic behind. example if the first 2 digits represent the Day, what does the other numbers represents. 0202 and 0102

@QuangPham-hd3wj 2 года назад

@@ericentsie4015 the latter 2 digits are just the numbers that auto-increment per each ID. I got it done already (modifying your code a bit). I added one Filter function inside the Sort one. There I compare the current day with the created IDs. If they match the increment goes on, if not the counting starts over from 1. It's a bit long but at least it works. Please let me know if you have better solutions.

@ericentsie4015 2 года назад

@@QuangPham-hd3wj That's fine. Good work 👍