Answered

Help Desk Template - Edit Tickets Are Not Saving Updates

(0) Share

Report

Posted on by tlbiro

I'm new to using power apps and have had a heck of a time getting this help desk template working like it's supposed to. I am able to get my tickets to appear in sharepoint but when I edit/update them in admin login within the app, none of the changes are saved let alone updated to sharepoint. For example, assign the ticket to myself, change the percent complete to 50%, click update and it just resets everything back to it's original status. If anyone could help with guiding me in the right direction to maintain the updated changes I would greatly appreciate it. Here is the code for when the update button is selected (OnSelect):

If(isAdmin,
 Patch(TicketList,LookUp(TicketList,Id=SelectedTicket.ID),{
 
 Priority:EditTicketScreenPriorityDropDown.SelectedText.Value,
 Category:EditTicketScreenCategoryDropDown.SelectedText.Value,
 TaskStatus:EditTicketScreenStatusDropdown.SelectedText.Value, 
 PercentComplete:EditTicketScreenCompletedSlider.Value/100,
 AssignedTO:AssignedToUserDisplayName,
 Editor:MyProfile.Mail,
 Modified:Now(),
 Description:EditTicketScreenDescriptionInput.Text
 }),

 Patch(TicketList,LookUp(TicketList,Id = SelectedTicket.ID),{
 Priority:EditTicketScreenPriorityDropDown.SelectedText.Value,
 Category:EditTicketScreenCategoryDropDown.SelectedText.Value,
 Editor:MyProfile.Mail,
 Modified:Now(),
 Description:EditTicketScreenDescriptionInput.Text
 }
)); 
Reset(EditTicketScreenCompletedSlider);
Reset(EditTicketScreenStatusDropdown);
Navigate(MyTicketsScreen,None)

Let me know if anymore information is needed.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

tlbiro 9 on at

Like
a
(0)

Report
Copy link

Link copied!
Ok I think I was able to figure it out. I removed some of the text from the original template and replaced it with my own. Here is the new code that I was able to get the updated status to save to the ticket and my SP list:

If(isAdmin, //Replaced ticketlist in the default template with my SP list called HelpDesk Patch(HelpDesk,LookUp(HelpDesk,ID=SelectedTicket.ID),{ //Removed the editor and modified column. You don't need these as these columns are already in SP by default. You will probably have to edit the view of your SP list to get them to appear. Priority:EditTicketScreenPriorityDropDown.SelectedText.Value, Category:EditTicketScreenCategoryDropDown.SelectedText.Value, TaskStatus:EditTicketScreenStatusDropdown.SelectedText.Value, PercentComplete:EditTicketScreenCompletedSlider.Value/100, AssignedTO:AssignedToUserDisplayName, Description:EditTicketScreenDescriptionInput.Text }), //Removed editor and modified column. Patch(HelpDesk,LookUp(HelpDesk,ID = SelectedTicket.ID),{ Priority:EditTicketScreenPriorityDropDown.SelectedText.Value, Category:EditTicketScreenCategoryDropDown.SelectedText.Value, Description:EditTicketScreenDescriptionInput.Text } )); //Removed reset(EditTicketScreenSlider), was having a problem with the percent bar not updating. Reset(EditTicketScreenStatusDropdown); Navigate(MyTicketsScreen,None)

I will mark this as solved but if anyone has any questions please let me know and I will do my best to clarify the process.

Thank you,

Was this reply helpful? Yes No
Adwene 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Thx for your update. Where do you enter this code? The update button?

Was this reply helpful? Yes No