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
Can you share the code you are using to create the ID?
Text property.
"# " & Text(ThisItem.ID,"[$-en-US]0000")
you might need to add a +1 to get the number to add
ThisItem.ID +1
That works fine, but 1st ticket became # 2 and in excel table id is 1.
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
@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.
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
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
183 | |
51 | |
47 | |
32 | |
32 |
User | Count |
---|---|
266 | |
91 | |
78 | |
68 | |
67 |