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

Best 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

 

Best 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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,829)