Hi @JerryH ,
Could you please share a bit more about the "Ticket Number" that you mentioned? Is the Ticket Id value?
Do you use the SP List as data source in your Help Desk Template app?
If you want to display the Ticket Number in your SP List, you need to create a Number type column (called "TicketId") in your SP List firstly to store the "Ticket Number" for each submitted ticket.
Within your Help Desk Template app, when you submit new ticket back to your SP List using Patch function, you need to modify your Patch formula as below:
Patch(
HelpDesk, // HelpDesk represent your SP List which store your submitted Ticket
Defaults(HelpDesk),
{
TicketId: CountRows(HelpDesk) + 1, // Modify formula here. TicketId column is a Number column to store the Ticket Number for each ticket
Title:CreateTicketScreenTitleText.Text,
Priority: CreateTicketScreenPriorityDropDown.SelectedText.Value,
Author:MyProfile.Mail,
TaskStatus:"NOT STARTED",
PercentComplete: "0",
Created:Now(),
AssignedTO:"",
Description:CreateTicketScreenTaskDescription.Text,
Editor:MyProfile.Mail,
Modified:Now(),
Category:CreateTicketScreenCategoryDropDown.SelectedText.Value
}
)
Actually, I think it is not necessary to add another column to store the "Ticket Number" for each submitted ticket. If you use SP list as data source, you could use the system field -- ID as "Ticket Number". The "ID" column in SP List is a Auto-Increment Number column, you could use it as "Ticket Number" for each submitted ticket.
If you display the system "ID" column in your SP List, please try the following steps:
Please take a try with above solution, then check if the issue is solved.
Best regards,
