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
1. Watch Part 1 first, link: • Complete Tutorial of T... (Most of the functionality are covered in Part 1, In Part 2 I have fixed some minor bugs and also Changed Database from Collection to SharePoint)
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 RUclips 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);
Office365Outlook.SendEmailV2("[e-mail]",Label2_4.Text&"'s Ticket has been Uplated!","Hi Akash, Ticket for " & Label2_4.Text &" has been updated. Now the new priority is "&Dropdown1_2.Selected.Value & ". The Ticket has been Assigned to " & Dropdown1_4.Selected.Value & " Thank You!")
#project #canvasapps #powerapps #powerplatform #sharepoint #sharepointonline #projectdesignideas #outlook

[@abdulwahed2580]

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

[@lastminutecoders]

@@abdulwahed2580 very soon will conver, thank you for the feedback ✨

[@user-kt6cw7wh9j]

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

[@lastminutecoders]

Thankyou✨✨✨
Surely I am planning to bring a new video series on the Ticket management system.
With a New amazing looking UI which will be responsive.
Loaded with complex functionalities
Data validation
Security
Deep Linking
Approval mails
Etc.

[@Skaggs666]

Great video Vinay!

[@lastminutecoders]

Most welcome 💫

[@majapamajapa9548]

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

[@lastminutecoders]

Sure I will cover this topic.

[@suhailvk952]

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

[@lastminutecoders]

Sure, I will. It may take a week or 2.

[@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.

[@lastminutecoders]

Thank you buddy, watch my role based security video and implement that in this project.

[@luisj.rodriguez5849]

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

[@lastminutecoders]

Watch part 2 please, or copy code from description...
Thank you,✅💫

[@luisj.rodriguez5849]

Saw the video again and copied all the codes but the very first ticket doesn’t change all the others do except the first one

[@lastminutecoders]

@@luisj.rodriguez5849 mail me at [e-mail] , with your issue let me look into it.
Attach screenshots

[@clariceforrc3031]

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?

[@lastminutecoders]

Thank You🌟
*Steps to Change Name of App:*
Go to Setting -> General -> Name -> Click on Edit icon and change the name
*Step to change name of Control:*
Select the Control first
Go to Right hand side property section at the top you will see the name of that Control.
Double click on it and change the name
_Hope this answer your question_
If you have any other query you can mail me at [e-mail]

[@user-xe2un1hj9o]

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

[@lastminutecoders]

Mail me at [e-mail]

[@jasongerrity1499]

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?

[@lastminutecoders]

Yeah I saw your mail will reply to you back on weekends.
Kindly wait for 2 days.
Thank-you

[@MrDhanendran]

Need new version of code

[@user-sv7ct3up9h]

please make a video how to search items

[@lastminutecoders]

Sure I will

[@user-sv7ct3up9h]

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

[@lastminutecoders]

Mail me at [e-mail], I will share the code with you how you can send mail when issue is closed

[@Mrinal600]

👍