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 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
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.
#Metoo. I couldn't really follow the use of containers. Kindly do a step by step guide on the data collections or show how it can be done with sharepoint
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.
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
Sir I am not able to connect the data source That is Collection in APP section...what to do ...whenever i add data source to FilterGallery nothing happens ...means no source is added
Please try the method below (it worked for me) In the settings (Under 3 Dots in the Ribbon) -> Updates -> Search for "Analysis" -> Turn off the New Analysis Engine and refresh
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, Thanks for your video but I am facing this same problem- What should I do in this case?- 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
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.
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.
@@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
New analysis engine in your settings just disable that, then your collection should be displayed in data source Or Simply copy the name of your collection and paste it in the datasource property of your gallery
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
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.
@@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
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 :(
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.
![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💫
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 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
@@lastminutecoders
Which program did you use as a database, Dataverse or SharePoint List?
Does it require licenses?
Thanks for the video... please make more projects
Most welcome
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
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.
Nice work. Thanks, Vinay.
Most welcome 💫
Awesome. U deserve more likes and subscribers.
Thank you 💫
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!
#Metoo. I couldn't really follow the use of containers. Kindly do a step by step guide on the data collections or show how it can be done with sharepoint
Most welcome, there are 2 parts in 2 nd part I have shown this onlt
Nice work. Thanks. If you add attaching screenshot or files option in the ticket, that will be great..
Most welcome ✨✨
Great video ❤
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.
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.
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
@@bharathbushan-wc4gh did you get any update, I am also facing the same issue.
even I'm facing same issue
Very useful information ☺️. Nice
✅💫
Hi, If I create a service desk Ticketing system, should I create a database in SharePoint List for storage or not?
@@Tokyo2905 SharePoint or Dataverse it's your choice..... Dataverse can support more functions which are delegable
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
Sir I am not able to connect the data source That is Collection in APP section...what to do
...whenever i add data source to FilterGallery nothing happens ...means no source is added
Please try the method below (it worked for me)
In the settings (Under 3 Dots in the Ribbon) -> Updates -> Search for "Analysis" -> Turn off the New Analysis Engine and refresh
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
Samee error
Beautiful bro 🎉🎉🎉
@@ganeshrisk27 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, Thanks for your video but I am facing this same problem- What should I do in this case?- 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
enable it
Most welcome, for any technical help, please ping me on lastminutescode@gmail.com
Attach screenshots of the problem
Hii Vinay Actually i need some help actually i didn’t get the col_types please solve this one it’s is urgent
Is it available on PC and phone?
I can provide you source code if you want, contact me at lastminutescode@gmail.com
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.
Thanks a lot
Most welcome ✨✨
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
What might be wrong if "Collections" are not featuring under Data Source in "In your apps" dropdown.
For this app only.
New analysis engine in your settings just disable that, then your collection should be displayed in data source
Or
Simply copy the name of your collection and paste it in the datasource property of your gallery
@@lastminutecoders sir but then nothing happens..no data source is added
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
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
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
can you please provide the col_TicketTypes collection?
Code is in the description section
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
Great 👍
Thank you💫
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
Looking for service with comp no truck roll out
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🌻
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.
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
Thanks
Thank you✨✨✨
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
1:43:07 I can felt that suffer... 😅
🥲
Please Use less "OK"s in your videos!
Ok ok
@@lastminutecoders 🤣