Это видео недоступно.
Сожалеем об этом.
Complete Tutorial of Ticket Management Project in Canvas App PowerApps [Part 1]
HTML-код
- Опубликовано: 25 авг 2023
- "🎥 Welcome to Part 1 of in-depth tutorial on Ticket Management Project using Canvas App PowerApps! 🚀"
Please Note
I have provided the code for filter and data source at the end of description.
I skipped 3 filter in the video, now I have attached the code at the end if you are interested you can use below code, and see the working yourself.
Also Note: 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'
Also you can easily give colors to above card, I somehow forgot about them, so do that that yourself.
You guys can send me your version of this app in my mail address, also add some additional functionality
🔍 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.
Part 2 Link :
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
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 ✅
App = OnStart property:-
ClearCollect(col_TicketTypes,
{ ID:1, Ticket_Type:"All Tickets", Status:"All"},
{ ID:1, Ticket_Type:"New Tickets", Status:"New"},
{ ID:1, Ticket_Type:"Tickets in Progress", Status:"In Progress"},
{ ID:1, Ticket_Type:"Tickets on Hold", Status: "On Hold"},
{ ID:1, Ticket_Type:"Tickets Closed", Status: "Closed"},
{ ID:1, Ticket_Type:"Tickets older than 3 days", Status: "Other" },
{ ID:1, Ticket_Type:"Tickets opened today", Status: "Opened Today" },
{ ID:1, Ticket_Type:"Tickets closed today", Status: "Closed Today" }
);
ClearCollect(col_Tickets,
{ID:1, Department:"IT",Assigned_To: "",Comment:"", Subject:"Wifi not working", Description: "Wifi Issue, resolve as soon as possible", Status: "In Progress", Priority: "High", Date_Created: DateValue("08/23/2023"), Date_Closed:DateValue(Blank()), Owner: "Mark"},
{ID:2, Department:"IT",Assigned_To: "",Comment:"", Subject:"Download Power BI software", Description: "Unable to download Power BI software from IT store", Status: "New", Priority: "Low", Date_Created: DateValue("08/24/2023"), Date_Closed:DateValue(Blank()), Owner: "Ravi"},
{ID:3, Department:"IT",Assigned_To: "",Comment:"", Subject:"Not able to send mails", Description: "The wireless network seems to be down in Building 1. Can't access web, intranet, or email. ", Status: "In Progress", Priority: "Medium", Date_Created: DateValue("08/12/2023"), Date_Closed:DateValue(Blank()), Owner: "Sanju"},
{ID:4, Department:"IT",Assigned_To: "",Comment:"", Subject:"Certificate has expired", Description: "How to I fix the expired certificate message that keeps popping up?", Status: "New", Priority: "Low", Date_Created: DateValue("08/20/2023"), Date_Closed:DateValue(Blank()), Owner: "Eva"},
{ID:5, Department:"Facilities",Assigned_To: "",Comment:"", Subject:"Stand up desks in marketing", Description: "We'd like to swap out all six desks for standing desks and will need new chairs, too.1", Status: "New", Priority: "High", Date_Created: DateValue("08/25/2023"), Date_Closed:DateValue(Blank()), Owner: "Ivy"},
{ID:6, Department:"HR",Assigned_To: "",Comment:"", Subject:"Need assistance in filling ITR", Description: "Need Guidance of HR members in filling ITR", Status: "New", Priority: "Low", Date_Created: DateValue("08/23/2023"), Date_Closed:DateValue(Blank()), Owner: "Larry"}
);
Set(varCurrentStatus,"All")
Gallery - Data source (Items) property:
Switch(varCurrentStatus,
"All",col_Tickets,
"In Progress", Filter(col_Tickets, Status = varCurrentStatus),
"On Hold", Filter(col_Tickets, Status = varCurrentStatus),
"Closed", Filter(col_Tickets, Status = varCurrentStatus),
"New", Filter(col_Tickets, Status = varCurrentStatus),
"Other",Filter(col_Tickets, Abs(DateDiff(Now(),Date_Created)) 'Add GreaterThan_sign here'= 3),
"Opened Today",Filter(col_Tickets, Abs(DateDiff(Now(),Date_Created)) = 0),
"Closed Today",Filter(col_Tickets, Abs(DateDiff(Now(),Date_Closed)) = 0)
)
![Complete Tutorial of Ticket Management Project in Canvas App PowerApps [Part 2]](http://i.ytimg.com/vi/D5ZuvZy_e-k/mqdefault.jpg)
![Complete Tutorial of Ticket Management Project in Canvas App PowerApps [Part 2]](/img/tr.png)
Nice. I was looking for this and it is awesome to see you do it step by step. Now I am looking forward to complete this system. Thank you it helps me a lot.
Most welcome💫
Nice work. Thanks, Vinay.
Most welcome 💫
Hello waiting for the 2nd part of the video :)
Really big help
Most welcome 🤗
Remaining code is in description.
@christianmenez4849 : Here Part 2 link - ruclips.net/video/D5ZuvZy_e-k/видео.html
Thanks for the video... please make more projects
Most welcome
Thank you for your sharing Knowladge Thanks A Lot
Most Welcome, If you face any issue please watch Part 2 as well. I fixed all bugs there and also included SharePoint as Datasource.
Awesome. U deserve more likes and subscribers.
Thank you 💫
Very useful information ☺️. Nice
✅💫
Thanks Vinay, it will be great to attach DataSet in Excel form in upcoming projects
Most welcome, sure I will provide a Git Hub link as well if anyone wants to download the data or project they will be able to✅
@@lastminutecoders- Great Thanks Boss
Beautiful bro 🎉🎉🎉
@@ganeshrisk27 Thanks ✨
Hi Vinay,
Nice video we really appreciate your hard work.
But can we use SharePoint list instead of data collection's?
Please help me out
Thanks!
Worth Sharing . Thanks
Welcome💫... Do subscribe ❤️
@lastminutecoders Sure will subscribe. Is there an email feature to this .where users are been updated .
Haven't made mailing feature yet. If you wanna customize this app u can always connect with me (lastminutescode@gmail.com) my mail.... or through topmate 1:1 session (topmate.io/vinay_lmc)
Hi Vinay, let's add email that will notify the requester when the status change. Also, attachment incase the technician needs more clarification about the issue.
First I would like you to implement this.... I will soon cover extended video on this✅
Ok good.
Great 👍
Thank you💫
It's a great tutorial video ✨ thank you
I just want to know how backend source Excel file can connect to this Power app ?
Most welcome Siddhesh, yeah you can connect your local Excel file to SharePoint. There is one connector for that (Import from Excel).
Also you can migrate your Excel data to SharePoint or any cloud datasource than create a application. This is recommended way
Nice work. Thanks. If you add attaching screenshot or files option in the ticket, that will be great..
Most welcome ✨✨
Thanks a lot
Most welcome ✨✨
Thanks
Thank you✨✨✨
Hi Vinay, Thank you for the video , I have created a ticket tool same as like you in the video, but after completing the new tickets not saved in the tool if i give web refresh all the tickets gone , only one ticket is availble that is also model data which I give manually . Can you please tell me how to save the new tickets in the tool.
Mail me at lastminutescode@gmail.com .... I need to review your app what you r doing.
Hii Vinay Actually i need some help actually i didn’t get the col_types please solve this one it’s is urgent
Looking for service with comp no truck roll out
Thank you for the video. I have one query.
When I’m trying to insert the filter container gallery I am not able to see the collection table we created for status. “col_TicketTypes” is not visible for me when I want to connect a data source.
I checked your entire second video as well. Couldn’t find the solution. I mailed you as well.
Can you please help me
Did you get any update this issue. I too am facing the same issue
Excelente !! Gostaria de saber como você irá conectar à lista do SharePoint essa colection.
Thankyou, Sure!!
Project Part 2 link - ruclips.net/video/D5ZuvZy_e-k/видео.html
Hi, could you please explain what is ContentLanguage? Thanks
Have never used this property.... I don't really know but as its name says it may be related to the language that we are writing in a particular control.
I make apps in English language code en-US so I never had to do anything.
Hi Sir can you create a small video on how to delete tickets from List of All List please
I have used your tutorial for creating it can you please send me its logic of please can you tell it right now
I really need it I am creating tool request app for our organization and they gives me deadline for it
Please help me
how did you create the collection for the ticket types? i cant see it
I copied it from sample template, the code is in the description you can simply copy and paste it in your app-> OnStart property
Sir, thanks for the video. I don't understand one thing.. I have started following you recently and started making the ticketing system through this video however at 16:40, I don't know how you found the formula whereas I don't have the formula in my version. Can you please explain that because I am stuck
Most welcome 💫
I didn't found any formula,.........
ClearCollect code on OnStart property, I have written manually before recording this video.
All the code are in description section copy from there and paste in your app as well.
@propakistanigamer7337 Project Part 2 link - ruclips.net/video/D5ZuvZy_e-k/видео.html
I have the same problem
Yes but i doesent do anything :(@@lastminutecoders
@@dernamenlose13 brother I have written that code before recording the video.... All the codes are given in description section..... Still if you face any issue please you can always contact me at lastminutescode@gmail.com
Hi sir i follow you since you make this youtube channel and i also make this project but i have some issues
1) when i play this App it dosnt show anything when i play through edit mood it shows data
2) please make video on save data in dataverse in Modeldriven app
3) Make some flow
thanks
Hi aqueel, thankyou for your support.
Please mail me at lastminutescode@gmail.com with your issue.
I will make video on dataverse + model driven app very soon.
Project Part 2 link - ruclips.net/video/D5ZuvZy_e-k/видео.html
What data source did you use? Nice video
Collection as a data source. Thankyou💫
Can I use sharepoint as DB?
@@michaeljohnnaval5119 sure you can use any Data source
Project Part 2 link - ruclips.net/video/D5ZuvZy_e-k/видео.html
Is it available on PC and phone?
I can provide you source code if you want, contact me at lastminutescode@gmail.com
best app jab create karne ke baad jo data source connect karte on start app ke woh data source connect nhi hore he
In Part 2, .....all these issues I have shown how we can resolve.. please watch that as well.
Thankyou🌻
can you please provide the col_TicketTypes collection?
Code is in the description section
Hi Can u please help me "From where we get Ticket_type"when we edit formula in button in gallery" (refer video at 20.38 mins.) plz reply i m waiting .
Hi I’m also getting same error did you solve ?? Please help me if solve
Hi Sir can you create video on How to delete created tickets ?
You can use Remove or RemoveIf functions in order to delete created tickets.
Example RemoveIf(tbl_tickets, Ticket_ID=ThisItem.Ticket_ID)
@@lastminutecoders thanks also need one help I want if I publish this app then their should not be any tickets in app(All ticket-0) I mean 0 ticket in app when user create it then it will add in all tickets
Because currently we are on App Start creating some dummy tickets on it I don't want that
I have removed that but getting error as their Variable used in Updating Tickets so how to do that
I have used same your code and variable name also same as yours can you guide me here please
@@lastminutecoders Please reply Sir read my above comments please
I can't get multiple buttons in gallery3?
Mail me your issue at lastminutescode@gmail.com with attached screenshots.
Project Part 2 link - ruclips.net/video/D5ZuvZy_e-k/видео.html
1:43:07 I can felt that suffer... 😅
🥲
Help me please, i am stuck at 16:38, it does not work for me. Do i need to add a new table? It shows errors that it does not know "col_TicketTypes" and also if i hit "run app" it does not load like in the video. I finde your video super interesting and want to move on :(
Can i create the "col_TicketTypes" manually with sharepoint and then link it?
You can mail me lastminutescode@gmail.com
I don't know how or what you are doing so you can connect with me....
Also Note:
col_TicketTypes is the collection that I have created, in app on start property. You can find the code in description section just copy it and paste it in you app.on start property. And you will not see the error.
Hi, thx for your fast response, i did to 100% what u did in the video but it wont create the collection, thank you very much!
@@dernamenlose13 did u did run app on start???
Also you can mail me at lastminutescode@gmail.com I can connect with you and resolve your issue
Same problem here.
can you please share this project templete.
It's already there in your canvas app inside the template section with the name Service Desk
Yes its available , but no idea how to link with SharePoint list. can you please guide @@lastminutecoders
Please Use less "OK"s in your videos!
Ok ok
@@lastminutecoders 🤣