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.
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:
Hope it could help.
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.
Is there any necessary for you to make the ID as arabic numerals?
The solution I provided does not fit your scenario?
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.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT