web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Looking for Advice - T...
Power Apps
Answered

Looking for Advice - Tracking Apps

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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 🙂

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    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:

    Capture.PNG

     

    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

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 846

#2
Valantis Profile Picture

Valantis 532

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard