Answered

Creating Ticket

(0) Share

Report

Posted on by HF306

Hi all,

I need help in creating a ticket. When a button is click it will show the number 1. When a new ticket is created it will show the number 2. This will carry on when a new ticket is created. The submit button is submitting an edit form and 'RefNo' is the name of the column from SharePoint. Inside the RefNo text input I name the variable as CountNum. On the MainScreen, it should display the latest ticket number.

Below is the code that I put on my submit button:

SubmitForm(Form_FormScreen1) = Set (CountNum, CountNum + 1);Navigate(MainScreen);ResetForm(Form_FormScreen1);Office365Outlook.SendEmailV2("Mail","Mail Subject", "Mail Content")

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!
Hi @HF306 ,

In order to get the latest ID, you can set your CountNum to be something like:
First( Sort( [Your SP List Name], RefNo, Descending ) ).ID
So, in your submit form, you can use what you have now = CountNum = CountNum+1

Let me know if this helps.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @HF306 ,

Apart from the equals sign, the code will set the Variable to the next number

SubmitForm(Form_FormScreen1); Set(CountNum, CountNum + 1); Navigate(MainScreen); ResetForm(Form_FormScreen1); Office365Outlook.SendEmailV2("Mail","Mail Subject", "Mail Content")

What is the Item of the Form on the main screen?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @HF306 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No