Auto Increment in forms Power Apps

(0) Share

Report

Posted on by Az8PnG

Hi everyone,

I am having difficulties in creating an auto increment which starts with prefix.

In the picture below, I wanted to make if the user choose the radio button such as Electronic, the part number will increase 1, which is it will be "E-000005".

I want to make it increment 1 based on the latest part number according to their Stock Type in database (as picture)

This is my code for:

1. OnChange radio button:

UpdateContext({varSelectedStockType: Radio2.Selected.Value});
UpdateContext({varPartNumber: LookUp(Sort(Filter(Samples,'Stock Type'= varSelectedStockType),'Part Number',SortOrder.Descending),true,'Part Number')});

2. Default text input:

Concatenate(Left(varSelectedStockType,1),"-",Text(Value(Right(varPartNumber,Len(varPartNumber)-2))+varCounter,"000000"))

3. On Select Save button:

SubmitForm(Form3);ResetForm(Form3);
Set(varCounter, varCounter + 1)

Any help would be very much appreciated 😁

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

v-hanytian-msft Microsoft Employee on at

Like (1)

Report

Hi @Az8PnG ,

We create Dataverse below.

1. OnChange radio button:
UpdateContext({varSelectedStockType:Radio1.Selected.Value});
UpdateContext({varPartNumber:LookUp(Filter(Sort(Samples,'Part Number',SortOrder.Descending),Type = Radio1.Selected.Value),true,'Part Number')});

2. Default text input:
Concatenate(Left(varSelectedStockType,1),"-",Text(Value(Right(varPartNumber,Len(varPartNumber)-2))+1,"000000"))

3. On Select Save button:
SubmitForm(Form3);ResetForm(Form3);

Hope this will help you,

Best Regards,
Tina

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report

Hi @v-hanytian-msft is it possible to make the part number as a running number? Meaning that let say if the user choose "Electronic" then the part number will automatically + 1 such as "E-0000003", & display it in the text input. Then when the user click the save button, and choose "Electronic" again, the part number will be "E-000004".

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (1)

Report

Hi @Az8PnG ,

Please try to move the formula from OnChange to OnSelect.
That means when you click Radio, it will execute the formula immediately.

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report

Hi Tina, I think the formula is not working on me.

I already change it as you do, this is my OnSelect properties on radio button but the part number is not added to 1:
Database table:

Do you make the part number as primary key? Thank you for helping me out Tina. 😊

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report

Hi @Az8PnG ,
May I ask what formula in the Default Text input?

Best Regards,
Tina

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report

Sure Tina, here you go.

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report

Hi @Az8PnG ,

Oddly enough, the same formula works fine in my app. But when I manually added a new record to the table, I reproduced the problem.

We Suggest you add the refresh() formula into two places.
Refresh(Samples)
OnSelect of Radio:
OnSelect of Button:

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No