cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArmanGabd
Helper I
Helper I

ID confusion 2

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

8 REPLIES 8
BlessedCobba
Resolver I
Resolver I

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

Text property.

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

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.

v-qiaqi-msft
Community Support
Community Support

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

 

@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.

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (14,444)