powerappsaudit | Bert Blevins | Power Apps Audit

M365 Solutions

6. Knowledge Transfer Worksheet App

Knowledge Transfer Worksheet App will be used to provide Dashboard for all KT Requests and provide option of print to PDF for multiple requests at a time.

  • We are using reusable header component for customizing logo and App Name.
  • We have customized Gallery control to look like Tabular data with header.
  • We are using Collection sort query to sort tabular data ascending and descending for all columns.
  • We have used reusable component to display user info using input properties for component.

7. License App

License App will be used to assign Office 365 License to the users in the Organization.

  • We are using reusable header component for Logo, App name and User info.
  • We are using Power OOTB Form control to capture License request and saving to SharePoint list.
  • We are using Power Automate to process the License request and assign Office 365 License to specific user.

8. OnBoarding App

OnBoarding App will be used to automate the process on OnBoarding new employee to the Organization. This App will provide options like adding used to Azure AD, Assigning Office 365 License and sending Offer Letter and other OnBoarding Document collection.

  • We are using reusable header component to customize Logo, App name and User info.
  • We are using global variable to have unique theme color for header and buttons across the App.
  • We are using Gallery control to customize the Dashboard UI with table header.
  • We are using collection filter, sort queries to sort and filter data.
  • We are using separate SharePoint list to capture log using version history to tract exact date of log, related to Time zone.
  • We have created customized Tiles view using Rectangle controls.
  • We are using Gallery control with rectangles to show the current workflow stage.

9. App Catalog App

App Catalog App will be used to display all the apps deployed to App Catalog.

10. CEP Image Capture

CEP Image Capture will be used to capture image from App and add longitude, latitude, tags for image.

  • We are using camera control to capture image and Image control under media to show the captured image.
  • We are converting captured image to base64 format and sending to Power Automate to save the same to SharePoint document library.
  • We are using navigation tools to capture the current co-ordinates where the picture is captured.
  • We are using map control to show where the picture has been taken.

11. Vendor setup App

Vendor setup app will be used to automate the process of Vendor Management such as Creating, Changing Vendor info followed by multiple approval process with notifications and activity log for tracking approvals

  • We are using reusable header component to customize Logo, App name and User info.
  • We are using global variable to have unique theme color for header and buttons across the App.
  • We are using Gallery control to customize the Dashboard UI with table header.
  • We are using collection filter, sort queries to sort and filter data.
  • We are using separate SharePoint list to capture log using version history to tract exact date of log, related to Time zone.

12. NSBuild App

NSBuild app is used to automate the manual process for adding Workstream, renewal of Workstream followed by around 20 approval steps and email notifications for each step.

  • We are using reusable header component in this app for customized Logo, App Name and User Info UI across all screens in the App.
  • We are using unique color theme for all headers, buttons using global variables.
  • We have designed reusable full form as component and using it for both submitter and Approvers.
  • We have created full form object as component input and output variables for data flow between app and form component.
  • We have more than 2k records in the data source, to overcome power app limitation of handling 2k records, we created batch Id in the data source and for every 2k records we assigned batch Id.
  • We are using batch Id and performing Concurrent query to fetch more than 2k records in the App.
  • We have dashboard screen that have multiple filter options with metadata filter properties for accurate results.
  • We are creating Document set to store the Workstreams and related attachment documents.
  • We are using SharePoint list to fetch all 20 approvers and approval step related information, this will enable us to change the approvers for each step and approval step information without any code change.
  • We are using separate configuration list for all Email notification templates, so admin can modify contents of email and other configurations without any code change.
  • We have provided option to change the approver incase existing approver is not available.
  • We are providing whole form print PDF option as well

Power Automate

SendEmailV3 will be used to send email using outlook connector, which will be called from Power App.

  • We are using Office 365 Outlook connector and Send Email V2 action for sending email.

AddLicense will be used to assign Office 365 License to users using Azure AD Connector, here we will create Azure AD Security group with Office 365 License Assigned. When ever we want to assign License to any user, we will add that user to specific Azure AD Security group.

  • We are searching for user by email using Office 365 search users action.
  • We are using Azure AD connector to get user details by user Id that we got from search user action.
  • We are finding weather the user is already part of the Azure AD License group.
  • We are adding the user to Azure AD License group.

This flow is used to rename the files inside SharePoint Library using Send HTTP Request action and SharePoint Connector.

  • We are using SharePoint connector and Send HTTP action with Rest API to rename File.

This flow is used to send Document for Digital sign to specific user using DocuSign Connector and Send Envelope action.

  • We are using DocuSign connector and Send Envelope action for sending document signature.

This flow is used to upload attachments to document library using SharePoint Connector, Add file action.

  • We are converting JSON string attachments data using Parse JSON action.
  • We are using loop to insert all attachments and using SharePoint connection, add File action.

This flow is used to add external user to Azure AD and send guest invite link using Azure AD Connector, HTTP action post method using MS Graph API.

  • We are using MS Graph API to send Guest Invite link to external users.
  • We are using HTTP action Post method to call MS Graph API.

This flow is used to get activity log from versions of SharePoint list item using SharePoint connector, send http request action.

  • We are using SharePoint connection and Send HTTP request action to fetch all versions of Activity log.
  • We are using loop to combine all logs by delimiter and sending to Power App.

8. OnBoarding AddDocumentSet

This flow is used to add Document set to specific SharePoint Library using SharePoint connector, Send HTTP request action.

  • We are using SharePoint connection and Send HTTP action Post method , SharePoint Rest API to create Document set.

9. GetSiteTimeZone

This flow is used to get SharePoint Site Time zone information using SharePoint connector, Send HTTP request action.

  • We are using SharePoint connection and Send HTTP action Post method , SharePoint Rest API to get Time zone details.

10. EncodeDecodeKey

This flow is used Encode, Decode Passphrase for E-Sign feature using Power Automate tools.

  • We are using Power Automate OOTB tools to encode and decode Passphrase.

11. HTML TO PDF

This flow is used to convert specific HTML markup to PDF file using OneDrive Connector, Convert File Action.

  • We are using OneDrive Connection, Convert file action to convert HTML file to PDF.

12. ITCC_GetUserProfile

This flow is used to fetch Office 365 User profile properties for Specific user using SharePoint connector, Send HTTP Action.

  • We are using SharePoint connection, send http action Rest API to get user profile properties.

29. Sign-Ins Dashboard

This Power BI dashboard gives high level and in details statistics of sign-in activity of the whole Office 365 tenant. We are using the CSV file from above component as source in Power BI.