Microsoft Power Automate (Power App) Analyst/Developer

12+ month s contract

Remote

Job Description:

A Microsoft Power App will be built that uses data from SharePoint lists and will use power automate to send customer notifications. This power app will need a user authentication upon opening the application based on roles defined in a SharePoint list, these roles will limit certain user roles to screens they will use in the customer notification process

There will be 3 different roles when the user is being authenticated:

1: Admin: Can view and submit outages/maintenance notifications on both Operations and Support Screens
2: Support: Can view/edit submissions from operations and submit outages/Maintenance notifications to customers
3: Operations: Submits outages/maintenance notifications to support
4: Support Manager: Has the same permissions as support but approves submissions before sent to customers

This power app will connect via different SharePoint lists for data verification for customers and where the information is held once a notification is submitted from operations and sent out to customers from support. Four (4) different SharePoint lists that will be connected:

1. 
   Customer and Products
   a. This list contains all customers, products, environment, and modules designated for each customer
   2. Notification List
   a. This SharePoint list will house all notifications that are submitted from operations and sent out to customers from support
   3. Users and Roles
   a. This list contains all users that can use the power app, and the role they have to access certain parts of the power app (Admin, Support, Operations)
   4. Account Statuses
   a. Contains a list of all support accounts on customer tenants, this is used for account deactivation notifications to customers.

Once notifications have been submitted Support and Operations can see a live view of current outages/maintenances that haven t been completed or resolved yet. This live view can allow users from the operations/support side to update a current outage/maintenance or resolve it. Once a user has submitted an update, initial, resolution, or completed maintenance, outage, rca, or general notification it provide the end user a preview of what it will look like to the customer and will get sent to a support manager to verify everything is correct and can be sent out to customers. Power Automate will be used to read the notification list submissions and send out notifications to customers once managers have approved. The 2nd power app will be used to manage internal DLs, the powerapp will provide a view for current DLs a user is an admin of and can manage. Upon opening a DL it will show all members of the DL. This will connect through outlook and admins who manage DLs will use this to verify internal DLs contain the right individuals. These DLs are used for the customer notifications.