Announcements
Hi,
I'm new to powerapps and looking for assistance to create a sequential number based on inputs of two dropdown lists. Based on the two dropdown lists inputs I would like for it to create the next sequential "Serial Number". See example below, for instance if I were to select "SUBS" and "2.50 INCH" then it would create "Serial Number" 4 next. Any help is appreciated!
Hi @Jtrahan ,
Try setting the Default property of the control to:
LookUp( ExcelTableName, Description = drdDescription.Selected.Value && 'Component Type' = drdComponentType.Selected.Value ).'Serial Number'
You will have to replace some of the names in there to what you are actually using (ExcelTableName, drdDescription and drdComponentType).
Thanks @BCBuizer,
I'm receiving two errors when I try this, "incompatible types for comparison. Text,control" and also "expected enum value"
The first issue is that you are trying to set the wrong property/control. I can see from the screenshot you are trying to set the DefaultMode property which is a property of a Form control only. This property defines which mode the form is in by default which determines its' behaviour.
The formula I provided is to be used on the Default property of the text input control in the 'Serial Number' datacard. However, after having re-read your original question, I see the formula should be:
Last( Filter( DATA, Description = 'DD Component Description'.Selected.Value && 'Component Type' = 'DD Component Type'.Selected.Value ) ).'Serial Number'+1
Thank you!! It works!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 525 Most Valuable Professional
Haque 273
Kalathiya 232 Super User 2026 Season 1
