Looking for Advice - Tracking Apps

[Anonymous]

Hey all.

First, this is going to be a long post. Because I'm looking for an advice for 3 apps I’m doing. So, I need the optimal efficiency on doing them.

The first app is called Tasks app. This app will require people in my Organization about 50 of them, to post on this app what they are going to do today, and their managers can assign tasks to them too. And they will update it once it is

What I did on this app:

• I put all the tasks data on SharePoint Online list.
• I created 3 screen app, one for overview (gallery), second for editing, third for adding.
• Managers can see all tasks but employees can see their tasks only.

Questions about the first app:

1. Is there a better way to save my data on? For example, use SharePoint Online Task List?
2. Is there a way to design it better? Or use something other than PowerApps that can do it?

The second app is called Pipeline app. This is somehow similar to the first app but with more question to ask to Add a pipeline.

What I did on this app is the same on the first app.

Question about the second app:

1. How can I make overdue emails to be sent to the managers each morning at 8:00? I meant, how can I make the SharePoint Online check if Today() is bigger than the Deadline date, and send an email to the employee and his/her manager?

 The third app is called Ticketing System. This app I didn't do yet because I'm still learning. I need it so that all the people in the organization to use it 700+ people. The purpose is. Each customer who comes and requests a service, I want the Front Office employee to open a ticket with that service and to go through the normal documents flow, so we can track and it and know if it is violating SLA or not. And I want that employee to the ticket where it is but cannot do any edits until it is assigned to him to close it for example. And I want the managers to see everything. And I want to do One button ticket assigned. For example, if I create a Check Book Request ticket, and it is assigned to the Check Book Department, I want that employee from the Checks Department to see the Ticket and only press one button 'Next' and it will automatically be redirected to the right employee (under the work flow of the Check Book Request).

Questions about it:

1. What is the best way to do the ticketing system
2. Which SharePoint list to do?
3. How can I customize SLA Violation emails? And where to customize them? should I use Microsoft Flow to customize? or doesn't work on Flow?

Much appreciated guys thanks 🙂

[v-monli-msft · Accepted solution]

Hi @Anonymous,

1. You could use the Task list, it is also supported in PowerApps. Here is my Task list URL:

https://XXX.sharepoint.com/sites/TeamSite/Lists/Tasks/AllItems.aspx

Here is what you should put in PowerApps to connect to the task list:

2. You could have the deadline date compare with today in Flow condition. In Flow, please try to configure the Condition with the formula as following in advanced mode:

@lessOrEquals(triggerBody()?['Condition_ObjectName'], formatDateTime(utcnow(),'yyyy-MM-dd'))

3. SLA is not one of the available connectors in PowerApps/Flow. Please check if it could be registered and used as custom connector in PowerApps.

Register and use custom connectors in PowerApps

https://docs.microsoft.com/en-us/powerapps/register-custom-api

Cognitive Services with PowerApps using Custom Connectors

https://powerapps.microsoft.com/en-us/blog/cognitive-services-with-powerapps-using-custom-connectors/

Regards,

Mona