ID confusion 2

[ArmanGabd]

Hi there,

Ive shared my app within our HR team. So got this issue.

When 2 users creates a ticket at one time, their ID is the same.

For example: user 1 creates a ticket

User 2 creates a ticket

Output is both ticket has same id #2.

Is there any way to get rid of it.

So it will depend on time based for example.

User 1 has id #2

User 2 has id #3

By the way, i am using excel table as data source.

Thank you

[BlessedCobba]

Can you share the code you are using to create the ID?

[ArmanGabd]

Text property.

"# " & Text(ThisItem.ID,"[$-en-US]0000")

[BlessedCobba]

you might need to add a +1 to get the number to add

ThisItem.ID +1 

[ArmanGabd]

That works fine, but 1st ticket became # 2 and in excel table id is 1.

[v-qiaqi-msft]

Hi@ArmanGabd,

Based on the issue that you mentioned, do you want to generate unique ID?

Could you please share a bit more about the scenario?

Here is a workaround that may cause a long is but the unique.

Firstly, you should connect the Office365Users to your app and set the Text property as below:

 User().Email & "_" & Text( Now(),"[$-en-US]ddmmyyyyhhmmss")

In addition, you could use the GUID() to create unique strings as below:

GUID()

Hope it could help.

Regards,

Qi

[ArmanGabd]

@v-qiaqi-msft Hello,

About scenario, Ive created an canvas app by using microsoft helpdesk temlate for users to create a ticket.

When user raises a ticket, app gives a number "ID" to every ticket in ascending order.

App was shared to a small team(4 users) to get feedback.

But faced an issue when 2 user created a ticket at one time.

So theit Ticket ID'd became #2, both of them. Same number.

So tryed a function ID+1, it works. But, datasource doesnt know about those tickets, it doesnt see them.

And also ticket #1 became ticket #2 and so on.

Question is about duplicating issue. If I share an app within all users(around 70 users), how many same ticket ID's will i have.

Any resolution or ideas about that.

Thankyou in advance.

[v-qiaqi-msft]

Hi@ArmanGabd,

Is there any necessary for you to make the ID as arabic numerals?

The solution I provided does not fit your scenario?

Regards,

Qi

[ArmanGabd]

@v-qiaqi-msft,

1. What you can offer if I change numerals from arabic?

2. Solution that you provided, as a beginner in powerapps, its a lil bit hard for me to understand.

Do i need to add GUID function and all tickets gonna be as 34 digit number.

I think simple way to achieve my goal is to use simple numbers such 1...10...20.