Skip to main content

Notifications

App Creator Portal (Version 1)

Hello,

 

I'm currently working on an App using the PowerApps Maker Connector that will allow app creators to document their apps and check compliance on apps they have created. The Support Form is stored in a SharePoint list in the background.

The form is based on a typical Support Procedure Manual, and is information IT typically require for new applications.

 

The compliance status is based on if the app has been published in the past 60 days, if the description is populated and if the Support Form has been completed.

 

Currently, the app only has two screens:


The front screen will give your PowerApps developer a view of their apps. This is achieved by using the PowerAppsforAppMakers connector, and getting the apps in the OnVisible event of the first screen:

ClearCollect(makerApps, PowerAppsforAppMakers.GetApps().value); 

The gallery display basic information of the app, a warning symbol if the app has no description and the compliance status - the Compliance Status is calculated in the "Fill" of the circle based on the sum of the Compliance criteria, so
If appVersion (published Date of the app) is more than 60 days ago = add 1
If description IsBlank = add 1
If Support Form is blank (in the SharePoint List) = add 1
Fill = If Compliance Value is 3 = Red, 2 = Orange, 1 = Yellow, 0 = Green to create a traffic light. 

Switch(
 Sum(
 If(
 DateDiff(
 properties.appVersion,
 Today()
 ) > 60,
 1,
 0
 ) + If(
 IsBlank(
 First(
 Filter(
 'SharePoint PowerApps List',
 Title = name
 )
 ).App_x0020_Overview
 ),
 1,
 0
 ) + If(
 IsBlank(properties.description),
 1,
 0
 )
 ),
 0, Green,
 1, Yellow,
 2, Orange,
 3, Red
)


Here's the front screen:

 

appcreator1.JPG

 

The app detail screen provides you with further details of the app, a breakdown of who the app is shared with, the ability to complete the Support Form (Submits to SharePoint) and a few action buttons to launch the app, launch the app properties, re-publish the app and email all users.

 

The App Compliance section is a Gallery, set to the following collection:

ClearCollect(appCompliance, 
{
Title: "Published in the last 60 days",
Status: If(DateDiff(
 'Maker App Gallery'.Selected.properties.appVersion,
 Today()) > 80, Red, If(DateDiff(
 'Maker App Gallery'.Selected.properties.appVersion,
 Today()) > 60, Orange, Green))
},
{
Title: "Submitted Support Manual (Form)",
Status: If(IsBlank(First(Filter('SharePoint PowerApps List', Title = 'Maker App Gallery'.Selected.name)).App_x0020_Overview), Red, Green)
},
{
Title: "Filled out app description",
Status: If(IsBlank('Maker App Gallery'.Selected.properties.description), Red, Green)
}
)

The App Roles are set to 

PowerAppsforAppMakers.GetAppRoleAssignment('Maker App Gallery'.Selected.name).value.properties

And I'm displaying the Name, Role and Type

Name: If(ThisItem.properties.principal.type = "Tenant", "Everyone in the organization", ThisItem.properties.principal.displayName)
Role: ThisItem.properties.roleName
Type: ThisItem.properties.roleName

 

appcreator2.JPG

 

The Email App Users button opens a pop-up, the Send To is pre-populated with all App Users based on the following filter and users can be removed from that collection using the X 

Filter(emailAppUserCollection, properties.roleName <> "Owner" && properties.principal.type <> "Tenant")

The Send Email uses the Office 365 Outlook connector to send the email

ForAll(emailAppUserCollection, Office365.SendEmailV2(properties.principal.email, 'Message Subject'.Text , 'Message Body'.Text, {Importance:"Normal"}));

appcreator4.JPG

 

The SharePoint list contains all columns for the Support Form:

appcreator3.JPG

 

Note: I have a seperate Flow using the Admin Connectors that stores basic app information in this list - this helps Service Managers check who has and hasn't completed the Support Form. If you do not have this pre-populated, the Support Form would need to be changed to save App Name, ID, Creator back to the SharePoint list.

 

This is Version 1 to document apps, and place governance and support closer in the hands of the app creator.

 

I want to work on a Version 2 that will include approval workflows to transition an app to a production / IT supported state (handover of the app to a L2 support team for example). 

 

Anything else you would like to see in the app, please let me know! 

 

Categories:

Comments

*This post is locked for comments