Complete Tutorial of Ticket Management Project in Canvas App PowerApps [Part 2]

"🎥 Welcome to Part 2 of in-depth tutorial on *Ticket Management Project* using Canvas App PowerApps! 🚀"

*Please Note*
2. All Codes are provided below, you can copy paste then but you need to change the Names of Controls based on the Controls that you have in your screen.
3. In YouTube Description, I cannot write "Greater than" or "Less than" sign, so add the greater than sign where I have written *'Add GreaterThan_sign here'*

🔍 *What You'll Learn:*

*Building from Scratch:* No prior experience needed! We'll start from the ground up, guiding you through the process of setting up Canvas App PowerApps for your ticket projects.
*Intuitive User Interface:* Design a user-friendly interface that makes creating, assigning, and tracking tickets a breeze.
*Create as a SharePoint Data source* : You will learn how to make list in SharePoint with different data types and finally how you can retrieve data from SharePoint list to Canvas App and Save data from Canvas App to SharePoint list.
*Sending Mails:* You will learn to send mails from Canvas app using Office365Outllok connector.

*Related Searches*
Service Desk Project in Canvas App - Tutorial
Ticket Management Project in Canvas App - Tutorial
Complete Tutorial of Canvas App Project
Learn to make project in Canvas App PowerApps
Complete guide to make project in canvas app PowerApps
Project tutorial for Beginners in canvas app PowerApps
How to make projects in Canvas App using SharePoint as a Data source.

Do support my work by *SUBSCRIBING* to this Channel.🔔🔔🔔
_It takes lot of effort and time to make such videos._✅✅✅
*Share* it with your friends and colleagues!!💎💎💎
*Comment* you feedback as well.📑👇👇👇

*Updated Code below* ✅
*1. If you want to Use Collection as Data Source use below code*
_Code is provided in Description section of Part 1, copy from there_
*2. If you want to Use SharePoint as Data Source use below code*

*App --- On Start Property*
_Same Code for col_TicketTypes as shown in Part 1_
ClearCollect(col_Ticket,tbl_Tickets);
Set(varCurrentStatus,"All");

*Main Gallery --- Datasource property*
Switch(varCurrentStatus,
"All",col_Ticket,
"In Progress", Filter(col_Ticket, Status.Value = varCurrentStatus),
"On Hold", Filter(col_Ticket, Status.Value = varCurrentStatus),
"Closed", Filter(col_Ticket, Status.Value = varCurrentStatus),
"New", Filter(col_Ticket, Status.Value = varCurrentStatus),
"Other",Filter(col_Ticket, Abs(DateDiff(Now(),'Date Created')) 'Add GreaterThan_sign here'= 3),
"Opened Today",Filter(col_Ticket, Abs(DateDiff(Now(),'Date Created')) = 0),
"Closed Today",Filter(col_Ticket, Abs(DateDiff(Now(),'Date Closed')) = 0)
)

*Create Task Button --- On Select property*
Patch(tbl_Tickets,Defaults(tbl_Tickets),
{
Index_ID: If(IsEmpty(tbl_Tickets),1,First(Sort(tbl_Tickets,ID,SortOrder.Descending)).ID+1),
Owner: TextInput1.Text,
Subject: TextInput1_1.Text,
Priority: {Value:Dropdown1.Selected.Value},
Description: TextInput1_2.Text,
Department: {Value:Dropdown1_1.Selected.Value},
'Date Created': Now(),
Status: {Value:"New"},
Title:"New Record"
}
);
ClearCollect(col_Ticket,tbl_Tickets);
Notify("Ticket has been created Successfully!", NotificationType.Success);
Navigate(Screen1,ScreenTransition.Fade)

*Save button ---- On Select property*
If(Dropdown1_5.Selected.Value = "Closed",

Patch(tbl_Tickets,LookUp(tbl_Tickets,Index_ID=varID),
{
Priority: {Value:Dropdown1_2.Selected.Value},
Department:{Value:Dropdown1_3.Selected.Value},
Status: {Value:Dropdown1_5.Selected.Value},
'Assigned To':Dropdown1_4.Selected.Value,
Comment: TextInput1_4.Text,
'Date Closed':Now(),
Title:"Updated record"
}
),
Patch(tbl_Tickets,LookUp(tbl_Tickets,Index_ID=varID),
{
Priority: {Value:Dropdown1_2.Selected.Value},
Department:{Value:Dropdown1_3.Selected.Value},
Status: {Value:Dropdown1_5.Selected.Value},
'Assigned To':Dropdown1_4.Selected.Value,
Comment: TextInput1_4.Text,
Title:"Updated record"
}
)
);
ClearCollect(col_Ticket,tbl_Tickets);
Notify("Ticket has been updated Successfully!", NotificationType.Success);
Navigate(Screen1,ScreenTransition.Fade);

#project #canvasapps #powerapps #powerplatform #sharepoint #sharepointonline #projectdesignideas #outlook

[Arun-hfe]

Great Video Vinay! I would definitely enjoy a part 3, on more functions that we can add to our ticketing service.

[abdulwahed]

Great Video Vinay! I am waiting another project video, Thank so much.

[ganeshwaichal]

I have to add Attachments through this Ticket, what are the steps?

[luisj.rodriguez]

Great video! For some reason the first Ticket doesn’t update but all the other do, what can be causing this?

[MDIBRAHIMKHALIL-oj]

Hello Bo, I want add file attachment option in the create a new ticket page, How I do it, Could you please talk me, Thank you

[clariceforrc]

I saw your first video and it is amanzing. Thank you. Do you think I can change the name of labels (instead Ticket, I want to use Request) how can I do it?

[suhailvk]

Great. Brother can you please make a video on role based access

[majapamajapa]

Hi LMC, can you please do a videos on creating items in lists from excel using SharePoint http batch creation so that we can create large data with less time

[pritamparab]

How do i Make it user role based, like admin will have different screen and user will have different screen just to submit and see the status of the ticket and admin will have the dashboard of listed tickets and options to controll them? BTW great efforts makng this tutorials.

[jasongerrity]

I am running into issues as I'm using the People/Group type for my lists of both "Owner" and "Assigned To". However, I think the errors are you're using a text field in your example. How do I change all references of Owner and Assigned To to refer to the value of the People/Group type sharepoint list data type?

[khaderhussaon]

Hi Issue is Closed then how to send another mail like issue is fixed

[khaderhussaon]

please make a video how to search items