POC of PowerApps to replace TRACS

Project Description

Report-SPA

The request was initiated by Shakes Scott

  • Description of the new request

We want to test Microsoft PowerApps as a front-end to the current Excel sheet that the Production Coordinators use to manage the Study Guide Process. They currently only use TRACS for integration purposes

 

Some information as seen in comments

The first application, that was a concept app to see if powerapps could be able to replace Tracs, the license was free or included in the larger MS office license. I could use an on-premise MySQL database using a MySQL connector as a standard connector through a gateway.

In the meanwhile the MySQL connector was changed from standard to premium, that needs a minimum of Powerapps Plan 1 for a license. I didn’t know this and caused a lot of work just to realized NWU office 365 license include the Powerapps for office 365 and not Plan 1 that was assumed.

On 1 October 2019 Powerapps Plan 1 and 2 are being changed completely to an app/user/month or /user/month plans. We will need to buy +/- 65 app/user/month licenses to use the Powerapps apps.

This needs to be taken into consideration when considering Powerapps to develop apps that will use integration with backed systems. The connectors are not included in the MS 365 license.
On the other hand, it is still cheaper than the maintenance cost of a developed application or another bought application.

Documents

Project Progress

100%

Project Timing

  • Start
    Feb 22 2019
  • End
    Mar 31 2020

02/22/2019 03/31/2020

100%

Overall Project Completion

  • 20%
  • 60%

100%

  • 40%
  • 80%

1. SGC App Complete 100% Tasks 6 / 6

100%
Description

6 of 6 completedTasks

  • Allignment
  • Todo screen
  • Guide info
  • Upload of documents
  • Testing
  • Production

2. PC App Complete 100% Tasks 8 / 8

100%
Description

8 of 8 completedTasks

  • Spesifications
  • Todo
  • Become user
  • Send to format
  • Sign off
  • Sent to printer
  • Upload reused document
  • Admin

3. Formatting APP Complete 100% Tasks 3 / 3

100%
Description

3 of 3 completedTasks

  • To do screen
  • upload
  • Finisshed

4. Printer App Complete 100% Tasks 2 / 2

100%
Description

2 of 2 completedTasks

  • Get stockcode
  • Finalised

5. Testing Complete 100% Tasks 2 / 2

100%
Description

2 of 2 completedTasks

  • Testing
  • Get production environment ready

6. Production Complete 100% Tasks 5 / 5

100%
Description

5 of 5 completedTasks

  • Communication
  • Workshops on Potch Campus
  • Workshops on Vaal Campus
  • Workshops on Mafikeng Campus
  • Report

Project Discussion 4 Responses to POC of PowerApps to replace TRACS

  1. Workshops on all campuses was successfully completed Very good feedback was received. I will draft a report on this project within the following week as a closure to this project

    February 21, 2020 at 1:23 pm
    CIELLIE JANSEN VAN VUUREN
  2. Only reporting have to be developed All apps are on the production env and has been beta tested

    November 18, 2019 at 10:22 pm
    CIELLIE JANSEN VAN VUUREN
  3. The first application, that was a concept app to see if powerapps could be able to replace Tracs, the license was free or included in the larger MS office license. I could use an on-premise MySQL database using a MySQL connector as a standard connector through a gateway.

    In the meanwhile the MySQL connector was changed from standard to premium, that needs a minimum of Powerapps Plan 1 for a license. I didn’t know this and caused a lot of work just to realized NWU office 365 license include the Powerapps for office 365 and not Plan 1 that was assumed.

    On 1 October 2019 Powerapps Plan 1 and 2 are being changed completely to an app/user/month or /user/month plans. We will need to buy +/- 65 app/user/month licenses to use the Powerapps apps.

    This needs to be taken into consideration when considering Powerapps to develop apps that will use integration with backed systems. The connectors are not included in the MS 365 license.
    On the other hand, it is still cheaper than the maintenance cost of a developed application or another bought application.

    September 16, 2019 at 8:57 pm
    CIELLIE JANSEN VAN VUUREN
  4. 22 Feb 2019: The POC request was approved by the Project Management Board.

    February 19, 2019 at 9:32 am
    YVETTE LABUSCHAGNE

Leave a Reply