Unanswered

Best practice ticket number

(0) Share

Report

Posted on by Community Power Pla...

Dear all,

I have created an app that should create a unique ticket number when a end user submits a ticket.
My app is running on a SharePoint list, where I have created an column "Ticket number" I imported this field to my Edit form and set the default to sum(Last('Sharepointlist').ID+100001) when the last id is 10 it should give me a ticket number of 1000011 and this workes fine.

The issue is that when 2 or more end users want to submit a ticket on the same time they all will get this ticket number, because the default ticketfield will get filled in on the time the ticket get opened. So I created the next solution:

On the submit button where I Submit the form I have entered the following code:
Set(ticketnumber,true);
SubmitForm(Form).

On the DataCardValue from the ticket number I have created the following code:
If(
Ticketnumber = true,

sum(Last('Sharepointlist').ID+100001)
)

With this solution I thought I could avoid duplicate ticket numbers, but somehow it still isn't working, I still get duplicates.
Is there any best practice for unique ticket numbers?

Thanks!

Ramon

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @Anonymous ,

Please try this formula:

SubmitForm(Form1);Patch(LIST278,LookUp(LIST278,ID=Form1.LastSubmit.ID),{'Ticket number':Form1.LastSubmit.ID+100000})

Now the datacard of ticket number is no longer needed in form.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @v-xiaochen-msft ,

Thank you for your reply, my current code with your adjustmnts looks like this:

CCRNewticket.Run(Last('AR support request').ID+1);
Patch('AR support request',Defaults('AR support request'),Form1.Updates,Form2.Updates);
Patch('AR support request',LookUp('AR support request',ID=Form1.LastSubmit.ID),{'Ticket number':Form1.LastSubmit.ID+100000});
Navigate(Home);
ResetForm(Form1);
ResetForm(Form2)

When I submit the ticket there is no ticket number visable, did I miss something?
In the first Patch function I am submitting form 1 and 2 as a combined

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @Anonymous ,

Form.LastSubmit.ID is blank because you don't actually use SubmitForm function.

Please try this:

CCRNewticket.Run(Last('AR support request').ID+1); Set(var,Patch('AR support request',Defaults('AR support request'),Form1.Updates,Form2.Updates)); Patch('AR support request',var,{'Ticket number':var.ID+100000}); Navigate(Home); ResetForm(Form1); ResetForm(Form2)

Best Regards,

Wearsky

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

This is great, thank you so much!

Was this reply helpful? Yes No
knsrinath 527 on at

Like (0)

Report

Hi @v-xiaochen-msft

I have same issue, I am not using form control.
I am using following code for generating the Ticket No

In patch
SLNo:First(Sort(mySPList, SLNo, SortOrder.Descending)).SLNo+1,
orderNo:Text(First(Sort(mySPList, SLNo, SortOrder.Descending)).SLNo+1,"00000"),

I am not using default sharepoint ID column.

Request you help me resolve the issue.

Thanks & Regards

Was this reply helpful? Yes No