Designing Your SharePoint Database

by | Uncategorized | 0 comments

We will cover designing all of our SharePoint lists as our data source for our Power Apps, which will serve as our help desk software, IT Ticket System, IT service desk, customer support software, and help people on their help desk career. This is session #02 of our “Build a Power Apps Help Service Desk (Ticket System)”. Here is session 01: https://youtu.be/x_KRevCcYFg

Using Power Apps, we will be building a complete ticketing system from the beginning. A help desk, service desk, ticket system can be used in any organization for all kinds of purposes, even outside of an IT department. Think of any need for tasks or even projects to come in, assigned to someone, be tracked, transferred, communicated, and to oversee all of the work. We won’t be using an old Power Apps template that Microsoft provides. We’ll be building our own system. I will be helping you build one as you follow me step-by-step.

If you’re interested in using the app template Microsoft provides, then you will want to watch this video here: https://youtu.be/Bz8nhSDlhuE

0 Comments

Submit a Comment

Current Articles

Editing Hidden Fields

https://youtu.be/-_OrGrFVIP4 There is a time in every Power Apps application when you need to hide fields away from most of the users. Here, we'll step through an example of doing just this with a ticketing system we've been working on ! Building a Service Desk...

Managing Notes in Power Apps

https://youtu.be/9HybsTXvuYY In almost any Power Apps application, you will need a screen or a tab that will need to manage notes for one or more entities or database tables. In this video, we will go over doing a screen tab just for this. We'll filter and show notes...

Create Popup Windows

https://youtu.be/Egl2TDj0ge4 Create Popup Windows with Power Apps Here, we will create a popup dialog box or window to have the user enter more information that may not fit easily on the screen. This feature is something you may need to use for almost any type of...

Sum Formula

https://youtu.be/ltki_zoGNxo Using the Power Apps Sum Formula: Whenever you have a collection or table or gallery of values that you need to sum together, use the Sum function in Power Apps. Here, we'll take a look at an example where the values are inside a gallery,...

Email Notifications & Building a Dashboard

https://youtu.be/36ALTFrMtUw Today, we will cover how to send out email notifications from our application once a customer or user enters a ticket into our Service Desk system. They will want to know that we received their request and that we'll be working on it soon!...

Upload Images to Power Apps

https://youtu.be/XS0IJEE6uLo How to Upload Images to Power Apps? Almost any Power Apps application needs to be able to upload or add photos or images into the app, right? Let me show you my favorite way to do this in a live stream. You can ask questions or comment...

Add User Data into Power Apps

https://youtu.be/vIM2ERzWlsg In almost any app you use, you will need references to user data. In this video, I'll show you what I have found to be the best way to go about this. This is good for our application regarding user management. -Darren Neese with PowerApps...

Buttons and Variables

https://youtu.be/AKv1wn2QdZo We will cover the Power Apps Variable. Many times, you will need a variable to change things dynamically in your Power App. You will learn here how to set a variable with the Button's OnClick or OnSelect event. You will use this variable...

Questions & Answers

https://youtu.be/4WRJAmnrtXg Feel free to ask any questions regarding the Power Platform or Power Apps. I'll spend my lunch break today answering all your Power Apps questions. I'll also build a little app that will manage all the ideas for future videos I'll do!...

New Tabbed Ticket Screen

https://youtu.be/RFLdk7mr2Y4 This is the screen which our end users will enter a new ticket and request help with their issue. One time offer (for the first ten people who sign up!): https://learn.powerappstutorial.com/o... Here is the link to the student intake form:...