Qdabra

Microsoft SharePoint Business Applications Partner

We are proud to announce that Microsoft has selected Qdabra to join the SharePoint Business Apps Partner Program as a Charter Member. The first members of the SharePoint Business Apps Partner Program was announced at Ignite 2018, September 2018, and Qdabra is one of the 11 charter members.


Showcase: Power Platform


Ennis Electric:

Infraction Report System

Qdabra builds infraction report system for Ennis Electric, an award-winning electrical contractor

Overview

The infraction report system allows supervisors to electronically submit and review infraction reports for employees.

PowerApps combined with Flow has allowed us to solve very simple business workflows that had been previously challenging. Qdabra’s experience with these solutions and their advanced knowledge of SharePoint allowed us to implement and deploy quickly.Stephen Blankenship, Ennis Electric
PowerApps Application

The application stores data in a SharePoint list and uses other SharePoint list and SQL data sources to provide supplementary data.

From the initial screen, users can choose to create a new report, view all the reports, view reports for a specific employee, or view reports they have created based on status.

Viewing all reports, reports for a given employee, or my reports based on status navigates the user to a screen with a gallery, which allows the user to select a report to view in a display form.

Email Print View button executes a Flow – see Flow section for details.

If the user viewing the record is either the creator or the approver, and if the record is in a “Draft” status, a pencil icon is displayed in the upper right allowing the user to edit and resubmit the report.

The edit screen is also used for new reports. When creating a new report, the user is presented with help text:

Selecting an employee displays a data table with the previously created infraction reports for that employee. Clicking on the Notice Number re-opens the detail screen with that report loaded for display.

There is an area at the bottom of reports to capture employee signatures – the signature area is displayed in an overlay:

Saving a signature in the app attaches the signature JPG to the Infraction Report list item using Flow & a custom connector (see the Flow section for more details). This Flow runs when the edit form submit succeeds.

Flows

From the detail screen, a user can send themselves a “print view”. The button passes the list item ID for the current Infraction Report and the user’s email address to the Flow. The Flow then gets the list item, gets URLS for any signature attachment, and sends an HTML email to the user:

Since attachments are repeating, the Flow loops through them to get the URL for any signature URLs. Infraction Types are a multi-select, so those are also concatenated via a loop.

Another Flow is used to attach the signature files to the list item when / if the employee signs the report. A custom connector in PowerApps allows access to the Flow, which has an http request trigger. The app passes in the name of the attachment, the ID for the item to attach to, the image file, the site URL and the list name, to allow for use in other applications.


Modern Remodeling

Opportunities Solution

Overview

The Opportunities PowerApps Solution is an app that is currently being built to allow mobile users to view jobs and opportunities assigned to them, add notes, job site photos and submit new jobs while on site. Its backend solution uses SQL Server database connections as the data sources for queries and data submission.

Solution

Initially, the user is presented with a Welcome screen with navigations to view existing and create a new Opportunity.

The My Opportunities screen connects to a SQL database table to display data in a gallery, filtered by the current user as the Project Manager. It allows for refreshing the data, sorting and further filtering (TBA).

Selecting an item shows that Opportunity’s details:

The Contract Photos screen retrieves URLs from another SQL table and displays them as images:

The Notes screen retrieves all notes that were previously submitted for the selected Opportunity:

Clicking on the plus icon allows for adding and submitting a new note.

The new note submits to a separate database table that is set up with a trigger to then send data to Qdabra’s Database Accelerator (DBXL). The DBXL configuration is set up to render the row data into an XML file which then submits back into another database table.

Back to the Home screen, clicking New shows a new form that submits to another database table the same way as Notes.

The customer card uses a dropdown control that pulls from SQL, sorted in alphabetical order. It stores the value of the CustomerKey column while displaying the CustomerName column’s value.

The Camera icon switches to a screen with the Camera control, and a customized icon that serves as the Capture button:

The Capture button stores the image into a collection and displays the taken photo into another screen.

Outstanding Issues:

  • Forms currently do not submit new data into the table they are connected to. Editing existing items work however.
  • The collected image from the Camera control does not display the Collection (uses the URL column in the photos collection)