Unanswered

Running Number or Unique Number

(0) Share

Report

Posted on by noob_power_apps

Hi Team,

I have one more requirement which is something like this. There is one text input in which person will enter the opportunity id suppose you have entered one opportunity id then there is one more text input in which it will show the unique number. Like for opportunity id A - Unique id should be INOPP_Division(which should be dynamic)_YY(this also be dynamic)_0001, and goes on. i don't know how to do this. Attaching screenshot for everyone's reference. Please help me for this. Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

scalca on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
probably you'll have to provide a bit more details
let's try to figure this out.
the default property can start with this
$"INOPP_{DropdownControlDivision.SelectedText.Value}_{yourDinamicControl.Value}_{Text(Sum(Value(If(!IsEmpty(YourOpptiesSource),Index(Last(YourOpptiesSource).uniqueID,"_",4).Value,"0")),1),"0000")}"

I don't know where do you get the YY dynamic value from
I don't know your datasource where you store the opportunities

what I'm doing here is to get the latest record in your Oppties datasource if there is any
if there is no record I'll take "0"
increment by 1 convert to Text and format this into desired output which is "0000"

there you go

Was this reply helpful? Yes No
noob_power_apps 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Scala,

Thanks for your reply, let me clear out the things more -

for YY i have date pickers named as Start Date from there i can take YY.
The data source is sharepoint list in which all my data is going to store.
in the text input of my unique id i have wirtten this formula and i am stuck little bit, I am sharing my code here which i have written in default -
Concatenate("INOPP_",Text(ComboBox6_1.Selected.Value),"_",Right('Start Date_1'.SelectedDate,2))
it is giving me my first few outputs but what i want now is the moment people will start adding opportunity so it will start taking the sl no of the opportunity like 1 will become 0001 and so on. Let me know what else i can modify in my code. Thanks in advance.

Was this reply helpful? Yes No
noob_power_apps 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Combo6_1 is for division and start date is my date picker which helps me in getting last 2 numbers.

Was this reply helpful? Yes No
scalca on at

Like
a
(0)

Report
Copy link

Link copied!

if you're just getting the sharepoint id for the last part of the unique id and you want to format it then use this
Text(selectedItem.ID, "0000")
with the Id you need to get the item first in order to identify which Id you have to pick
when the user enters the opptId, how do you get the record from the sharepoint list ?

Was this reply helpful? Yes No