Answered

Auto incrementing IDs with prefix (prefix from Dropdown list)

(0) Share

Report

Posted on by CU15061124-0

Hello,

I am a PowerApps beginner and I struggle to automatically generate an ID, which starts with a prefix.

Background is that I have a screen which is a new inspection form where the user can enter his findings. The form includes different data cards but the ones that are currently interesting for me are the following:

Component (Dropdown list) with the following entries:

A: Module1

B: Module2

C: Module3

😧 Module4

ID (Text input):

Here I want to generate the automatic ID in the following format:

Split(Dropdown.Selected.Value, ":") and 00xx

For example, if my list looks like:

Component	ID
A: Module1	A001
C: Module3	C001
A: Module2	A002
A: Module2	A003
😧 Module4	D001

If the user enters a new finding and selects from the Component dropdown list: "A: Module1", I would like the ID "A004" to be automatically generated and visible in my Text Input ID (user should not be able to edit it).

If user chooses from the dropdown list "C: Module3", then "C002" should be generated, etc.

There are two steps to generate my ID, the first one being the split of dropdown.selected.value on ":" to keep only the first left character, the second being the incrementation but despite trying, I couldn't find a way to code it properly...

Any help would be very much appreciated 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

anibra 278 on at

Like (0)

Report

Where do the drop-down values come from? table, collection or they are fixed values?

Was this reply helpful? Yes No
CU15061124-0 on at

Like (0)

Report

Dropdown values are fixed values (In the Items property, I've defined the different entries
Items = ["A: Module1","B: Module2","C: Module3", "D : Module4"])

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
Hi @Marine_C ,

You did not state your data source here, but assuming SharePoint, you will have to call the column something other than ID (I have used IDField below). I have also assumed .Value as the output of the drop-down. I cannot test this, but it should be close to what you need

With( { wComp: Left(YourDropdown.Selected.Value,1) }, With( { wLast: Lookup( Sort( YourListName, ID, Descending ), StartsWith( Component, wComp ) ).IDField }, wComp & Text( Value( Right(wLast,3) ) + 1, "000" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
anibra 278 on at

Like (1)

Report

Hi @Marine_C ,
assuming that you are showing the selected dropdown values and generated values in a gallery, my suggestion is as follows:
In the onChange property of the dropdown define the formula:
Collect(
var_list,
{
DD: Dropdown2.SelectedText.Value,
Id: First(
Split(
Dropdown2.SelectedText.Value,
":"
)
).Result & "00" & CountRows(
Filter(
Gallery6.AllItems,
Title4.Text = Dropdown2.SelectedText.Value
)
) + 1
}
);

Was this reply helpful? Yes No
CU15061124-0 on at

Like (0)

Report

Hi @WarrenBelz,
Thanks for the reply! You assumed right, my data source is a Sharepoint list and the .Value is the output I get from the dropdown (example: "A: Module1")

I have renamed my column "ID" to "IDField" as you did, for me to understand your code. But I was wondering what is "ID" in your code then?

Moreover, I tested the code and got the following error:
DataCardValue7_2 being my Text Input, where I want to display my final ID:

Put I used your code in the Default property of the Text Input, maybe it is where there is the error...

Was this reply helpful? Yes No
CU15061124-0 on at

Like (0)

Report

Hi @anibra
Thanks for the inputs! My screen looks like this:
And I basically try to generate the automatic ID in the "IDField", which is a Text Input.

From your code, I guess only the CountRows() part needs to be adjusted (?) (where there is a reference to the Gallery)

Was this reply helpful? Yes No
anibra 278 on at

Like (0)

Report

@Marine_C Instead of the gallery you can use your sharepoint list and instead of the collection var_list use set to set a variable which will be the Text value of your label. You need to count the available rows in order to know which id to generate

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

Hi @Marine_C ,

Firstly, please tag whoever you want to assist you here - three-way conversations just confuse everyone.

The ID is the ID column in SharePoint which I am simply sorting on Descending on to get the newest record (and hence the largest number) and then filtering on the prefix to get the right item. Also, if you want code examined, please post the entire actual code you are using in Text as well as what the error is stating. Before you do that, please check that you have applied your values correctly to the code posted as it appears valid to me.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
CU15061124-0 on at

Like (0)

Report

Hi @WarrenBelz
Sorry for the three-way conversation, it was indeed hard to follow. I found out where my error was when implementing your code, thanks for the support, it is now working perfectly!

Was this reply helpful? Yes No
FeierCiprian 20 on at

Like (0)

Report

Hi, @WarrenBelz
I have the same implementation but in Dataverse table. How can be implemented?
thank you

Was this reply helpful? Yes No